I_PURGINFORECDORGPLNTDATAAPI01

CDS View

Org Plant Data for Purch Info Record

I_PURGINFORECDORGPLNTDATAAPI01 is a CDS View in S/4HANA. Org Plant Data for Purch Info Record. It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/VSCEW/A_InfoRecord view_entity inner Product Info Record
/VSCEW/C_NSC_Procurement view_entity inner Neutral Supply Chain (External)
/VSCEW/C_NSC_Subcontracting view_entity inner Neutral Supply Chain (External)

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Plant Plant 2
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory 1
KEY PurchasingOrganization PurchasingOrganization 2
MaterialPlannedDeliveryDurn PlannedDeliveryDurationInDays 3
MinimumPurchaseOrderQuantity MinimumPurchaseOrderQuantity,MinLotSize 2
PurchaseOrderPriceUnit PurchaseOrderPriceUnit,QuantityUnit 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.

-- Org Plant Data for Purch Info Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGINFORECDORGPLNTDATAAPI01 (
    PLANT,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    MATERIALPLANNEDDELIVERYDURN,
    MINIMUMPURCHASEORDERQUANTITY,
    PURCHASEORDERPRICEUNIT,
    PRIMARY KEY (PLANT, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);