P_MATERIALLEDGERDOCUMENT

CDS View
30 Fields 13 CDS Views

Material Ledger Document

P_MATERIALLEDGERDOCUMENT is a CDS View in S/4HANA. Material Ledger Document. It contains 30 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
P_ActlCostRsltActyClsgBase view_entity inner COMPOSITE Actual Costing Run Result Closing Line for Activity
P_ActlCostRsltActySettlmtDta view_entity inner COMPOSITE Actual Costing Run Result Settlement Data
P_ActlCostRsltActyTranBase view_entity inner COMPOSITE Actual Costing Run Result Transactional Data Base
P_ActlCostRsltActyTranWIP view_entity inner COMPOSITE Actual Costing Run Result Transactional WIP Data
P_DACRConsumptions view from COMPOSITE Consumptions for material from MLDOC
P_DACRCostComponentConsumption view inner COMPOSITE Consumptions for cost components in DACR
P_DACRCostComponentReceipts view inner COMPOSITE Receipts for cost components in DACR
P_DACRMLDOC view_entity from COMPOSITE MLDOC for DACR
P_DACRReceipts view from COMPOSITE Receipts for materials from MLDOC
P_DMVCActivityMaterialPair view from COMPOSITE DMVC: Activity/Material Pair
P_DMVCOpeningInventory view from COMPOSITE DMVC: Opening Inventory Values
P_InvtryTransBsdWithMvt view_entity from COMPOSITE Transactional based inventory with movement
P_InvtryTransBsdWOMvt view_entity from COMPOSITE Transactional based inventory without movement

Fields (30)

KeyField CDS FieldsUsed in Views
KEY aufnr OrderID 4
KEY categ MaterialLedgerCategory 6
KEY ControllingObject ControllingObject 1
KEY CostEstimate CostEstimate 8
KEY CurrencyRole CurrencyRole 1
KEY GLAccount GLAccount 1
KEY kstar GLAccount 1
KEY Ledger Ledger 8
KEY LedgerValuationCurrencyRole CurrencyRole 6
KEY MaterialLedgerCategory MaterialLedgerCategory 1
KEY MatlLdgrDocIsCostingRelevant MatlLdgrDocIsCostingRelevant 1
KEY OrderID OrderID 1
KEY ProcessCategory ProcessCategory 6
KEY ProcurementAlternative ProcurementAlternative 2
KEY ProductionProcess ProductionProcess 6
KEY ValuationArea ValuationArea 1
KEY xabr MatlLdgrDocIsCostingRelevant 6
awitem ReferenceDocumentItem 2
aworg ReferenceDocumentContext 2
awref ReferenceDocument 2
awtyp ReferenceDocumentType 2
Currency Currency 6
ExchRateDiffAmtInCoCodeCrcy ExchRateDiffAmtInCoCodeCrcy 2
FiscalYearPeriod FiscalYearPeriod 5
InventoryAmtInCCCrcy InventoryAmtInCCCrcy 5
PriceDiffAmtInDisplayCrcy PriceDiffAmtInDisplayCrcy 1
PriceDifferenceAmtInCCCrcy PriceDiffAmtInDisplayCrcy,PriceDifferenceAmtInCCCrcy 4
TotalVltdStockQuantity TotalVltdStockQuantity 1
ValuationQuantity TotalVltdStockQuantity,ValuationQuantity 4
ValuationQuantityUnit ValuationQuantityUnit,ValuationQuantityUnitInternal 7

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATERIALLEDGERDOCUMENT (
    AUFNR,
    CATEG,
    CONTROLLINGOBJECT,
    COSTESTIMATE,
    CURRENCYROLE,
    GLACCOUNT,
    KSTAR,
    LEDGER,
    LEDGERVALUATIONCURRENCYROLE,
    MATERIALLEDGERCATEGORY,
    MATLLDGRDOCISCOSTINGRELEVANT,
    ORDERID,
    PROCESSCATEGORY,
    PROCUREMENTALTERNATIVE,
    PRODUCTIONPROCESS,
    VALUATIONAREA,
    XABR,
    AWITEM,
    AWORG,
    AWREF,
    AWTYP,
    CURRENCY,
    EXCHRATEDIFFAMTINCOCODECRCY,
    FISCALYEARPERIOD,
    INVENTORYAMTINCCCRCY,
    PRICEDIFFAMTINDISPLAYCRCY,
    PRICEDIFFERENCEAMTINCCCRCY,
    TOTALVLTDSTOCKQUANTITY,
    VALUATIONQUANTITY,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (AUFNR, CATEG, CONTROLLINGOBJECT, COSTESTIMATE, CURRENCYROLE, GLACCOUNT, KSTAR, LEDGER, LEDGERVALUATIONCURRENCYROLE, MATERIALLEDGERCATEGORY, MATLLDGRDOCISCOSTINGRELEVANT, ORDERID, PROCESSCATEGORY, PROCUREMENTALTERNATIVE, PRODUCTIONPROCESS, VALUATIONAREA, XABR)
);

Learn More