P_MATLLEDGERDOCUMENTEXTRACT

CDS View
6 Fields 7 CDS Views

Extract of Material Ledger Document

P_MATLLEDGERDOCUMENTEXTRACT is a CDS View in S/4HANA. Extract of Material Ledger Document. It contains 6 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_ActlCostgRunRsltBegInventory view_entity inner COMPOSITE Beginning Inventory
P_ActlCostgRunRsltBegInvtryDta view_entity inner COMPOSITE Beginning Inventory Data
P_ActlCostgRunRsltEndInventory view_entity inner COMPOSITE Ending Inventory
P_ActlCostgRunRsltEndInvtryDta view_entity inner COMPOSITE Ending Inventory Data
P_InvtryTransBsdMatlBegAndEnd view_entity from COMPOSITE Transaction-Based Material Beginning and Ending Inventory
P_InvtryTransBsdMatlBegAndEnd view_entity union_all COMPOSITE Transaction-Based Material Beginning and Ending Inventory
P_MatlLdgrDocXtrctActlCosting view_entity from COMPOSITE Sums of mldoc_extract - Actual Costing

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 6
KEY CurrencyRole CurrencyRole 6
KEY FiscalYearPeriod FiscalYearPeriod 3
KEY Ledger Ledger 6
Currency Currency 2
ValuationQuantityUnit ValuationQuantityUnit 6

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.

-- Extract of Material Ledger Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATLLEDGERDOCUMENTEXTRACT (
    COSTESTIMATE,
    CURRENCYROLE,
    FISCALYEARPERIOD,
    LEDGER,
    CURRENCY,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE, CURRENCYROLE, FISCALYEARPERIOD, LEDGER)
);

Learn More