Deprecated
This CDS view is deprecated in S/4HANA. Use I_PurchaseOrderStatus instead. View all deprecated CDS views →

P_PurDocStat

DDL: P_PURDOCSTAT SQL: PPODOCSTAT Type: view CONSUMPTION

P_PurDocStat is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_PurchaseOrder, I_PurchaseOrderItem, C_Purdoclistpoitemstatusekbe, C_Purdoclistheadactstmsg) and exposes 2 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (4)

SourceAliasJoin Type
I_PurchaseOrder ekko left_outer
I_PurchaseOrderItem ekpo from
C_Purdoclistpoitemstatusekbe pos_ekbe left_outer
C_Purdoclistheadactstmsg pos_msg left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPODOCSTAT view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_PurchaseOrderStatus view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchasingDocumentItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item

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 P_PurDocStat.
-- 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.
-- SQL view name: PPODOCSTAT

CREATE VIEW P_PurDocStat AS
SELECT
  ekpo.PurchaseOrder AS PurchasingDocument,
  ekpo.PurchaseOrderItem AS PurchasingDocumentItem
FROM I_PurchaseOrderItem AS ekpo
LEFT OUTER JOIN I_PurchaseOrder AS ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_Purdoclistpoitemstatusekbe AS pos_ekbe ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_Purdoclistheadactstmsg AS pos_msg ON /* join condition not captured in parsed metadata */
;