MLDOC

Transparent Table Application Table
82 Fields 22 CDS Views

Material Ledger Document

MLDOC is an SAP database table in S/4HANA. Material Ledger Document. It contains 82 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
FCML_CCS_R_AVR_DDL view union_all CDS View w.struct.of FCML_CCS_REP f. AVR
FCML_CCS_R_AVR_DDL view from CDS View w.struct.of FCML_CCS_REP f. AVR
FCML_CCS_REP_DDL view from CDS View w.struct. of table FCML_CCS_REP
FCML_FIND_MLDOC_WRONG_BUDAT_V view from CDS View to detect wrong BUDAT in MLDOC
FCML_MLDOC_EMPTY_BUDAT_DDL view from CDS View to detect empty BUDAT in MLDOC
FCML_REP_AVR_DDL view union_all CDS View struct.of table FCML_REP f. AVR
FCML_REP_AVR_DDL view from CDS View struct.of table FCML_REP f. AVR
Fcml_Rep_Ddl view from CDS View with structure of table FCML_REP
fcml4h_cds_mldocahd view left_outer CKMLLAHD x MLDOC
fcml4h_cds_mldochd view left_outer CKMLHD x MLDOC
ml4h_cds_categ_h view from Read Category Helper
ML4H_CDS_CONSUMP view from Sum of consumption with WIP Reduction
ML4H_CDS_CONSUMP_CCS view from Sum of consumption CCS with WIP Reduction
ML4H_CDS_MLDOCAHD view left_outer CKMLLAHD x MLDOC
ML4H_CDS_MLDOCCCSHD view left_outer CKMLHD x MLDOC x MLDOCCCS
Ml4h_Cds_Mldochd view left_outer CKMLHD x MLDOC
ml4h_cds_mv003 view from Mapping MLDOC at MV003
ml4h_cds_mv004 view from Mapping MLDOC at MV004
ML4H_CDS_VMV view from Value Flow Monitor
ml4h_cds_wipred_help view from Read WIP Reduction
mlrunlist_ddl view inner CDS EDGEs Material Ledger f. HANA GRAPH
P_MaterialLedgerDocument view from COMPOSITE

