IR

13 Fields

IR is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ChangeDocument ChangeDocument 1
KEY Plant Plant 1
KEY PurchasingInfoRecord PurchasingInfoRecord 1
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory 1
KEY PurchasingOrganization PurchasingOrganization 1
BOMHasHeaderInfoRecord BOMHasHeaderInfoRecord 1
CreationDate CreationDate 1
Currency Currency 1
Material Material 1
MaterialGroup MaterialGroup 1
NetPriceAmount IRNetPriceAmount 1
PurchasingGroup PurchasingGroup 1
Supplier Supplier 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 IR (
    CHANGEDOCUMENT,
    PLANT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    BOMHASHEADERINFORECORD,
    CREATIONDATE,
    CURRENCY,
    MATERIAL,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    PURCHASINGGROUP,
    SUPPLIER,
    PRIMARY KEY (CHANGEDOCUMENT, PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);

Learn More