1. Home
  2. Resources
  3. SAP Tables
  4. CKMD_MLIT - Structure MLIT for the Display of Material Ledger Document

SAP Table CKMD_MLIT

Structure MLIT for the Display of Material Ledger Document

CKMD_MLIT (Structure MLIT for the Display of Material Ledger Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMD_MLIT to other SAP tables.

CKMD_MLIT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
POSNR Item in Material Ledger Document CK_MLPOS NUMC 6 0
URZEILE Original item in material or invoice document CK_URZEILE NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
MEINS Unit of Measure for Material Valuation CKML_MEINS T006 UNIT 3 0
SPART Division SPART TSPA CHAR 2 0
GSBER Business Area GSBER CHAR 4 0
BWMOD Valuation Grouping Code BWMOD CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
PSART Item type in material ledger document CK_PSART CHAR 2 0
CL Material Ledger Settlement
UP Material Ledger Update
PC Price Change
DC Debit/Credit Material
ST Single-Level Price Determination
MS Multilevel Price Determination
MI Input Material (Multilevel Price Determination)
MO Output Material (Multilevel Price Determination)
MB Beginning Inventory (Multilevel Price Determination)
MC Input Material: Currency Types Of Outputs (Multilvl Pr.Det.)
RE Material Ledger Repair
AT ML Update - Activity Consumption
AC Input-Activity Type/ABC Process (Multilevel Pr. Determ.)
CC Alternatice Valuation Run Closing
RC Revaluation of Consumption
RO Revaluation of Consumption to Original Account Assignment
RS Revaluation of Consumption to Collective Account Assignment
MA Manual Change of Actual Cost Component Splits
OC New Valuation Logical Inventory (Only IS-Oil)
WC WIP: Input Material: Currency Type Output
WI WIP: Input Material (Multilevel Price Determination)
WL WIP: Input Activity Type/ABC Process (Multilevel)
WP WIP Revaluation
WQ WIP Quantity Document (WIP Determination)
W1 Material (Total WIP Revaluation)
W2 Material (Process WIP Revaluation)
W3 Activity Type (Total WIP Revaluation)
W4 Activity Type (Process WIP Revaluation)
AL Activity Type/ABC Process Closing
MY Delta Posting Balance Sheet Valuation
BELNR_EA Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_EA Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
BELNR_MA Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_MA Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
ASCHEMA Material Update Structure CKML_ASCHEMA CHAR 4 0
PTYP Original process category CK_PTYP_ORG CHAR 4 0
PTYP_KAT Process category for category determination CK_PTYP_KAT CHAR 4 0
PTYP_BVALT Process category for procurement alt. or consuption alt. CK_PTYP_BVALT CHAR 4 0
PTYP_PROC Process category of the process CK_PTYP_PROC CHAR 4 0
BEWARTGRP Movement Type Group for ML Update CKML_MLBWG CHAR 2 0
KATEGORIE Category in Material Update Structure CKML_KATEGORIE CHAR 2 0
ZU Receipts
VP Other Receipts/Consumption
VN Consumption
BVALT Procurement alternative/process CKML_ALPROCNR NUMC 12 0
PROCESS Production Process CKML_F_PROCNR NUMC 12 0
CSPLIT Apportionment Structure CSPLIT CHAR 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VBELP Item number of the SD document POSNR NUMC 6 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
XABRERR Indicates that error(s) occurred during last price determ. CK_XABRERR CHAR 1 0
NULL No error
B Valuation inconsistent
I Error in RW interface
K Account not found
M Material not found
N Price will be negative
P Price change not allowed: too high
S Material is blocked
Z Other error
BELNR_CONS Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_CONS Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
BELNR_WIP Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR_WIP Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
LBKUM Quantity by which the total valuated inventory has changed CK_LBKUMD QUAN 15 3
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
SALK3 Amount by which the total valuated inventory changes CK_SALK3D CURR 15 2
WAERS Currency Key WAERS CUKY 5 0
KTEXT General Name KTEXT CHAR 20 0

CKMD_MLIT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMD_MLIT BUKRS CKMD_MLIT MANDT T001 Company Codes MANDT
CKMD_MLIT BUKRS CKMD_MLIT BUKRS T001 Company Codes BUKRS
CKMD_MLIT BWKEY CKMD_MLIT MANDT T001K Valuation area MANDT
CKMD_MLIT BWKEY CKMD_MLIT BWKEY T001K Valuation area BWKEY
CKMD_MLIT BWTAR CKMD_MLIT BWTAR T149D Global Valuation Types BWTAR
CKMD_MLIT BWTAR CKMD_MLIT MANDT T149D Global Valuation Types MANDT
CKMD_MLIT KTOPL CKMD_MLIT MANDT T004 Directory of Charts of Accounts MANDT
CKMD_MLIT KTOPL CKMD_MLIT KTOPL T004 Directory of Charts of Accounts KTOPL
CKMD_MLIT MANDT CKMD_MLIT MANDT T000 Clients MANDT
CKMD_MLIT MATNR CKMD_MLIT MANDT MARA General Material Data MANDT
CKMD_MLIT MATNR CKMD_MLIT MATNR MARA General Material Data MATNR
CKMD_MLIT MEINS CKMD_MLIT MANDT T006 Units of Measurement MANDT
CKMD_MLIT MEINS CKMD_MLIT MEINS T006 Units of Measurement MSEHI
CKMD_MLIT SPART CKMD_MLIT MANDT TSPA Organizational Unit: Sales Divisions MANDT
CKMD_MLIT SPART CKMD_MLIT SPART TSPA Organizational Unit: Sales Divisions SPART