1. Home
  2. Resources
  3. SAP Tables
  4. CKIS - Items Unit Costing/Itemization Product Costing

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
MANDT Client MANDT T000 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 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
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 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
NULL Price Not Changed Manually
X Price Entered Manually
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
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 EINA 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 T149D 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
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
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
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
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
PAROB Partner Object PAROB CHAR 22 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

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