Follow us on LinkedIn for your next SAP project

SAP Table CKIS

Items Unit Costing/Itemization Product Costing

CKIS (Items Unit Costing/Itemization Product 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 CKIS to other SAP tables.

CKIS table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
LEDNR
Ledger for Controlling objects
LEDNR
CHAR
2 0
BZOBJ
Reference Object
CK_OBJ
CHAR
1 0
KALNR
Cost Estimate Number for Cost Est. w/o Qty Structure
CK_KALNR CKHS
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
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
KSTAR
Cost Element
KSTAR
CHAR
10 0
KSTAR_MANUAL
Cost Element Has Been Manually Changed
CK_COST_ELEMENT_MANUAL
CHAR
1 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
FVFLG
Fixed/Variable Indicator
FVFLG
CHAR
1 0
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 T001
CHAR
4 0
WERKS
Plant
WERKS_D T001W
CHAR
4 0
MATNR
Material Number
MATNR MARA
CHAR
18 0
PSCHL
Pricing Key
PSCHL
CHAR
18 0
KOKRS_HRK
Origin Controlling Area Item
KOKRS_HRK TKA01
CHAR
4 0
EXTNR
Base Planning Object (External Number)
EXTNR CKBS
CHAR
18 0
GPREIS
Price in Controlling Area Currency
CK_KPT
CURR
15 2
FPREIS
Fixed Price in Controlling Area Currency
CK_KPF
CURR
15 2
PEINH
Price Unit of Prices in Controlling Area Currency
CK_KPEINH
DEC
5 0
PMEHT
Price Quantity Unit
PMEHT T006
UNIT
3 0
PRICE_MANUAL
Price Entered Manually
CK_PRICE_MANUAL
CHAR
1 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 TCURC
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 T006
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
VTKNZ
Distribution Indicator
VTKNZ
CHAR
1 0
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 EINA
CHAR
10 0
EKORG
Purchasing Organization
EKORG
CHAR
4 0
ESOKZ
Purchasing info record category
ESOKZ
CHAR
1 0
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
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 T149D
CHAR
10 0
MKALK
Mixed Costing Indicator
CK_MKALK
CHAR
1 0
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
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
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
SUBSTRAT
Substrategy for Material Valuat. with Purchasing Info Record
CK_SUBSTRAT
CHAR
1 0
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
SSEDD
Latest scheduled finish: Execution (date)
SSEDD
DATS
8 0
FEHLKZ
Error Indicator
CK_FEHLKZ
CHAR
1 0
NO_CCSPLIT
Do Not Determine Item Value via Cost Component Split
CK_NO_CCSPLIT
CHAR
1 0
SCHKZ
Main Cost Component Split for KALKTAB Item Exists
CK_SCHKZHS
CHAR
1 0
SCHKZNS
Auxiliary Cost Component Split for KALKTAB Item Exists
CK_SCHKZNS
CHAR
1 0
UFIELD_MODE
Indicator to Override Transfer Control
CK_UFIELD_MODE
CHAR
1 0
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
SPOSN
BOM Item Number
SPOSN
CHAR
4 0
USTRAT
Transfer Strategy: Search Term 1
CK_UEBPER1
NUMC
1 0
BAUGR
Item Is an Assembly
CK_BAUGR
CHAR
1 0
ASNUM
Activity Number
ASNUM ASMD
CHAR
18 0
PEINH_2
Price Unit
PEINH
DEC
5 0
PEINH_3
Price Unit
PEINH
DEC
5 0
PRZNR
Business Process
CO_PRZNR
CHAR
12 0
NLAG
Non-Stock Material
CK_NLAG
CHAR
1 0
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
PAROB
Partner Object
PAROB
CHAR
22 0
KZANW
'X' = Do Not Calculate Overhead Costs
CK_KZANW
CHAR
1 0
KZLB
'X' = Header Material Is Subcontracted
CK_KZLB
CHAR
1 0
SUBKEY
CO key subnumber
CO_SUBKEY
CHAR
14 0
KZWSO
Units of measure usage
KZWSO
CHAR
1 0
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
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
/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

CKIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKIS ASNUM CKIS MANDT ASMD
Service Master: Basic Data
MANDT
CKIS ASNUM CKIS ASNUM ASMD
Service Master: Basic Data
ASNUM
CKIS BUKRS CKIS MANDT T001
Company Codes
MANDT
CKIS BUKRS CKIS BUKRS T001
Company Codes
BUKRS
CKIS BWTAR CKIS MANDT T149D
Global Valuation Types
MANDT
CKIS BWTAR CKIS BWTAR T149D
Global Valuation Types
BWTAR
CKIS EXTNR CKIS MANDT CKBS
Base Planning Object - Unit Costing
MANDT
CKIS EXTNR CKIS KOKRS_HRK CKBS
Base Planning Object - Unit Costing
KOKRS
CKIS EXTNR CKIS EXTNR CKBS
Base Planning Object - Unit Costing
EXTNR
CKIS FWAER CKIS FWAER TCURC
Currency Codes
WAERS
CKIS FWAER CKIS MANDT TCURC
Currency Codes
MANDT
CKIS INFNR CKIS MANDT EINA
Purchasing Info Record: General Data
MANDT
CKIS INFNR CKIS INFNR EINA
Purchasing Info Record: General Data
INFNR
CKIS KALNR CKIS TVERS CKHS
Header: Unit Costing (Control + Totals)
TVERS
CKIS KALNR CKIS LEDNR CKHS
Header: Unit Costing (Control + Totals)
LEDNR
CKIS KALNR CKIS BWVAR CKHS
Header: Unit Costing (Control + Totals)
BWVAR
CKIS KALNR CKIS BZOBJ CKHS
Header: Unit Costing (Control + Totals)
BZOBJ
CKIS KALNR CKIS KKZMA CKHS
Header: Unit Costing (Control + Totals)
KKZMA
CKIS KALNR CKIS KALNR CKHS
Header: Unit Costing (Control + Totals)
KALNR
CKIS KALNR CKIS KALKA CKHS
Header: Unit Costing (Control + Totals)
KALKA
CKIS KALNR CKIS KADKY CKHS
Header: Unit Costing (Control + Totals)
KADKY
CKIS KALNR CKIS MANDT CKHS
Header: Unit Costing (Control + Totals)
MANDT
CKIS KOKRS_HRK CKIS MANDT TKA01
Controlling Areas
MANDT
CKIS KOKRS_HRK CKIS KOKRS_HRK TKA01
Controlling Areas
KOKRS
CKIS MANDT CKIS MANDT T000
Clients
MANDT
CKIS MATNR CKIS MANDT MARA
General Material Data
MANDT
CKIS MATNR CKIS MATNR MARA
General Material Data
MATNR
CKIS MEEHT CKIS MANDT T006
Units of Measurement
MANDT
CKIS MEEHT CKIS MEEHT T006
Units of Measurement
MSEHI
CKIS PMEHT CKIS MANDT T006
Units of Measurement
MANDT
CKIS PMEHT CKIS PMEHT T006
Units of Measurement
MSEHI
CKIS SELKZ CKIS MANDT TCK08
Indicator for Relevancy to Costing
MANDT
CKIS SELKZ CKIS SELKZ TCK08
Indicator for Relevancy to Costing
SELKZ
CKIS WERKS CKIS WERKS T001W
Plants/Branches
WERKS
CKIS WERKS CKIS MANDT T001W
Plants/Branches
MANDT