1. Home
  2. Resources
  3. SAP Tables
  4. CKEK_ALV_TREE_LINE - Standard Rows in ALV Trees of Multilevel Unit Costing

SAP Table CKEK_ALV_TREE_LINE

Standard Rows in ALV Trees of Multilevel Unit Costing

CKEK_ALV_TREE_LINE (Standard Rows in ALV Trees of Multilevel Unit Costing) 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 CKEK_ALV_TREE_LINE to other SAP tables.

Source: CKEK_ALV_TREE_LINE (Standard Rows in ALV Trees of Multilevel Unit Costing)

CKEK_ALV_TREE_LINE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LEDNR Ledger for Controlling objects LEDNR CHAR 2 0
00 Standard ledger
BZOBJ Reference Object CK_OBJ CHAR 1 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
KALKA Costing Type CK_KALKA CHAR 2 0
KADKY Costing Date (Key) CK_KADKY DATS 8 0
TVERS Costing Version CK_TVERS NUMC 2 0
BWVAR Valuation Variant in Costing CK_BWVAR CHAR 3 0
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CK_KKZMA CHAR 1 0
X Yes
NULL No
POSNR Unit Costing Line Item Number CK_POSNR NUMC 5 0
STATP Item Status STATP_D CHAR 4 0
STRGP Item Control (for Internal Use) STRGP CHAR 4 0
TYPPS Item Category TYPPS CHAR 1 0
V Variable Item
S Total
B Base Planning Object
T Text Item
M Material
N Service
E Internal Activity
G Overhead
O Arithmetical Operation
Z Overhead Rate
K Cost Element
Y Customer-Specific Enhancement
F External Activity
P Process (Manual)
L Subcontracting
R Production Resources and Tools
X Process Costs ABC
I Delivery Costs
H Credit Line (Goods Receipt Simulation)
A Co-Product
J Costing Model
KSTAR Cost Element KSTAR CHAR 10 0
KSTAR_MANUAL Cost Element Has Been Manually Changed CK_COST_ELEMENT_MANUAL CHAR 1 0
X Cost Element Changed Manually
NULL Cost Element Not Changed Manually
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
ELEMT Cost Component Number of Main Cost Component Split CK_ELEMENTHS NUMC 3 0
ELEMTNS Cost Component Number of Auxiliary Cost Component Split CK_ELEMENTNS NUMC 3 0
FVFLG Fixed/Variable Indicator FVFLG CHAR 1 0
F
V
OPCOD Formula field for calculations at item level OPCOD CHAR 50 0
FRLNR Unit Costing Formula Number FORML_EK CHAR 3 0
BUKRS Company Code BUKRS CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
PSCHL Pricing Key PSCHL CHAR 18 0
KOKRS_HRK Origin Controlling Area Item KOKRS_HRK CHAR 4 0
EXTNR Base Planning Object (External Number) EXTNR CHAR 18 0
PRICE_MANUAL Price Entered Manually CK_PRICE_MANUAL CHAR 1 0
NULL Price Not Changed Manually
X Price Entered Manually
GPREIS Price in Controlling Area Currency CK_KPT CURR 15 2
FPREIS Fixed Price in Controlling Area Currency CK_KPF CURR 15 2
OPREIS Price in Object Currency CK_OPT CURR 15 2
OPREIFX Fixed Price in Object Currency CK_OPF CURR 15 2
TPREIS Price in Transaction Currency CK_TPT CURR 15 2
TPREIFX Fixed Price in Transaction Currency CK_TPF CURR 15 2
PEINH Price Unit of Prices in Controlling Area Currency CK_KPEINH DEC 5 0
PMEHT Price Quantity Unit PMEHT UNIT 3 0
WERTB Value in Controlling Area Currency CK_KWT CURR 15 2
WERTN Value in Controlling Area Currency CK_KWT CURR 15 2
WRTFX Fixed Value in Controlling Area Currency CK_KWF CURR 15 2
WRTFW_KPF Value in Object Currency CK_OWT CURR 15 2
WRTFW_KFX Fixed Value in Object Currency CK_OWF CURR 15 2
FWAER_KPF Object Currency CK_OWAER CUKY 5 0
WRTFW_POS Value in Transaction Currency CK_TWT CURR 15 2
WRTFW_PFX Fixed Value in Transaction Currency CK_TWF CURR 15 2
FWAER Transaction Currency CK_TWAER CUKY 5 0
MKURS Average rate MKURS NUMC 9 0
FWEHT Currency unit EINHT_CUR NUMC 4 0
MENGE Quantity MENGE_POS QUAN 15 3
MEEHT Base Unit of Measure MEINS UNIT 3 0
SUMM1 Quantities total for item category S SUMME_MNG QUAN 15 3
SUMM2 Capital Spending Total for Item Category S SUMME_INV CURR 15 2
SUMM3 Total of two or more items SUMME_POS CURR 15 2
DPREIS Average price for periods DPREIS CURR 15 2
PREIS1 Value of Delta Profit in CO Area Currency - Legal View PREIS1 CURR 15 2
PREIS2 Value of Delta Profit in Object Currency - Legal View PREIS2 CURR 15 2
PREIS3 Value of Delta Profit in CO Area Currency - Profit Ctr View PREIS3 CURR 15 2
PREIS4 Value of Delta Profit in Object Currency - Profit Ctr View PREIS4 CURR 15 2
PREIS5 Price Component 5 PREIS5 CURR 15 2
PFKT1 Price Component Factor PFKTX DEC 5 2
PFKT2 Price Component Factor PFKTX DEC 5 2
PFKT3 Price Component Factor PFKTX DEC 5 2
PFKT4 Price Component Factor PFKTX DEC 5 2
PFKT5 Price Component Factor PFKTX DEC 5 2
ZUABS Overhead as absolute figure DZUABS CURR 15 2
ZUFKT Overhead factor DZUFKT DEC 5 4
PSKNZ Lot-Size-Independent Indicator PSKNZ CHAR 1 0
SBDKZ Dependent requirements ind. for individual and coll. reqmts SBDKZ CHAR 1 0
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
VTKNZ Distribution Indicator VTKNZ CHAR 1 0
NULL no
X yes
LSTAR Activity Type LSTAR CHAR 6 0
ARBID Object ID OBJEKTID NUMC 8 0
KOSTL Cost Center KOSTL CHAR 10 0
INFNR Number of Purchasing Info Record INFNR CHAR 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
ESOKZ Purchasing info record category ESOKZ CHAR 1 0
0 Standard
2 Consignment
3 Subcontracting
P Pipeline
1 Chargeable
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
STEUS Control Key CK_STEUS CHAR 4 0
FXPRU Fixed-Price Co-Product CK_FIXPRKU CHAR 1 0
X Yes
NULL No
STPOS Equivalence Number with 4 Places CK_AEQUI4 DEC 4 0
AFAKT Costg.: Apportionment Factor for Itemiz. Line in Joint Prod. CK_SPLITFAC FLTP 16 16
BWTAR Valuation Type BWTAR_D CHAR 10 0
MKALK Mixed Costing Indicator CK_MKALK CHAR 1 0
X Yes
NULL No
BTYP Process Category CKML_BTYP CHAR 4 0
KALNR_BA Cost Estimate Number of Procurement Alternative CKKALNRBA NUMC 12 0
MISCH_VERH Mixing Ratio CK_CROSSR DEC 13 3
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ DEC 5 0
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN DEC 5 0
AUSMG Scrap Quantity CK_AUSMG QUAN 15 3
AUSMGKO Component Scrap Quantity CK_AUSMGKO QUAN 15 3
AUSPROZ Scrap Factor CK_SCRAP DEC 6 3
APLZL Continuous Counter for Differentiating Database Entries CK_COUNT NUMC 8 0
VORNR Operation/Activity Number VORNR CHAR 4 0
UVORN Suboperation UVORN CHAR 4 0
STEAS Target start date of the operation CK_STEAS DATS 8 0
POSNR_EXT Item Number for External Layout (Unit Costing) CK_POSEXT NUMC 5 0
POINTER1 Pointer n on Item Number CK_POS_POI NUMC 5 0
POINTER2 Pointer n on Item Number CK_POS_POI NUMC 5 0
POINTER3 Pointer n on Item Number CK_POS_POI NUMC 5 0
PATNR Partner number for costing NKPRTN NUMC 6 0
VERWS Reference of KALKTAB Items to a Context CK_VERWEIS CHAR 35 0
PRSKZ Price Indicator CK_PRSKZ CHAR 3 0
STRAT Valuation Strategy used for Costing Item CK_STRAT CHAR 1 0
X Yes
NULL No
SUBSTRAT Substrategy for Material Valuat. with Purchasing Info Record CK_SUBSTRAT CHAR 1 0
2 Effective Price from Quotation Without Fixed Costs
3 Net Quotation Price
4 Gross Quotation Price
5 Effective Price from Quotation
6 Effective Price from Purchase Order Without Fixed Costs
7 Net Purchase Order Price
8 Gross Purchase Order Price
9 Effective Price from Purchase Order
A Quotation Price via Condition Table
B Purchase Order Price via Condition Table
TKURS Exchange Rate for Item Foreign Currency TKURS DEC 9 5
SELKZ Indicator for Relevancy to Costing CK_SELKZ TCK08 CHAR 1 0
VRGGRP Transaction Group for Cost Element Itemization CK_VRGGRP CHAR 3 0
KKZMM Costs Were Entered Manually in an Additive Cost Estimate KKZMM CHAR 1 0
X Yes
NULL No
SSEDD Latest scheduled finish: Execution (date) SSEDD DATS 8 0
FEHLKZ Error Indicator CK_FEHLKZ CHAR 1 0
X Yes
NULL No
NO_CCSPLIT Do Not Determine Item Value via Cost Component Split CK_NO_CCSPLIT CHAR 1 0
X Yes
NULL No
SCHKZ Main Cost Component Split for KALKTAB Item Exists CK_SCHKZHS CHAR 1 0
X Yes
NULL No
SCHKZNS Auxiliary Cost Component Split for KALKTAB Item Exists CK_SCHKZNS CHAR 1 0
X Yes
NULL No
UFIELD_MODE Indicator to Override Transfer Control CK_UFIELD_MODE CHAR 1 0
NULL Transfer Fields: Which Cost Estimate Was Transferred
X Transfer Fields: Which Cost Estimate Should Be Transferred
UKALN Cost Estimate Number of Transferred Cost Estimate CK_UKALN NUMC 12 0
UKALKA Costing Type of Transferred Cost Estimate CK_UKALKA CHAR 2 0
UKADKY Date of Transferred Cost Estimate CK_UKADKY DATS 8 0
UTVERS Costing Version for Transfer CK_UTVERS NUMC 2 0
UBWVAR Valuation Variant of Transferred Cost Estimate CK_UBWVAR CHAR 3 0
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
SPOSN BOM Item Number SPOSN CHAR 4 0
USTRAT Transfer Strategy: Search Term 1 CK_UEBPER1 NUMC 1 0
0 No Transfer
1 Future Standard Cost Estimate
2 Current Standard Cost Estimate
3 Previous Standard Cost Estimate
4 Period-Based Transfer
5 Other Cost Estimates
PAROB Partner Object PAROB CHAR 22 0
BAUGR Item Is an Assembly CK_BAUGR CHAR 1 0
ASNUM Activity Number ASNUM ASMD CHAR 18 0
PEINH_2 Price Unit of Prices in Object Currency CK_OPEINH DEC 5 0
PEINH_3 Price Unit of Prices in Transaction Currency CK_TPEINH DEC 5 0
PRZNR Business Process CO_PRZNR CHAR 12 0
NLAG Non-Stock Material CK_NLAG CHAR 1 0
X Yes
NULL No
PRCTR Profit Center PRCTR CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
PSPNR Work Breakdown Structure Element (WBS element) WB_POSNR NUMC 8 0
KZANW 'X' = Do Not Calculate Overhead Costs CK_KZANW CHAR 1 0
1 Product Costing
2 Unit Costing
3 Production Order
KZLB 'X' = Header Material Is Subcontracted CK_KZLB CHAR 1 0
1 Product Costing
2 Unit Costing
3 Production Order
SUBKEY CO key subnumber CO_SUBKEY CHAR 14 0
KZWSO Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
DISST Low-Level Code DISST CHAR 3 0
CUOBJ Object Number for Conf. Objects CK_CUOBJ NUMC 18 0
GENTYP Generation Type of Item CK_GENTYP CHAR 1 0
T Item Generated Through Template
M Item Arose from the Costing Model
NULL Item Was Created Manually
COMPONENT_ID Unique Pointer to the Itemization Line (Persistent) CK_COMPONENT_ID NUMC 7 0
/CWM/XCWMAT Material Is Activated for Catch Weight /CWM/XCWMAT CHAR 1 0
X Yes
NULL No
/CWM/MENGE_BEW Input Quantity in Valuation Unit of Measure /CWM/CK_MENGE_BEW QUAN 15 3
/CWM/AUSMG_BEW Scrap Quantity in Valuation Unit of Measure /CWM/CK_AUSMG_BEW QUAN 15 3
/CWM/AUSMGKO_BEW Component Scrap Quantity in Valuation Unit of Measure /CWM/CK_AUSMGKO_BEW QUAN 15 3
CON_FIN_PR_LABEL Price Type CON_FIN_PRICE_LABEL CHAR 3 0
SPRAS Language Key SPRAS LANG 1 0
LTEXT Description KLTXT CHAR 40 0
EXTTX Name of Ad Hoc Cost Estimate for External Object CK_ADHOC_EXTTX CHAR 66 0
EGROUP1 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP2 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP3 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP4 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP5 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP6 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP7 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP8 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP9 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP10 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP11 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP12 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP13 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP14 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP15 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP16 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP17 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP18 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP19 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
EGROUP20 Total Value of Cost Estimate CK_WERTV8 CURR 15 2
VALUE_TOTAL Total value KKB_VALUE_TOTAL CURR 15 2
VALUE_FIX Fixed value KKB_VALUE_FIX CURR 15 2
VALUE_VARIABLE Variable value KKB_VALUE_VARIABLE CURR 15 2
WAERS Currency Key KKB_WAERS CUKY 5 0
PREIS Price KKB_PRICE CURR 15 2
PREISEINH Price unit KKB_PEINH DEC 5 0
PREISMEHT Price Quantity Unit PMEHT UNIT 3 0
MATNRTEXT Material Description (Short Text) MAKTX CHAR 40 0
WERKSTEXT Name NAME1 CHAR 30 0
ARBPLTEXT Short description CR_KTEXT CHAR 40 0
TYPPSTEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
HERKFTTEXT Name HRTXT CHAR 40 0
STRATTEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
LSTARTEXT General Name KTEXT CHAR 20 0
KSTARTTEXT Description KLTXT CHAR 40 0
KOSTLTEXT General Name KTEXT CHAR 20 0
EKORGTEXT Description of Purchasing Organization EKOTX CHAR 20 0
LIFNRTEXT Name 1 NAME1_GP CHAR 35 0
NO_ITEMIZATION Flag (X or Blank) AS4FLAG CHAR 1 0
NULL Do not set flag
X Set flag
NO_AUTHORITY Flag (X or Blank) AS4FLAG CHAR 1 0
NULL Do not set flag
X Set flag
NO_CUMULATION Flag (X or Blank) AS4FLAG CHAR 1 0
NULL Do not set flag
X Set flag
RECOSTED Recosted KKB_RECOSTED CHAR 1 0
NULL Do not set flag
X Set flag
LOSGR Lot Size for Product Costing CK_LOSGR QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
KURST Exchange Rate Type KURST CHAR 4 0
ASL Cost Estimate of an Order BOM CK_ASL CHAR 1 0
X Yes
NULL No
KLVAR Costing Variant CK_KLVAR CHAR 4 0
RESSOURCE Origin1, origin2 and origin3 KKEK_RESS CHAR 30 0
ARBPL Work center ARBPL CHAR 8 0
LEVEL Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 0
FEHLER_STATUS Character Field Length 1 CHAR01 CHAR 1 0
MAXMSG Message Type SYMSGTY CHAR 1 0
PLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
PLMNG Production Plan Quantity Transferred to the Cost Estimate CKI_PLMNG QUAN 15 3
SCRAP Scrap KKB_SCRAP CURR 15 2
SCRAK Component Scrap KKB_SCRAK CURR 15 2
HWGES_OLD Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
FWGES_OLD Total Value for Cost Estimate in Foreign Currency FWGES CURR 15 2
HWGES_DIFF Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
FLG_CHANGED Cost Estimate Was Changed CKEK_COSTING_CHANGED CHAR 1 0
FLG_STATUS_DISP Single-Character Indicator CHAR1 CHAR 1 0
FLG_HIERARCHY1 Single-Character Indicator CHAR1 CHAR 1 0
HWGES_TARG Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HWGES_TARGDI Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
FLG_X1 Do Not Revaluate Cost Estimate CKEK_STOP_REVALUATION_FLAG CHAR 1 0
FLG_X2 Transfer Cost Estimate as Original CKEK_REFERENCE_CALCULATION CHAR 1 0
HW_VALUE1 Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HW_VALUE2 Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HW_VALUE3 Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HW_VALUE4 Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HW_VALUE5 Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HWGES Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HWGFX Fixed Portion of Costing Value in Local Currency HWFIX CURR 15 2
HWAER Local Currency HWAER CUKY 5 0
PSDAT Pricing Date PSDAT DATS 8 0

CKEK_ALV_TREE_LINE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKEK_ALV_TREE_LINE ASNUM SYST MANDT ASMD Service Master: Basic Data MANDT
CKEK_ALV_TREE_LINE ASNUM CKEK_ALV_TREE_LINE ASNUM ASMD Service Master: Basic Data ASNUM
CKEK_ALV_TREE_LINE SELKZ SYST MANDT TCK08 Indicator for Relevancy to Costing MANDT
CKEK_ALV_TREE_LINE SELKZ CKEK_ALV_TREE_LINE SELKZ TCK08 Indicator for Relevancy to Costing SELKZ