C_SSPPurchaseOrderStsForBPF

DDL: C_SSPPURCHASEORDERSTSFORBPF SQL: CSSPPOSTSFORBPF Type: view CONSUMPTION

PO Status in SSP Requisition Application

C_SSPPurchaseOrderStsForBPF is a Consumption CDS View that provides data about "PO Status in SSP Requisition Application" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 7 fields with key field PurchaseOrder. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder _PurchaseOrderStsForBPF from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_PurchaseOrderApprover _PurchaseOrderApprover $projection.PurchaseOrder = _PurchaseOrderApprover.PurchaseOrder

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label PO Status in SSP Requisition Application view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CSSPPOSTSFORBPF view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder
Supplier I_PurchaseOrder Supplier
PurchasingProcessingStatus
ApproverName
PurchaseOrderType I_PurchaseOrder PurchaseOrderType
PurchasingOrganization I_PurchaseOrder PurchasingOrganization
PurchasingGroup I_PurchaseOrder PurchasingGroup 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'PO Status in SSP Requisition Application'
@AccessControl.authorizationCheck:#MANDATORY
@VDM.viewType : #CONSUMPTION
@AbapCatalog.sqlViewName: 'CSSPPOSTSFORBPF'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED


define view C_SSPPurchaseOrderStsForBPF
  as select from I_PurchaseOrder as _PurchaseOrderStsForBPF
 
  association [0..*] to C_PurchaseOrderApprover as _PurchaseOrderApprover on $projection.PurchaseOrder = _PurchaseOrderApprover.PurchaseOrder
 
{

  key _PurchaseOrderStsForBPF.PurchaseOrder as PurchaseOrder,
  
      // Supplier

      _PurchaseOrderStsForBPF.Supplier as Supplier,
      
      // Status

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement : true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MMPUR_SSP_PO_STS_TRA_EXIT'
      cast( ' ' as mmpur_doc_status ) as PurchasingProcessingStatus,
      
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement : true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MMPUR_SSP_PO_STS_TRA_EXIT'
      cast( ' ' as mm_approver_name ) as ApproverName,
      
      // FOR DCL Fields 

      
     _PurchaseOrderStsForBPF.PurchaseOrderType,
     
     _PurchaseOrderStsForBPF.PurchasingOrganization,
     
     _PurchaseOrderStsForBPF.PurchasingGroup
   
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER"
],
"ASSOCIATED":
[
"C_PURCHASEORDERAPPROVER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More