P_PURCHASEORDERITEMPAI

CDS View
8 Fields 2 CDS Views

P_PURCHASEORDERITEMPAI is a CDS View in S/4HANA. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PurchaseOrderItemPAI_01 view inner CONSUMPTION
P_PurchaseOrderItemPAI_08 view inner CONSUMPTION

Fields (8)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 2
Plant Plant 1
PurchaseContract PurchaseContract 2
PurchaseContractItem PurchaseContractItem 2
PurchaseOrder PurchaseOrder 2
PurchaseOrderCategory PurchaseOrderCategory 1
PurchaseOrderItem PurchaseOrderItem 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PURCHASEORDERITEMPAI (
    COMPANYCODE,
    DOCUMENTCURRENCY,
    PLANT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDER,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERITEM
);

Learn More