SAP table MLCD (Material Ledger: Summarization Record (from Documents))

SAP table MLCD has 9 primary key fields being MANDT,KALNR,BDATJ,POPER,UNTPER,CATEG,PTYP,BVALT,CURTP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 * CK_KALNR
BDATJ Posting Date YYYY NUMC 4 0 BDATJ
POPER Posting period NUMC 3 0 POPER
UNTPER Value Structure Type NUMC 3 0 CK_UNTPER
CATEG Category in Material Ledger Data Display CHAR 2 0 CKML_CATEG
AB Beginning Inventory
EB Ending Inventory
KB Cumulative Inventory
NC Not Allocated
ND Not Distributed
NV Not Distributed (Obsolete)
PC Price Changes
VN Consumption
VP Other Receipts/Consumption
ZU Receipts
PTYP Process Category for Procurement Alt. or Consuption Alt. CHAR 4 0 * CK_PTYP_BVALT
BVALT Procurement Alternative/Process NUMC 12 0 * CKML_ALPROCNR
CURTP Currency type and valuation view CHAR 2 0 CURTP
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
LBKUM Total Valuated Stock QUAN 15 3 CK_LBKUM
MEINS Unit of Measure for Material Valuation UNIT 3 0 CKML_MEINS
SALK3 Value of Total Valuated Inventory CURR 15 2 CK_SALK3_1
ESTPRD Single-Level Price Differences CURR 15 2 CKML_ESTPRD
ESTKDM Single-Level Exchange Rate Differences CURR 15 2 CKML_ESTKDM
MSTPRD Multilevel Price Differences CURR 15 2 CKML_MSTPRD
MSTKDM Multilevel Exchange Rate Differences CURR 15 2 CKML_MSTKDM
WAERS Currency Key CUKY 5 0 WAERS
TPPRD Price Differences from Transfer Prices CURR 15 2 CKML_TPPRD
ESTKDM_ST Exchange Rate Differences Not Relevant to Inventory CURR 15 2 CKML_ESTKDM_ST