MLDOC

Transparent Table Application Table
74 Fields 20 CDS Views

Material Ledger Document

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

CDS Views using this table (20)

ViewTypeJoinVDMDescription
FCML_CCS_R_AVR_DDL view from CDS View w.struct.of FCML_CCS_REP f. AVR
FCML_CCS_R_AVR_DDL view union_all 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 from CDS View struct.of table FCML_REP f. AVR
FCML_REP_AVR_DDL view union_all CDS View struct.of table FCML_REP f. AVR
Fcml_Rep_Ddl view from CDS View with structure of table FCML_REP
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 (74)

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

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]
    PRIMARY KEY (MANDT, DOCREF, CURTP)
);

Learn More