CKML_VFM_TREE SAP (Display Structure for Value Flow Monitor (ALV_Tree)) Structure details

Dictionary Type: Structure
Description: Display Structure for Value Flow Monitor (ALV_Tree)




ABAP Code to SELECT data from CKML_VFM_TREE
Related tables to CKML_VFM_TREE
Access table CKML_VFM_TREE




Structure field list including key, data, relationships and ABAP select examples

CKML_VFM_TREE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Display Structure for Value Flow Monitor (ALV_Tree)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CKML_VFM_TREE TYPE CKML_VFM_TREE.

The CKML_VFM_TREE table consists of various fields, each holding specific information or linking keys about Display Structure for Value Flow Monitor (ALV_Tree) data available in SAP. These include BUKRS (Company Code), BKLAS (Valuation Class), WERKS (Plant), KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CKML_VFM_TREE structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LEVELDummy for B20 int1 (Local Everywhere) INT1INT13INT1
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BKLASValuation Class BKLASCHAR4Assigned to domainBKLAS
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
NODE_KEYALV Tree Control: Node Key LVC_NKEYCHAR12
HTEXTALV Control: Cell Content LVC_VALUECHAR128TEXT128
ICONAllocatable differences when price limiter quantity is 0 CKML_VFM_ICONCHAR4CKML_ICON4
ICON_ESTSingle-Level Price Determination CKML_ICON_ESTCHAR4CKML_ICON4
ICON_MSTMultilevel Price Determination CKML_ICON_MSTCHAR4CKML_ICON4
ICON_CLOClosing Entry ML_ICON_CLOCHAR4CKML_ICON4
ICON_FIABalance Between Price Difference Accounts and ML ML_ICON_FIACHAR4CKML_ICON4
STATUSMaterial ledger period status CK_MLSTATNUMC2CK_MLSTAT
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MEINSUnit of Measure for Material Valuation CKML_MEINSUNIT3Assigned to domainCUNITMEINS
DIFF_NDIDifferences: Not distributed CKML_DIFF_NDICURR15(2) WERTV8
DIFF_NINDifferences: Not included CKML_DIFF_NINCURR15(2) WERTV8
DIFF_CUMCumulative Differences CKML_DIFF_CUMCURR15(2) WERTV8
DIFF_RSCConsumption Revaluation: Differences CKML_DIFF_RSCCURR15(2) WERTV8
DIFF_EIVDifferences distributed to ending inventory CKML_DIFF_EIVCURR15(2) WERTV8
DIFF_NLEAllocated multilevel differences CKML_DIFF_NLECURR15(2) WERTV8
DIFF_WIPWIP Revaluation Differences CKML_DIFF_WIPCURR15(2) WERTV8
DIFF_VNODifferences From Retirements That Do Not Affect The Price CKML_DIFF_VNOCURR15(2) WERTV8
DIFF_FIABalance of Price Difference Accounts ML_DIFF_FIACURR15(2) WERTV8
DIFF_FISBalance between Price Difference Account and Material Ledger ML_DIFF_FISCURR15(2) WERTV8
DIFF_UMBRevaluation Amount of the AVR Start Period ML_DIFF_UMBCURR15(2) WERTV8
DIFF_ABCManual Correction of Beginning Inventory Price Differences ML_DIFF_ABCCURR15(2) WERTV8
VALUE_CUMCumulative Inventory Value CKML_VALUE_CUMCURR15(2) WERTV8
PB_PRICEPrice after setting the price limiter quantity to zero CKML_PB_PRICECURR11(2) WERT11
PRICE_CUMActual Price of Cumulative Inventory CKML_PRICE_CUMCURR11(2) WERT11
STPRSStandard price STPRSCURR11(2) WERT11V
LBKUMTotal valuated stock CK_LBKUMQUAN15(3) MENGV8
PB_QUANTITYPrice Limiter Quantity CKML_PB_QUANTITYQUAN15(3) MENGV8
QUANTITY_CUMCumulative Inventory Quantity CKML_QUANTITY_CUMQUAN15(3) MENGV8
SALK3Value of total valuated stock CK_SALK3_1CURR15(2) WERTV8
RESCALEPrice Differences Rescaled by the Cumulation ML_FLAG_RESCALECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure CKML_VFM_TREE using ABAP code?

As CKML_VFM_TREE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CKML_VFM_TREE as there is no data to select.

How to access SAP table CKML_VFM_TREE

Within an ECC or HANA version of SAP you can also view further information about CKML_VFM_TREE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!