I_PURCHASEORDERSTATUS

CDS View

Status of a purchase order

I_PURCHASEORDERSTATUS is a CDS View in S/4HANA. Status of a purchase order. It contains 2 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_PurchasingDocStatus view from CONSUMPTION
I_ChgImpactPOStatusText view from COMPOSITE Purchase Order Status Text
I_PurchaseOrderStatusText view from COMPOSITE Purchase Order Status text view
N_PurchaseOrderStatus view from Auxiliary view for Purchase Order Status
P_ContrRelvtCnsmdAmt view inner COMPOSITE
P_POItemStatus view from CONSUMPTION Status For PO Item
P_PURCHASEORDERSENDTOSUPPLR view inner CONSUMPTION Purchase order send to supplier
P_PurchaseOrderStatus view from CONSUMPTION Status logic for PO
P_PurOrdItemAcctAssgmt view inner CONSUMPTION Purchase Order Item Account Assignment

Fields (2)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
PurchasingDocumentStatus PurchaseOrderItemStatus 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.

-- Status of a purchase order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDERSTATUS (
    PURCHASEORDER,
    PURCHASINGDOCUMENTSTATUS,
    PRIMARY KEY (PURCHASEORDER)
);