I_MATLLDGRDOCUMENTITEMPRICE

CDS View
11 Fields 2 CDS Views

Material Ledger Document Item Prices

I_MATLLDGRDOCUMENTITEMPRICE is a CDS View in S/4HANA. Material Ledger Document Item Prices. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DebitCreditDocumentItem view_entity from COMPOSITE Material Ledger Debit Credit Items
I_PriceChangeDocumentItem view from COMPOSITE Material Ledger Document Item Details

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CurrencyRole CurrencyRole 2
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 2
FiscalYearPeriod FiscalYearPeriod 1
InventoryPrice InventoryPrice 2
MaterialPriceUnitQty MaterialPriceUnitQty 1
MovingAveragePrice MovingAveragePrice 2
PriceChangeCause PriceChangeCause 1
ProductPriceControl ProductPriceControl 2
StandardPrice StandardPrice 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.

-- Material Ledger Document Item Prices
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATLLDGRDOCUMENTITEMPRICE (
    CURRENCYROLE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGER,
    FISCALYEARPERIOD,
    INVENTORYPRICE,
    MATERIALPRICEUNITQTY,
    MOVINGAVERAGEPRICE,
    PRICECHANGECAUSE,
    PRODUCTPRICECONTROL,
    STANDARDPRICE,
    PRIMARY KEY (CURRENCYROLE, FISCALPERIOD, FISCALYEAR, LEDGER)
);

Learn More