P_PURCHASEORDERITEMPAI_08

CDS View

P_PURCHASEORDERITEMPAI_08 is a CDS View in S/4HANA. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurchaseOrderItemPAI_09 view from CONSUMPTION

Fields (15)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
ConsumedQty ConsumedQty,RUNNING_TOTAL 1
CONT_DAYS_LEFT CONT_DAYS_LEFT 1
CONT_LEN CONT_LEN 1
DocumentCurrency DocumentCurrency 1
Plant Plant 1
PurchaseContract PurchaseContract 1
PurchaseContractItem PurchaseContractItem 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderCategory PurchaseOrderCategory 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderItem PurchaseOrderItem 1
RunningDays RunningDays 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1

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_08 (
    COMPANYCODE,
    CONSUMEDQTY,
    CONT_DAYS_LEFT,
    CONT_LEN,
    DOCUMENTCURRENCY,
    PLANT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDER,
    PURCHASEORDERCATEGORY,
    PURCHASEORDERDATE,
    PURCHASEORDERITEM,
    RUNNINGDAYS,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);