MLIT

Transparent Table Application Table
45 Fields 13 CDS Views

Material-Ledger-Beleg: Positionen

MLIT is an SAP database table in S/4HANA. Material-Ledger-Beleg: Positionen. 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-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]
    POSTING_MODE,  -- Posting Mode [ml4h_posting_mode]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR)
);

Learn More