MLIT

Transparent Table Application Table
45 Fields 13 CDS Views

Material Ledger Document: Items

MLIT is an SAP database table in S/4HANA. Material Ledger Document: Items. It contains 45 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
FMLV_MLCR_UCT_UNION view inner Material Ledger Document: Currencies and Values w. correct CURTP
FMLV_MLCRF_UCT_UNION view inner Material Ledger Document: Field Groups (Currencies) with correct CURTP
FMLV_MLCRP_UCT_UNION view inner Material Ledger Document: Price Changes (Currencies, Prices) with correct CURTP
FMLV_MLKEPH_UCT_UNION view inner ML Document: CCS (Elements) for Values correct CURTP
FMLV_MLPRKEKO_UCT_UNION view inner ML Document: Cost Component Split (Header)for Prices with correct CURTP
FMLV_MLPRKEPH_UCT_UNION view inner ML Document: CCS (Components)for Prices with correct CURTP
FMLV_MLXXV_UCT view inner FMLV_MLXXV_UCT
FMLV_MLXXV_UCT_UNION view inner ML Document: Items and posting periods w. correct CURTP
ML4H_CDS_MLIT_CL view from Select all closing documents
P_MaterialLedgerDocumentItem view from BASIC
R_NonMigrtdMatlLdgrDocItmPrice view inner BASIC
R_NonMigrtdMatlLdgrDocItmReval view inner BASIC
R_NonMigrtdMatlLdgrDocItmValue view inner BASIC

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY belnr CK_BELNR Document Number
KEY kjahr CK_KJAHR Document Year
KEY posnr CK_MLPOS Item
urzeile CK_URZEILE Item
matnr MATNR Material
bwtar BWTAR_D Valuation Type
bwkey BWKEY Valuation Area
kalnr CK_KALNR Cost EstimateNo
meins CKML_MEINS Unit of Measure
spart SPART Division
gsber GSBER Business Area
bwmod BWMOD Val.Grpg Code
bukrs BUKRS Company Code
ktopl KTOPL Chart of Accts
mlast CK_ML_ABST Price Determ.
psart CK_PSART Item Type
belnr_ea CK_BELNR Document Number
kjahr_ea CK_KJAHR Document Year
belnr_ma CK_BELNR Document Number
kjahr_ma CK_KJAHR Document Year
aschema CKML_ASCHEMA MatlUpdateStr.
ptyp CK_PTYP_ORG Orig. Proc.Cat.
ptyp_kat CK_PTYP_KAT Cat-Process Cat
ptyp_bvalt CK_PTYP_BVALT PrcCat-Pr/Cnalt
ptyp_proc CK_PTYP_PROC Proc.-Proc.Cat.
bewartgrp CKML_MLBWG Mvmt Type Group
kategorie CKML_KATEGORIE Category
bvalt CKML_ALPROCNR PrcrmntAlt/Proc
process CKML_F_PROCNR Prod. Proc. No.
csplit CSPLIT Apportionment
vbeln VBELN SD Document
vbelp POSNR Item
pspnr PS_PSP_PNR WBS Element
lifnr LIFNR Supplier
kzbws KZBWS Valuation
xobew XOBEW Vendor stk val.
sobkz SOBKZ Special Stock
xabrerr CK_XABRERR Error w/ PrDeterm
belnr_cons CK_BELNR Document Number
kjahr_cons CK_KJAHR Document Year
belnr_wip CK_BELNR Document Number
kjahr_wip CK_KJAHR Document Year
prctr PRCTR Profit Center
posting_mode ML4H_POSTING_MODE Posting Mode

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: Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLIT (
    MANDT,         -- Client [MANDT]
    BELNR,         -- Document Number [CK_BELNR]
    KJAHR,         -- Document Year [CK_KJAHR]
    POSNR,         -- Item [CK_MLPOS]
    URZEILE,       -- Item [CK_URZEILE]
    MATNR,         -- Material [MATNR]
    BWTAR,         -- Valuation Type [BWTAR_D]
    BWKEY,         -- Valuation Area [BWKEY]
    KALNR,         -- Cost EstimateNo [CK_KALNR]
    MEINS,         -- Unit of Measure [CKML_MEINS]
    SPART,         -- Division [SPART]
    GSBER,         -- Business Area [GSBER]
    BWMOD,         -- Val.Grpg Code [BWMOD]
    BUKRS,         -- Company Code [BUKRS]
    KTOPL,         -- Chart of Accts [KTOPL]
    MLAST,         -- Price Determ. [CK_ML_ABST]
    PSART,         -- Item Type [CK_PSART]
    BELNR_EA,      -- Document Number [CK_BELNR]
    KJAHR_EA,      -- Document Year [CK_KJAHR]
    BELNR_MA,      -- Document Number [CK_BELNR]
    KJAHR_MA,      -- Document Year [CK_KJAHR]
    ASCHEMA,       -- MatlUpdateStr. [CKML_ASCHEMA]
    PTYP,          -- Orig. Proc.Cat. [CK_PTYP_ORG]
    PTYP_KAT,      -- Cat-Process Cat [CK_PTYP_KAT]
    PTYP_BVALT,    -- PrcCat-Pr/Cnalt [CK_PTYP_BVALT]
    PTYP_PROC,     -- Proc.-Proc.Cat. [CK_PTYP_PROC]
    BEWARTGRP,     -- Mvmt Type Group [CKML_MLBWG]
    KATEGORIE,     -- Category [CKML_KATEGORIE]
    BVALT,         -- PrcrmntAlt/Proc [CKML_ALPROCNR]
    PROCESS,       -- Prod. Proc. No. [CKML_F_PROCNR]
    CSPLIT,        -- Apportionment [CSPLIT]
    VBELN,         -- SD Document [VBELN]
    VBELP,         -- Item [POSNR]
    PSPNR,         -- WBS Element [PS_PSP_PNR]
    LIFNR,         -- Supplier [LIFNR]
    KZBWS,         -- Valuation [KZBWS]
    XOBEW,         -- Vendor stk val. [XOBEW]
    SOBKZ,         -- Special Stock [SOBKZ]
    XABRERR,       -- Error w/ PrDeterm [CK_XABRERR]
    BELNR_CONS,    -- Document Number [CK_BELNR]
    KJAHR_CONS,    -- Document Year [CK_KJAHR]
    BELNR_WIP,     -- Document Number [CK_BELNR]
    KJAHR_WIP,     -- Document Year [CK_KJAHR]
    PRCTR,         -- Profit Center [PRCTR]
    POSTING_MODE,  -- Posting Mode [ML4H_POSTING_MODE]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR)
);

Learn More