SAP table CKML_MULTI_TREE (Structure for Displaying Multilevel Document as ALV Tree)

Field Description Data Type Length Decimals Checktable Data Element
LEVEL 1 Byte Unsigned Integer INT1 3 0 INT1
NODE_KEY ALV Tree Control: Node Key CHAR 12 0 LVC_NKEY
HTEXT ALV Control: Cell Content CHAR 128 0 LVC_VALUE
BVALT_NAME Procurement Alternative CHAR 50 0 CKML_N_BALT
PROCESS_NAME Procurement Process CHAR 50 0 CKML_N_PROC
VNPRD_EA Single-Level Adjustment to Consumption from Price Difference CURR 15 2 CK_VNPRDEA
VNKDM_EA Single-Level Adjustment to Consumption from ExRt Differences CURR 15 2 CK_VNKDMEA
VNPRD_MA Multilevel Adjustment to Consumption from Price Differences CURR 15 2 CK_VNPRDMA
VNKDM_MA Multilevel Adjustment to Consumption from Exch. Rt. Diff. CURR 15 2 CK_VNKDMMA
EBPRD_MA Multilevel Adjustment to End. Inv. Due to Price Differences CURR 15 2 CK_EBPRDMA
EBKDM_MA Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CURR 15 2 CK_EBKDMMA
ZUPRD_MO Receipts: Price Differences from Lower Levels CURR 15 2 CK_ZUPRDMO
ZUKDM_MO Receipts: Exchange Rate Differences from Lower Level CURR 15 2 CK_ZUKDMMO
ABPRD_MO Beginning Inventory: Price Differences from Lower Levels CURR 15 2 CK_ABPRDMO
ABKDM_MO Beginning Inventory: Exch.Rate Differences from Lower Levels CURR 15 2 CK_ABKDMMO
MULTILEVEL_DIF Multilevel Differences CURR 15 2 KKB_ML_ABWE_M
SINGLELEVEL_DIF Single-Level Differences CURR 15 2 KKB_ML_ABWE_E
SUM_PRDIF Sum of All Price Differences (Settled Single-/Multi-Level) CURR 15 2 CK_SUM_PRDIF
SUM_KRDIF Sum of All Exchange Rate Differences (Single-/Multi-Level) CURR 15 2 CK_SUM_KRDIF
SUM_DIF Sum of Differences (Settled Sngl/Multi-Lvl Price/ExRt Diff.) CURR 15 2 CK_SUM_DIF
ABRMENGE Price Determination Quantity QUAN 15 3 CK_ABRMENGE
MODIF Type of BOM Item CHAR 1 0 CK_MODIF
Actual quantity
F Minimum from target and actual quantity
Z Quantity is not considered
KTEXT General Name CHAR 20 0 KTEXT
LTEXT Description CHAR 40 0 KLTXT
OBART Object Type CHAR 2 0 J_OBART
MANDT Client CLNT 3 0 T000 MANDT
BELNR Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
POSNR Item in Material Ledger Document NUMC 6 0 CK_MLPOS
URZEILE Original Item in Material or Invoice Document NUMC 6 0 CK_URZEILE
MATNR Material Number CHAR 40 0 MARA MATNR
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BWKEY Valuation area CHAR 4 0 T001K BWKEY
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 * CK_KALNR
MEINS Unit of Measure for Material Valuation UNIT 3 0 T006 CKML_MEINS
SPART Division CHAR 2 0 TSPA SPART
GSBER Business Area CHAR 4 0 * GSBER
BWMOD Valuation Grouping Code CHAR 4 0 BWMOD
BUKRS Company Code CHAR 4 0 T001 BUKRS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
MLAST Material Price Determination: Control CHAR 1 0 CK_ML_ABST
2 Transaction-Based
3 Single-/Multilevel
PSART Item Type in Material Ledger Document CHAR 2 0 CK_PSART
BELNR_EA Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_EA Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
BELNR_MA Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_MA Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
ASCHEMA Material Update Structure CHAR 4 0 * CKML_ASCHEMA
PTYP Original Process Category CHAR 4 0 * CK_PTYP_ORG
PTYP_KAT Process Category for Category Determination CHAR 4 0 * CK_PTYP_KAT
PTYP_BVALT Process Category for Procurement Alt. or Consuption Alt. CHAR 4 0 * CK_PTYP_BVALT
PTYP_PROC Process Category of the Process CHAR 4 0 * CK_PTYP_PROC
BEWARTGRP Movement Type Group for ML Update CHAR 2 0 * CKML_MLBWG
KATEGORIE Category in Material Update Structure CHAR 2 0 CKML_KATEGORIE
VN Consumption
VP Other Receipts/Consumption
ZU Receipts
BVALT Procurement Alternative/Process NUMC 12 0 * CKML_ALPROCNR
PROCESS Production Process NUMC 12 0 * CKML_F_PROCNR
CSPLIT Apportionment Structure CHAR 4 0 * CSPLIT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
VBELP Item number of the SD document NUMC 6 0 POSNR
PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
XOBEW Vendor Stock Valuation Indicator CHAR 1 0 XOBEW
SOBKZ Special Stock Indicator CHAR 1 0 * SOBKZ
XABRERR Indicates that Error(s) Occurred During Last Price Determ. CHAR 1 0 CK_XABRERR
BELNR_CONS Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_CONS Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
BELNR_WIP Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR_WIP Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
PRCTR Profit Center CHAR 10 0 PRCTR
MAKTX Material Description CHAR 40 0 MAKTX
BDATJ Posting Date YYYY NUMC 4 0 BDATJ
POPER Posting period NUMC 3 0 POPER
LBKUM Quantity by Which the Total Valuated Inventory Has Changed QUAN 15 3 CK_LBKUMD
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
SALK3 Amount by Which the Total Valuated Inventory Changes CURR 15 2 CK_SALK3D
WAERS Currency Key CUKY 5 0 * WAERS

CKML_MULTI_TREE foreign key relationships

Table Field Check Table Check Field
0 CKML_MULTI_TREE BUKRS T001 Company Codes BUKRS
1 CKML_MULTI_TREE BWTAR T149D Global Valuation Types MANDT
1 CKML_MULTI_TREE BWTAR T149D Global Valuation Types BWTAR
0 CKML_MULTI_TREE KTOPL T004 Directory of Charts of Accounts MANDT
1 CKML_MULTI_TREE MANDT T000 Clients MANDT
0 CKML_MULTI_TREE MATNR MARA General Material Data MANDT
0 CKML_MULTI_TREE MATNR MARA General Material Data MATNR
1 CKML_MULTI_TREE MEINS T006 Units of Measurement MANDT
1 CKML_MULTI_TREE MEINS T006 Units of Measurement MSEHI
0 CKML_MULTI_TREE SPART TSPA Organizational Unit: Sales Divisions MANDT
0 CKML_MULTI_TREE SPART TSPA Organizational Unit: Sales Divisions SPART