1. Home
  2. Resources
  3. SAP Tables
  4. CKML_VFM_TREE - Display Structure for Value Flow Monitor (ALV_Tree)

SAP Table CKML_VFM_TREE

Display Structure for Value Flow Monitor (ALV_Tree)

CKML_VFM_TREE (Display Structure for Value Flow Monitor (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_VFM_TREE to other SAP tables.

CKML_VFM_TREE table fields

Field Data element Checktable Datatype Length Decimals
LEVEL Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 0
BUKRS Company Code BUKRS CHAR 4 0
BKLAS Valuation Class BKLAS CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
NODE_KEY ALV Tree Control: Node Key LVC_NKEY CHAR 12 0
HTEXT ALV Control: Cell Content LVC_VALUE CHAR 128 0
ICON Allocatable differences when price limiter quantity is 0 CKML_VFM_ICON CHAR 4 0
ICON_EST Single-Level Price Determination CKML_ICON_EST CHAR 4 0
ICON_MST Multilevel Price Determination CKML_ICON_MST CHAR 4 0
ICON_CLO Closing Entry ML_ICON_CLO CHAR 4 0
ICON_FIA Balance Between Price Difference Accounts and ML ML_ICON_FIA CHAR 4 0
STATUS Material ledger period status CK_MLSTAT NUMC 2 0
00 Undefined
01 New Objects
10 Period Opened
20 Price Change Completed
30 Quantities and Values Entered
31 Values Entered
40 Price Determined (Single-Level)
50 Price Determined (Multilevel)
60 Closing Entry Reversed
70 Closing Entry Completed
05 Period Without Stock Opened
MATNR Material Number MATNR CHAR 18 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
MTART Material Type MTART CHAR 4 0
MATKL Material Group MATKL CHAR 9 0
SPART Division SPART CHAR 2 0
PRCTR Profit Center PRCTR CHAR 10 0
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
WAERS Currency Key WAERS CUKY 5 0
MEINS Unit of Measure for Material Valuation CKML_MEINS UNIT 3 0
DIFF_NDI Differences: Not distributed CKML_DIFF_NDI CURR 15 2
DIFF_NIN Differences: Not included CKML_DIFF_NIN CURR 15 2
DIFF_CUM Cumulative Differences CKML_DIFF_CUM CURR 15 2
DIFF_RSC Consumption Revaluation: Differences CKML_DIFF_RSC CURR 15 2
DIFF_EIV Differences distributed to ending inventory CKML_DIFF_EIV CURR 15 2
DIFF_NLE Allocated multilevel differences CKML_DIFF_NLE CURR 15 2
DIFF_WIP WIP Revaluation Differences CKML_DIFF_WIP CURR 15 2
DIFF_VNO Differences From Retirements That Do Not Affect The Price CKML_DIFF_VNO CURR 15 2
DIFF_FIA Balance of Price Difference Accounts ML_DIFF_FIA CURR 15 2
DIFF_FIS Balance between Price Difference Account and Material Ledger ML_DIFF_FIS CURR 15 2
DIFF_UMB Revaluation Amount of the AVR Start Period ML_DIFF_UMB CURR 15 2
DIFF_ABC Manual Correction of Beginning Inventory Price Differences ML_DIFF_ABC CURR 15 2
VALUE_CUM Cumulative Inventory Value CKML_VALUE_CUM CURR 15 2
PB_PRICE Price after setting the price limiter quantity to zero CKML_PB_PRICE CURR 11 2
PRICE_CUM Actual Price of Cumulative Inventory CKML_PRICE_CUM CURR 11 2
STPRS Standard price STPRS CURR 11 2
LBKUM Total valuated stock CK_LBKUM QUAN 15 3
PB_QUANTITY Price Limiter Quantity CKML_PB_QUANTITY QUAN 15 3
QUANTITY_CUM Cumulative Inventory Quantity CKML_QUANTITY_CUM QUAN 15 3
SALK3 Value of total valuated stock CK_SALK3_1 CURR 15 2
RESCALE Price Differences Rescaled by the Cumulation ML_FLAG_RESCALE CHAR 1 0
X Yes
NULL No