I_PPS_PurchaseOrderProcessFlow

DDL: I_PPS_PURCHASEORDERPROCESSFLOW Type: view_entity COMPOSITE
31 Fields 2 Data Sources

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.

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 Purchasing Document
KEY PrecedingDocumentItem Purchasing Document Item
KEY SubsequentDocument Purchasing Document
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory Doc. Category
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderType _PurchaseOrder PurchaseOrderType PO Type
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
PurchaseRequisitionasPrecedingDocument
KEY PrecedingDocumentItem Purchasing Document Item
KEY SubsequentDocument POItem PurchaseOrder Purchasing Document
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory POItem PurchaseOrderCategory Doc. Category
PurchaseOrder POItem PurchaseOrder Purchasing Document
PurchaseOrderItem POItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderType PO Type
PurchasingGroup Purchasing Group
PurchaseContractasPrecedingDocument
KEY PrecedingDocumentItem Purchasing Document Item
KEY SubsequentDocument POItem PurchaseOrder Purchasing Document
KEY SubsequentDocumentItem
PrecedingDocumentCategory
SubsequentDocumentCategory POItem PurchaseOrderCategory Doc. Category
PurchaseOrder POItem PurchaseOrder Purchasing Document
PurchaseOrderItem POItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderType PO Type
PurchasingGroup Purchasing Group
PurchasingOrganization

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PPS_PurchaseOrderProcessFlow.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PPS_PurchaseOrderProcessFlow AS
SELECT
  PurchaseOrder AS PrecedingDocument,
  cast (PurchaseOrderItem as char10) AS PrecedingDocumentItem,
  cast (' ' as vdm_purchaseorder) AS SubsequentDocument,
  cast (cast (' ' as vdm_purchaseorderitem) as char10) AS SubsequentDocumentItem,
  _PurchaseOrder._PurchaseOrderType.PurchasingDocumentCategory AS PrecedingDocumentCategory,
  cast (' ' as bstyp) AS SubsequentDocumentCategory,
  PurchaseOrder,
  PurchaseOrderItem,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.PurchasingOrganization AS PurchaseRequisitionasPrecedingDocument,
  POItem._PurchaseOrder.PurchasingOrganization AS PurchaseContractasPrecedingDocument,
  POItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization
INNER JOIN I_Purchaserequisitionitem AS PR ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseContractItem AS PC ON /* join condition not captured in parsed metadata */
;

Learn More