_MATERIALLEDGERDOCUMENT

10 Fields

_MATERIALLEDGERDOCUMENT is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 2
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY LedgerValuationCurrencyRole LedgerValuationCurrencyRole 1
KEY ProcessCategory ProcessCategory 3
awitem ReferenceDocumentItem 1
awref ReferenceDocument 2
Currency Currency 2
InventoryAmtInCCCrcy InventoryAmtInCCCrcy 1
ValuationQuantity ValuationQuantity 1
ValuationQuantityUnit ValuationQuantityUnit 2

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 _MATERIALLEDGERDOCUMENT (
    COSTESTIMATE,
    FISCALYEARPERIOD,
    LEDGERVALUATIONCURRENCYROLE,
    PROCESSCATEGORY,
    AWITEM,
    AWREF,
    CURRENCY,
    INVENTORYAMTINCCCRCY,
    VALUATIONQUANTITY,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE, FISCALYEARPERIOD, LEDGERVALUATIONCURRENCYROLE, PROCESSCATEGORY)
);

Learn More