I_PURCHASINGINFORECORDAPI01

CDS View

Purchasing Info Record

I_PURCHASINGINFORECORDAPI01 is a CDS View in S/4HANA. Purchasing Info Record. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/VSCEW/A_InfoRecord view_entity from Product Info Record
/VSCEW/C_NSC_Procurement view_entity from Neutral Supply Chain (External)
/VSCEW/C_NSC_Subcontracting view_entity from Neutral Supply Chain (External)
C_PurchasingInfoRecordDEX view from CONSUMPTION Data Extraction for Purchasing Info Record

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Material Product 3
KEY PurchasingInfoRecord PurchasingInfoRecord 1
KEY Supplier Supplier 3
IsRegularSupplier IsRegularSupplier 1
MaterialGroup MaterialGroup 1
SupplierMaterialNumber SupplierMaterialNumber 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.

-- Purchasing Info Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGINFORECORDAPI01 (
    MATERIAL,
    PURCHASINGINFORECORD,
    SUPPLIER,
    ISREGULARSUPPLIER,
    MATERIALGROUP,
    SUPPLIERMATERIALNUMBER,
    PRIMARY KEY (MATERIAL, PURCHASINGINFORECORD, SUPPLIER)
);