MLDOC_EXTRACT

Transparent Table Application Table
12 Fields 6 CDS Views

Extract of Material Ledger Document

MLDOC_EXTRACT is an SAP database table in S/4HANA. Extract of Material Ledger Document. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FCMLDOC_EX_MAT_DDL view from Materials from MLDOC_EXTRACT
MLDOC_UCB_EXTRACT view_entity from MLDOC with joined UCB all records
MLDOC_UCB_EXTRACT view_entity union_all MLDOC with joined UCB all records
P_DACRMaterialHeaderExtract view from COMPOSITE DACR Material Extract with Material Header
P_MatlLedgerDocumentExtract view_entity from BASIC Extract of Material Ledger Document
P_MLDocumentExtract view from BASIC Material Ledger: Document Extract

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kalnr ck_kalnr Cost EstimateNo
KEY jahrper ml4h_jahrper Year / Period
KEY docref ml4h_docref Document Reference
KEY curtp fins_ext_curtype Crcy Type/Valn View
rldnr fins_ledger Ledger
quant ml4h_quantity Trans. Qty Val. Unit
meins meins Base Unit
stval ml4h_stval Trs. Invent. Value
vkwrt ml4h_vkwrt Sales Value
waers waers Currency
pdocref ml4h_docref Document Reference

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLDOC_EXTRACT (
    MANDT,    -- Client [mandt]
    KALNR,    -- Cost EstimateNo [ck_kalnr]
    JAHRPER,  -- Year / Period [ml4h_jahrper]
    DOCREF,   -- Document Reference [ml4h_docref]
    CURTP,    -- Crcy Type/Valn View [fins_ext_curtype]
    RLDNR,    -- Ledger [fins_ledger]
    QUANT,    -- Trans. Qty Val. Unit [ml4h_quantity]
    MEINS,    -- Base Unit [meins]
    STVAL,    -- Trs. Invent. Value [ml4h_stval]
    VKWRT,    -- Sales Value [ml4h_vkwrt]
    WAERS,    -- Currency [waers]
    PDOCREF,  -- Document Reference [ml4h_docref]
    PRIMARY KEY (MANDT, KALNR, JAHRPER, DOCREF, CURTP)
);

Learn More