I_OIL_LGCLINVTRYADJMTDOCITEM

CDS View
8 Fields 4 CDS Views

LIA Document item Data

I_OIL_LGCLINVTRYADJMTDOCITEM is a CDS View in S/4HANA. LIA Document item Data. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_OIL_ExchAgrmtLgclInvtryAdjmt view_entity from COMPOSITE Exchange Agreement LIA Document
I_OIL_ExchangesMovementData view_entity from COMPOSITE Composite For Exg Transactions
I_OIL_LgclInvtryBalAdjmt view_entity from BASIC LIA Doc Items Balance Adjustment
I_OIL_LgclInvtryPaytAdjmt view_entity from BASIC LIA DocItem for Negotiated payments

Fields (8)

KeyField CDS FieldsUsed in Views
KEY LgclInvtryAdjmtDocumentNumber LgclInvtryAdjmtDocumentNumber 2
KEY LgclInvtryAdjmtDocumentYear LgclInvtryAdjmtDocumentYear 2
KEY LgclInvtryAdjmtItmType LgclInvtryAdjmtItmType 1
ExchangeAgreement ExchangeAgreement 1
Material StockIdentifyingMaterial 1
Plant Plant 1
PostingDate PostingDate 1
StockKeepingUnitOfMeasure MaterialBaseUnit 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.

-- LIA Document item Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OIL_LGCLINVTRYADJMTDOCITEM (
    LGCLINVTRYADJMTDOCUMENTNUMBER,
    LGCLINVTRYADJMTDOCUMENTYEAR,
    LGCLINVTRYADJMTITMTYPE,
    EXCHANGEAGREEMENT,
    MATERIAL,
    PLANT,
    POSTINGDATE,
    STOCKKEEPINGUNITOFMEASURE,
    PRIMARY KEY (LGCLINVTRYADJMTDOCUMENTNUMBER, LGCLINVTRYADJMTDOCUMENTYEAR, LGCLINVTRYADJMTITMTYPE)
);

Learn More