MLIT

Transparent Table Application Table
44 Fields 4 CDS Views

Material-Ledger-Beleg: Positionen

MLIT is an SAP database table in S/4HANA. Material-Ledger-Beleg: Positionen. It contains 44 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FMLV_MLCRF_UCT_UNION view inner Material Ledger Document: Field Groups (Currencies) with correct CURTP
FMLV_MLXXV_UCT view inner FMLV_MLXXV_UCT
ML4H_CDS_MLIT_CL view from Select all closing documents
P_MaterialLedgerDocumentItem view from BASIC Material Ledger document item

Fields (44)

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

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-Beleg: Positionen
-- 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]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR)
);

Learn More