I_OIL_MATERIALDOCUMENTITEM

CDS View
10 Fields 2 CDS Views

Exchange Material Document Item

I_OIL_MATERIALDOCUMENTITEM is a CDS View in S/4HANA. Exchange Material Document Item. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OIL_ExchangesMovementData view_entity union_all COMPOSITE Composite For Exg Transactions
I_OIL_ExchPurQuantityScaleFee view_entity from COMPOSITE EXG Purchase Quantity based Scale Fee

Fields (10)

KeyField CDS FieldsUsed in Views
KEY DebitCreditCode LgclInvtryAdjmtItmType 1
KEY ExchangeItemNumber ExchangeItemNumber 2
KEY LgclInvtryAdjmtDocumentYear LgclInvtryAdjmtDocumentYear 2
KEY MaterialDocument MaterialDocument 1
MaterialBaseUnit MaterialBaseUnit 2
Plant Plant 1
PostingDate PostingDate 1
StockIdentifyingMaterial StockIdentifyingMaterial 1
YearMonth YearMonth 1
YearWeek YearWeek 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.

-- Exchange Material Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OIL_MATERIALDOCUMENTITEM (
    DEBITCREDITCODE,
    EXCHANGEITEMNUMBER,
    LGCLINVTRYADJMTDOCUMENTYEAR,
    MATERIALDOCUMENT,
    MATERIALBASEUNIT,
    PLANT,
    POSTINGDATE,
    STOCKIDENTIFYINGMATERIAL,
    YEARMONTH,
    YEARWEEK,
    PRIMARY KEY (DEBITCREDITCODE, EXCHANGEITEMNUMBER, LGCLINVTRYADJMTDOCUMENTYEAR, MATERIALDOCUMENT)
);

Learn More