I_PPS_PurchaseOrderProcessFlow

DDL: I_PPS_PURCHASEORDERPROCESSFLOW Type: view_entity COMPOSITE

PPS Purchase Order Business Process FLow

I_PPS_PurchaseOrderProcessFlow is a Composite CDS View that provides data about "PPS Purchase Order Business Process FLow" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContractItem, I_Purchaserequisitionitem) and exposes 31 fields with key fields PrecedingDocument, PrecedingDocumentItem, SubsequentDocument, SubsequentDocumentItem, PrecedingDocumentItem.

2 data source(s) 31 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContractItem PC inner
I_Purchaserequisitionitem PR inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPS Purchase Order Business Process FLow view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument PurchaseOrder
KEY PrecedingDocumentItem
KEY SubsequentDocument
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
PurchaseOrderType _PurchaseOrder PurchaseOrderType
PurchasingGroup _PurchaseOrder PurchasingGroup
PurchaseRequisitionasPrecedingDocument
KEY PrecedingDocumentItem
KEY SubsequentDocument POItem PurchaseOrder
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory POItem PurchaseOrderCategory
PurchaseOrder POItem PurchaseOrder
PurchaseOrderItem POItem PurchaseOrderItem
PurchaseOrderType
PurchasingGroup
PurchaseContractasPrecedingDocument
KEY PrecedingDocumentItem
KEY SubsequentDocument POItem PurchaseOrder
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory POItem PurchaseOrderCategory
PurchaseOrder POItem PurchaseOrder
PurchaseOrderItem POItem PurchaseOrderItem
PurchaseOrderType
PurchasingGroup
PurchasingOrganization 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PPS Purchase Order Business Process FLow'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE
@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XL,
                usageType.dataClass: #MIXED
               }
define view entity I_PPS_PurchaseOrderProcessFlow
  as

  //PO

  select distinct from I_PurchaseOrderItem

{
  key PurchaseOrder                                                as PrecedingDocument,
  key cast (PurchaseOrderItem as char10)                           as PrecedingDocumentItem,

  key cast (' '  as vdm_purchaseorder)                             as SubsequentDocument,
  key cast (cast (' '  as vdm_purchaseorderitem) as char10)        as SubsequentDocumentItem,

      _PurchaseOrder._PurchaseOrderType.PurchasingDocumentCategory as PrecedingDocumentCategory,
      cast (' '  as bstyp)                                         as SubsequentDocumentCategory,

      PurchaseOrder,
      PurchaseOrderItem,
      _PurchaseOrder.PurchaseOrderType,
      _PurchaseOrder.PurchasingGroup,
      _PurchaseOrder.PurchasingOrganization
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

// PR -> PO

union all select distinct from I_PurchaseOrderItem       as POItem
  inner join                   I_Purchaserequisitionitem as PR on  PR.PurchaseRequisition     = POItem.PurchaseRequisition
                                                               and PR.PurchaseRequisitionItem = POItem.PurchaseRequisitionItem

{
  key PR.PurchaseRequisition                      as PrecedingDocument,
  key cast (PR.PurchaseRequisitionItem as char10) as PrecedingDocumentItem,

  key POItem.PurchaseOrder                        as SubsequentDocument,
  key cast (POItem.PurchaseOrderItem as char10)   as SubsequentDocumentItem,

      cast ('B' as bstyp)                         as PrecedingDocumentCategory,
      POItem.PurchaseOrderCategory                as SubsequentDocumentCategory,

      POItem.PurchaseOrder,
      POItem.PurchaseOrderItem,
      POItem._PurchaseOrder.PurchaseOrderType,
      POItem._PurchaseOrder.PurchasingGroup,
      POItem._PurchaseOrder.PurchasingOrganization
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

// PC -> PO

union all select distinct from I_PurchaseOrderItem    as POItem
  inner join                   I_PurchaseContractItem as PC on  PC.PurchaseContract     = POItem.PurchaseContract
                                                            and PC.PurchaseContractItem = POItem.PurchaseContractItem
{
  key PC.PurchaseContract                       as PrecedingDocument,
  key cast (PC.PurchaseContractItem as char10)  as PrecedingDocumentItem,

  key POItem.PurchaseOrder                      as SubsequentDocument,
  key cast (POItem.PurchaseOrderItem as char10) as SubsequentDocumentItem,

      cast ('K' as bstyp)                       as PrecedingDocumentCategory,
      POItem.PurchaseOrderCategory              as SubsequentDocumentCategory,

      POItem.PurchaseOrder,
      POItem.PurchaseOrderItem,
      POItem._PurchaseOrder.PurchaseOrderType,
      POItem._PurchaseOrder.PurchasingGroup,
      POItem._PurchaseOrder.PurchasingOrganization
}

Learn More