1. Home
  2. Resources
  3. SAP Tables
  4. CKML_MULTI_TREE - Structure for Displaying Multilevel Document as ALV Tree

SAP Table CKML_MULTI_TREE

Structure for Displaying Multilevel Document as ALV Tree

CKML_MULTI_TREE (Structure for Displaying Multilevel Document as ALV Tree) 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 CKML_MULTI_TREE to other SAP tables.

CKML_MULTI_TREE table fields

Field Data element Checktable Datatype Length Decimals
LEVEL Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 0
NODE_KEY ALV Tree Control: Node Key LVC_NKEY CHAR 12 0
HTEXT ALV Control: Cell Content LVC_VALUE CHAR 128 0
BVALT_NAME Procurement Alternative CKML_N_BALT CHAR 50 0
PROCESS_NAME Procurement Process CKML_N_PROC CHAR 50 0
VNPRD_EA Single-level adjustment to consumption from price difference CK_VNPRDEA CURR 15 2
VNKDM_EA Single-level adjustment to consumption from ExRt differences CK_VNKDMEA CURR 15 2
VNPRD_MA Multilevel adjustment to consumption from price differences CK_VNPRDMA CURR 15 2
VNKDM_MA Multilevel adjustment to consumption from exch. rt. diff. CK_VNKDMMA CURR 15 2
EBPRD_MA Multilevel Adjustment to End. Inv. Due to Price Differences CK_EBPRDMA CURR 15 2
EBKDM_MA Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CK_EBKDMMA CURR 15 2
ZUPRD_MO Receipts: Price Differences from Lower Levels CK_ZUPRDMO CURR 15 2
ZUKDM_MO Receipts: Exchange rate differences from lower level CK_ZUKDMMO CURR 15 2
ABPRD_MO Beginning Inventory: Price Differences from Lower Levels CK_ABPRDMO CURR 15 2
ABKDM_MO Beginning Inventory: Exch.Rate Differences from Lower Levels CK_ABKDMMO CURR 15 2
MULTILEVEL_DIF Multilevel Differences KKB_ML_ABWE_M CURR 15 2
SINGLELEVEL_DIF Single-Level Differences KKB_ML_ABWE_E CURR 15 2
SUM_PRDIF Sum of all price differences (settled single-/multi-level) CK_SUM_PRDIF CURR 15 2
SUM_KRDIF Sum of all exchange rate differences (single-/multi-level) CK_SUM_KRDIF CURR 15 2
SUM_DIF Sum of differences (settled sngl/multi-lvl price/ExRt diff.) CK_SUM_DIF CURR 15 2
ABRMENGE Price Determination Quantity CK_ABRMENGE QUAN 15 3
MODIF Type of BOM item CK_MODIF CHAR 1 0
NULL Actual quantity
F Minimum from target and actual quantity
Z Quantity is not considered
KTEXT General Name KTEXT CHAR 20 0
LTEXT Description KLTXT CHAR 40 0
OBART Object Type J_OBART CHAR 2 0
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

CKML_MULTI_TREE foreign key relationships

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