SAP Table CKKALKTAB

Costing Itemization/Parallel to CKIS

CKKALKTAB (Costing Itemization/Parallel to CKIS) 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 CKKALKTAB to other SAP tables.

CKKALKTAB 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
PATNR Partner number for costing NKPRTN NUMC 6 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
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
PSKNZ Fixed/Variable Indicator FVFLG CHAR 1 0
F
V
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
BWTAR Valuation Type BWTAR_D CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 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
KOKRS_HRK Origin Controlling Area Item KOKRS_HRK CHAR 4 0
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
WERTN Value in Controlling Area Currency CK_KWT CURR 15 2
WRTFX Fixed Value in Controlling Area Currency CK_KWF CURR 15 2
HWAER Controlling Area Currency CK_KWAER CUKY 5 0
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
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
MENGE Quantity MENGE_POS QUAN 15 3
MEEHT Base Unit of Measure MEINS UNIT 3 0
ARBID Object ID of the resource CR_OBJID NUMC 8 0
KOSTL Cost Center KOSTL CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 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 STEUS CHAR 4 0
ASNUM Activity Number ASNUM CHAR 18 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
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
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
SPRAS Language Key SPRAS LANG 1 0
LTEXT Description KLTXT CHAR 40 0
FEHLKZ Error Indicator CK_FEHLKZ CHAR 1 0
X Yes
NULL No
KOAKZ Cost Element Checked CK_KOAKZ CHAR 1 0
X Yes
NULL No
KZANW 'X' = Do Not Calculate Overhead Costs CK_KZANW CHAR 1 0
1 Product Costing
2 Unit Costing
3 Production Order
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
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
PRICE_MANUAL Price Entered Manually CK_PRICE_MANUAL CHAR 1 0
NULL Price Not Changed Manually
X Price Entered Manually
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
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
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
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
PAROB Partner Object PAROB CHAR 22 0
BAUGR Material Is an Assembly ASSEMBLY CHAR 1 0
X Yes
NULL No
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
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
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
OPCOD Formula field for calculations at item level OPCOD CHAR 50 0
EXTNR Base Planning Object (External Number) EXTNR CHAR 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
VALUATION Valuation View VALUTYP NUMC 1 0
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
5 Parallel Cost of Goods Manufactured 1
6 Parallel Cost of Goods Manufactured 2
7 Parallel Cost of Goods Manufactured 3
ZAEHLER Number of Cost Collectors in Internal Table CK_ZAEHLER INT4 10 0
SELKZ Indicator for Relevancy to Costing CK_SELKZ CHAR 1 0
STZHL Counter for Reversed Confirmation Record CK_STZHL NUMC 8 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Confirmation counter CO_RMZHL NUMC 8 0
PERNR Personnel Number PERNR_D NUMC 8 0
STLKN BOM item node number STLKN NUMC 8 0
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
KZDFM Direct Production Material -> Cost Rollup KZDFM CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 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
KURFP Exchange rate for date in billing plan KURFP DEC 9 5
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
CATSPRICE Price in Transaction Currency CATSPRICE CURR 11 2
CATSTCURR Transaction Currency TWAER CUKY 5 0
NNEU Do Not Revaluate Item CK_NNEU CHAR 1 0
X Yes
NULL No
CHARG Batch Number CHARG_D CHAR 10 0
KZ_MATVORPL Indicator: Material planning active KZ_MATVORPL CHAR 1 0
X Yes
NULL No
PCMP_COUNTER Internal counter CIM_COUNT NUMC 8 0
PROZMV Percentage Share of a Procurement Altern. in Mixed Costing CK_PROZMV DEC 6 3
RATE_OW Exchange Rate CKRATE DEC 16 8
RATE_HW Exchange Rate CKRATE DEC 16 8
KOMOK Account Modification KOMOK CHAR 3 0
SHKZ Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BWART Movement Type (Inventory Management) BWART CHAR 3 0
AFPOS Order Item Number CO_POSNR NUMC 4 0
CATSPEINH Price Unit PEINH DEC 5 0
BEMOT Accounting Indicator BEMOT CHAR 2 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
POINTER_KIS1 Unique Pointer to Itemization Line (Transient) CK_KIS1_POINTER NUMC 8 0
RECEIVING_BUKRS Company Code BUKRS CHAR 4 0
RECEIVING_PRCTR Profit Center PRCTR CHAR 10 0
RECEIVING_WERKS Plant WERKS_D CHAR 4 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