Fields (82)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docref ML4H_DOCREF Document Reference
KEY curtp FINS_EXT_CURTYPE Crcy Type/Valn View
rldnr FINS_LEDGER Ledger
runref ML4H_RUNREF Costing Run Ref.
acc_principle ACCOUNTING_PRINCIPLE Accounting Principle
kalnr CK_KALNR Cost EstimateNo
jahrper ML4H_JAHRPER Year / Period
jahrper_wip ML4H_JAHRPER_WIP Year / Period of WIP
current_per ML4H_JAHRPER_CURRENT Curr. Year / Period
xabr ML4H_XABR Costing Doc.
glvor GLVOR Bus.transaction
vgart CK_VGART ML Trans. Type
posart ML4H_POSART Item type
categ CKML_CATEG Category
ptyp CK_PTYP_BVALT PrcCat-Pr/Cnalt
bewartgrp CKML_MLBWG Mvmt Type Group
bvalt CKML_ALPROCNR PrcrmntAlt/Proc
process CKML_F_PROCNR Prod. Proc. No.
pkalnr ML4H_KALNR_PMAT CE No. of Output
quant ML4H_QUANTITY Trans. Qty Val. Unit
meins ML4H_MEINS Val. Qty. Unit
stval ML4H_STVAL Trs. Invent. Value
prd ML4H_PRD Price Difference
kdm ML4H_KDM Exch.Rate Diff.
tpprd ML4H_TPPRD Prdif fr. Tansf.Pr.
altval ML4H_ALTVAL Alt. Inventory Value
waers WAERS Currency
lbkum ML4H_LBKUM Inv. Qty. / Val. UoM
salk3 ML4H_SALK3 Inventory Value
salkv ML4H_SALKV Alt. Invent. Value
stprs ML4H_STPRS Standard Price
pvprs ML4H_PVPRS MovAvg/PerUnit Prc
peinh ML4H_PRICEUNIT Price Unit
xekrel ML4H_XEKREL Rel. f. Purch. Acct.
xplrel ML4H_XPLREL Rel. f. Price Lim.
plqty ML4H_PLQTY Price Limiter Qty
markup ML4H_MARKUP Intercompany Profit
xtprel ML4H_XTPREL Transfer Price Rel.
vkwrt ML4H_VKWRT Sales Value
vksal ML4H_VKSAL Value at Sales Price
eqnum ML4H_EQNUM Equivalence No.
timestamp ML4H_TIMESTAMP Time Stamp
budat BUDAT Posting Date
cyclenr CK_CYCLENR Cycle Number
aufnr AUFNR Order
aufps CO_POSNR Item Number
belnr ML4H_BELNR Document Number
kjahr CK_KJAHR Document Year
posnr CK_MLPOS Item
awtyp AWTYP Ref. procedure
awsys AWSYS Logical System
aworg AWORG Refer. Org.Unit
awref AWREF Reference Doc.
awitem ML4H_AWITEM Ref. Doc. Line Item
awitgrp ML4H_AWITGRP Grp. RefDoc Items
usnam USNAM User Name
tcode TCODE Transaction Code
mlvnr CK_MLVNR ML Transactn No
vgabe CKI_VGAAU Transact. Type
hrkft ML4H_ORD_HRKFT Origin group order
kstar ML4H_ORD_KSTAR Cost Element Order
bwart BWART Movement Type
werks ML4H_ORD_WERKS Ord.Plant
storno ML4H_ORD_SETTLE_REV Ord.Settle.Reversal
bstmg ML4H_ORD_BSTMG Qty.Order
bstme ML4H_ORD_BSTME Unit.Order
arewr ML4H_ORD_AREWR Ord.GRIR.Val
reewr ML4H_ORD_REEWR Ord.Set.Value
xkdm_nact ML4H_KDM_NACT Capitalize E.R.Diffs
_dataaging DATA_TEMPERATURE Data Aging
kongr CKML_KONGR Reason
modgr CKML_MODGR Mod.Reason
sdm_version ML4H_SDM_VERSION SDM Version
xnopl ML4H_XNOPL Stock.Cov.Status
fbcase ML4H_FBCASE FB Case
fbprice ML4H_FBPRICE Fallback Price
extval ML4H_EXTVAL Ext.Valuation
xcut ML4H_XCUT Conn.Cut
stval_pc ML4H_STVAL Trs. Invent. Value
prd_pc ML4H_PRD Price Difference
waers_pc WAERS Currency

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLDOC (
    MANDT,          -- Client [MANDT]
    DOCREF,         -- Document Reference [ML4H_DOCREF]
    CURTP,          -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    RLDNR,          -- Ledger [FINS_LEDGER]
    RUNREF,         -- Costing Run Ref. [ML4H_RUNREF]
    ACC_PRINCIPLE,  -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    KALNR,          -- Cost EstimateNo [CK_KALNR]
    JAHRPER,        -- Year / Period [ML4H_JAHRPER]
    JAHRPER_WIP,    -- Year / Period of WIP [ML4H_JAHRPER_WIP]
    CURRENT_PER,    -- Curr. Year / Period [ML4H_JAHRPER_CURRENT]
    XABR,           -- Costing Doc. [ML4H_XABR]
    GLVOR,          -- Bus.transaction [GLVOR]
    VGART,          -- ML Trans. Type [CK_VGART]
    POSART,         -- Item type [ML4H_POSART]
    CATEG,          -- Category [CKML_CATEG]
    PTYP,           -- PrcCat-Pr/Cnalt [CK_PTYP_BVALT]
    BEWARTGRP,      -- Mvmt Type Group [CKML_MLBWG]
    BVALT,          -- PrcrmntAlt/Proc [CKML_ALPROCNR]
    PROCESS,        -- Prod. Proc. No. [CKML_F_PROCNR]
    PKALNR,         -- CE No. of Output [ML4H_KALNR_PMAT]
    QUANT,          -- Trans. Qty Val. Unit [ML4H_QUANTITY]
    MEINS,          -- Val. Qty. Unit [ML4H_MEINS]
    STVAL,          -- Trs. Invent. Value [ML4H_STVAL]
    PRD,            -- Price Difference [ML4H_PRD]
    KDM,            -- Exch.Rate Diff. [ML4H_KDM]
    TPPRD,          -- Prdif fr. Tansf.Pr. [ML4H_TPPRD]
    ALTVAL,         -- Alt. Inventory Value [ML4H_ALTVAL]
    WAERS,          -- Currency [WAERS]
    LBKUM,          -- Inv. Qty. / Val. UoM [ML4H_LBKUM]
    SALK3,          -- Inventory Value [ML4H_SALK3]
    SALKV,          -- Alt. Invent. Value [ML4H_SALKV]
    STPRS,          -- Standard Price [ML4H_STPRS]
    PVPRS,          -- MovAvg/PerUnit Prc [ML4H_PVPRS]
    PEINH,          -- Price Unit [ML4H_PRICEUNIT]
    XEKREL,         -- Rel. f. Purch. Acct. [ML4H_XEKREL]
    XPLREL,         -- Rel. f. Price Lim. [ML4H_XPLREL]
    PLQTY,          -- Price Limiter Qty [ML4H_PLQTY]
    MARKUP,         -- Intercompany Profit [ML4H_MARKUP]
    XTPREL,         -- Transfer Price Rel. [ML4H_XTPREL]
    VKWRT,          -- Sales Value [ML4H_VKWRT]
    VKSAL,          -- Value at Sales Price [ML4H_VKSAL]
    EQNUM,          -- Equivalence No. [ML4H_EQNUM]
    TIMESTAMP,      -- Time Stamp [ML4H_TIMESTAMP]
    BUDAT,          -- Posting Date [BUDAT]
    CYCLENR,        -- Cycle Number [CK_CYCLENR]
    AUFNR,          -- Order [AUFNR]
    AUFPS,          -- Item Number [CO_POSNR]
    BELNR,          -- Document Number [ML4H_BELNR]
    KJAHR,          -- Document Year [CK_KJAHR]
    POSNR,          -- Item [CK_MLPOS]
    AWTYP,          -- Ref. procedure [AWTYP]
    AWSYS,          -- Logical System [AWSYS]
    AWORG,          -- Refer. Org.Unit [AWORG]
    AWREF,          -- Reference Doc. [AWREF]
    AWITEM,         -- Ref. Doc. Line Item [ML4H_AWITEM]
    AWITGRP,        -- Grp. RefDoc Items [ML4H_AWITGRP]
    USNAM,          -- User Name [USNAM]
    TCODE,          -- Transaction Code [TCODE]
    MLVNR,          -- ML Transactn No [CK_MLVNR]
    VGABE,          -- Transact. Type [CKI_VGAAU]
    HRKFT,          -- Origin group order [ML4H_ORD_HRKFT]
    KSTAR,          -- Cost Element Order [ML4H_ORD_KSTAR]
    BWART,          -- Movement Type [BWART]
    WERKS,          -- Ord.Plant [ML4H_ORD_WERKS]
    STORNO,         -- Ord.Settle.Reversal [ML4H_ORD_SETTLE_REV]
    BSTMG,          -- Qty.Order [ML4H_ORD_BSTMG]
    BSTME,          -- Unit.Order [ML4H_ORD_BSTME]
    AREWR,          -- Ord.GRIR.Val [ML4H_ORD_AREWR]
    REEWR,          -- Ord.Set.Value [ML4H_ORD_REEWR]
    XKDM_NACT,      -- Capitalize E.R.Diffs [ML4H_KDM_NACT]
    _DATAAGING,     -- Data Aging [DATA_TEMPERATURE]
    KONGR,          -- Reason [CKML_KONGR]
    MODGR,          -- Mod.Reason [CKML_MODGR]
    SDM_VERSION,    -- SDM Version [ML4H_SDM_VERSION]
    XNOPL,          -- Stock.Cov.Status [ML4H_XNOPL]
    FBCASE,         -- FB Case [ML4H_FBCASE]
    FBPRICE,        -- Fallback Price [ML4H_FBPRICE]
    EXTVAL,         -- Ext.Valuation [ML4H_EXTVAL]
    XCUT,           -- Conn.Cut [ML4H_XCUT]
    STVAL_PC,       -- Trs. Invent. Value [ML4H_STVAL]
    PRD_PC,         -- Price Difference [ML4H_PRD]
    WAERS_PC,       -- Currency [WAERS]
    PRIMARY KEY (MANDT, DOCREF, CURTP)
);

Learn More