SAP table CKIS (Items Unit Costing/Itemization Product Costing)

SAP table CKIS has 10 primary key fields being MANDT,LEDNR,BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR,KKZMA,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
BZOBJ Reference Object CHAR 1 0 CK_OBJ
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CKHS CK_KALNR
KALKA Costing Type CHAR 2 0 CK_KALKA
KADKY Costing Date (Key) DATS 8 0 CK_KADKY
TVERS Costing Version NUMC 2 0 CK_TVERS
BWVAR Valuation Variant in Costing CHAR 3 0 CK_BWVAR
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CHAR 1 0 CK_KKZMA
POSNR Unit Costing Line Item Number NUMC 5 0 CK_POSNR
STATP Item Status CHAR 4 0 STATP_D
STRGP Item Control (for Internal Use) CHAR 4 0 STRGP
TYPPS Item Category CHAR 1 0 TYPPS
1 Costing Master Data (Concurrent Costing)
A Co-Product
B Base Planning Object
E Internal Activity
F External Activity
G Overhead
H Credit Line (Goods Receipt Simulation)
I Delivery Costs
J Costing Model
K Cost Element
L Subcontracting
M Material
N Service
O Arithmetical Operation
P Process (Manual)
R Production Resources and Tools
S Total
T Text Item
V Variable Item
X Process Costs ABC
Y Customer-Specific Enhancement
Z Overhead Rate
KSTAR Cost Element CHAR 10 0 KSTAR
KSTAR_MANUAL Cost Element Has Been Manually Changed CHAR 1 0 CK_COST_ELEMENT_MANUAL
Cost Element Not Changed Manually
X Cost Element Changed Manually
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 HRKFT
ELEMT Cost Component Number of Main Cost Component Split NUMC 3 0 CK_ELEMENTHS
ELEMTNS Cost Component Number of Auxiliary Cost Component Split NUMC 3 0 CK_ELEMENTNS
FVFLG Fixed/Variable Indicator CHAR 1 0 FVFLG
F
V
OPCOD Formula field for calculations at item level CHAR 50 0 OPCOD
FRLNR Unit Costing Formula Number CHAR 3 0 FORML_EK
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
PSCHL Pricing Key CHAR 18 0 PSCHL
KOKRS_HRK Origin Controlling Area Item CHAR 4 0 TKA01 KOKRS_HRK
EXTNR Base Planning Object (External Number) CHAR 18 0 CKBS EXTNR
GPREIS Price in Controlling Area Currency CURR 15 2 CK_KPT
FPREIS Fixed Price in Controlling Area Currency CURR 15 2 CK_KPF
PEINH Price Unit of Prices in Controlling Area Currency DEC 5 0 CK_KPEINH
PMEHT Price Quantity Unit UNIT 3 0 T006 PMEHT
PRICE_MANUAL Price Entered Manually CHAR 1 0 CK_PRICE_MANUAL
Price Not Changed Manually
X Price Entered Manually
WERTB Value in Controlling Area Currency CURR 15 2 CK_KWT
WERTN Value in Controlling Area Currency CURR 15 2 CK_KWT
WRTFX Fixed Value in Controlling Area Currency CURR 15 2 CK_KWF
WRTFW_KPF Value in Object Currency CURR 15 2 CK_OWT
WRTFW_KFX Fixed Value in Object Currency CURR 15 2 CK_OWF
FWAER_KPF Object Currency CUKY 5 0 CK_OWAER
WRTFW_POS Value in Transaction Currency CURR 15 2 CK_TWT
WRTFW_PFX Fixed Value in Transaction Currency CURR 15 2 CK_TWF
FWAER Transaction Currency CUKY 5 0 TCURC CK_TWAER
MKURS Average rate NUMC 9 0 MKURS
FWEHT Currency unit NUMC 4 0 EINHT_CUR
MENGE Quantity QUAN 15 3 MENGE_POS
MEEHT Base Unit of Measure UNIT 3 0 T006 MEINS
SUMM1 Quantities total for item category S QUAN 15 3 SUMME_MNG
SUMM2 Capital Spending Total for Item Category S CURR 15 2 SUMME_INV
SUMM3 Total of two or more items CURR 15 2 SUMME_POS
DPREIS Average price for periods CURR 15 2 DPREIS
PREIS1 Value of Delta Profit in CO Area Currency - Legal View CURR 15 2 PREIS1
PREIS2 Value of Delta Profit in Object Currency - Legal View CURR 15 2 PREIS2
PREIS3 Value of Delta Profit in CO Area Currency - Profit Ctr View CURR 15 2 PREIS3
PREIS4 Value of Delta Profit in Object Currency - Profit Ctr View CURR 15 2 PREIS4
PREIS5 Price Component 5 CURR 15 2 PREIS5
PFKT1 Price Component Factor DEC 5 2 PFKTX
PFKT2 Price Component Factor DEC 5 2 PFKTX
PFKT3 Price Component Factor DEC 5 2 PFKTX
PFKT4 Price Component Factor DEC 5 2 PFKTX
PFKT5 Price Component Factor DEC 5 2 PFKTX
ZUABS Overhead as absolute figure CURR 15 2 DZUABS
ZUFKT Overhead Factor DEC 5 4 DZUFKT
PSKNZ Lot-Size-Independent Indicator CHAR 1 0 PSKNZ
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
VTKNZ Distribution Indicator CHAR 1 0 VTKNZ
LSTAR Activity Type CHAR 6 0 LSTAR
ARBID Object ID NUMC 8 0 OBJEKTID
KOSTL Cost Center CHAR 10 0 KOSTL
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
EKORG Purchasing organization CHAR 4 0 EKORG
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
STEUS Control Key CHAR 4 0 CK_STEUS
FXPRU Fixed-Price Co-Product CHAR 1 0 CK_FIXPRKU
STPOS Equivalence Number with 4 Places DEC 4 0 CK_AEQUI4
AFAKT Costg.: Apportionment Factor for Itemiz. Line in Joint Prod. FLTP 16 16 CK_SPLITFAC
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
MKALK Mixed Costing Indicator CHAR 1 0 CK_MKALK
BTYP Process Category CHAR 4 0 CKML_BTYP
KALNR_BA Cost Estimate Number of Procurement Alternative NUMC 12 0 CKKALNRBA
MISCH_VERH Mixing Ratio DEC 13 3 CK_CROSSR
UMREZ Numerator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSZ
UMREN Denominator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSN
AUSMG Scrap Quantity QUAN 15 3 CK_AUSMG
AUSMGKO Component Scrap Quantity QUAN 15 3 CK_AUSMGKO
AUSPROZ Scrap Factor DEC 6 3 CK_SCRAP
APLZL Continuous Counter for Differentiating Database Entries NUMC 8 0 CK_COUNT
VORNR Operation/Activity Number CHAR 4 0 VORNR
UVORN Suboperation CHAR 4 0 UVORN
STEAS Target start date of the operation DATS 8 0 CK_STEAS
POSNR_EXT Item Number for External Layout (Unit Costing) NUMC 5 0 CK_POSEXT
POINTER1 Pointer n on Item Number NUMC 5 0 CK_POS_POI
POINTER2 Pointer n on Item Number NUMC 5 0 CK_POS_POI
POINTER3 Pointer n on Item Number NUMC 5 0 CK_POS_POI
OPREIS Price in Object Currency CURR 15 2 CK_OPT
OPREIFX Fixed Price in Object Currency CURR 15 2 CK_OPF
TPREIS Price in Transaction Currency CURR 15 2 CK_TPT
TPREIFX Fixed Price in Transaction Currency CURR 15 2 CK_TPF
PATNR Partner number for costing NUMC 6 0 NKPRTN
VERWS Reference of KALKTAB Items to a Context CHAR 35 0 CK_VERWEIS
PRSKZ Price Indicator CHAR 3 0 CK_PRSKZ
RLDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
STRAT Valuation Strategy used for Costing Item CHAR 1 0 CK_STRAT
SUBSTRAT Substrategy for Material Valuat. with Purchasing Info Record CHAR 1 0 CK_SUBSTRAT
CATERGORY Plan Category CHAR 10 0 FCOM_CATEGORY
TKURS Exchange Rate for Item Foreign Currency DEC 9 5 TKURS
SELKZ Indicator for Relevancy to Costing CHAR 1 0 TCK08 CK_SELKZ
VRGGRP Transaction Group for Cost Element Itemization CHAR 3 0 CK_VRGGRP
KKZMM Costs Were Entered Manually in an Additive Cost Estimate CHAR 1 0 KKZMM
SSEDD Latest scheduled finish: Execution (date) DATS 8 0 SSEDD
FEHLKZ Error Indicator CHAR 1 0 CK_FEHLKZ
NO_CCSPLIT Do Not Determine Item Value via Cost Component Split CHAR 1 0 CK_NO_CCSPLIT
SCHKZ Main Cost Component Split for KALKTAB Item Exists CHAR 1 0 CK_SCHKZHS
SCHKZNS Auxiliary Cost Component Split for KALKTAB Item Exists CHAR 1 0 CK_SCHKZNS
UFIELD_MODE Indicator to Override Transfer Control CHAR 1 0 CK_UFIELD_MODE
Transfer Fields: Which Cost Estimate Was Transferred
X Transfer Fields: Which Cost Estimate Should Be Transferred
UKALN Cost Estimate Number of Transferred Cost Estimate NUMC 12 0 CK_UKALN
UKALKA Costing Type of Transferred Cost Estimate CHAR 2 0 CK_UKALKA
UKADKY Date of Transferred Cost Estimate DATS 8 0 CK_UKADKY
UTVERS Costing Version for Transfer NUMC 2 0 CK_UTVERS
UBWVAR Valuation Variant of Transferred Cost Estimate CHAR 3 0 CK_UBWVAR
HKMAT Material-related origin CHAR 1 0 HKMAT
No material-related origin
X Keep costs/quantities under material number
SPOSN BOM Item Number CHAR 4 0 SPOSN
USTRAT Transfer Strategy: Search Term 1 NUMC 1 0 CK_UEBPER1
BAUGR Item Is an Assembly CHAR 1 0 CK_BAUGR
ASNUM Activity Number CHAR 18 0 ASMD ASNUM
PEINH_2 Price unit DEC 5 0 PEINH
PEINH_3 Price unit DEC 5 0 PEINH
PRZNR Business Process CHAR 12 0 CO_PRZNR
NLAG Non-Stock Material CHAR 1 0 CK_NLAG
PRCTR Profit Center CHAR 10 0 PRCTR
TPTYP Transfer Price Type CHAR 1 0 FVC_TPTYP
1 Inter-Company Transfer Price
2 At Cost
3 Profit Center Transfer Price
SEGUNIT Valuation Segmentation Unit CHAR 30 0 FINS_SEGMENTATION_UNIT
GSBER Business Area CHAR 4 0 GSBER
PSPNR Work Breakdown Structure Element (WBS element) NUMC 8 0 WB_POSNR
PAROB Partner Object CHAR 22 0 PAROB
KZANW 'X' = Do Not Calculate Overhead Costs CHAR 1 0 CK_KZANW
1 Product Costing
2 Unit Costing
3 Production Order
KZLB 'X' = Header Material Is Subcontracted CHAR 1 0 CK_KZLB
SUBKEY CO key subnumber CHAR 14 0 CO_SUBKEY
KZWSO Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
DISST Low-Level Code CHAR 3 0 DISST
CUOBJ Object Number for Conf. Objects NUMC 18 0 CK_CUOBJ
GENTYP Generation Type of Item CHAR 1 0 CK_GENTYP
Item Was Created Manually
M Item Arose from the Costing Model
T Item Generated Through Template
COMPONENT_ID Unique Pointer to the Itemization Line (Persistent) NUMC 7 0 CK_COMPONENT_ID
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/MENGE_BEW Input Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_MENGE_BEW
/CWM/AUSMG_BEW Scrap Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_AUSMG_BEW
/CWM/AUSMGKO_BEW Component Scrap Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_AUSMGKO_BEW
RELATIONSHIP_IND PCP: Flag - Object Relationships Exist CHAR 1 0 CK_RELATION_IND
MATKL Material Group CHAR 9 0 MATKL
PPEGUID Internal Identification for PVS Objects RAW 16 0 PVS_GUID
MODEGUID Internal Identification for PVS Objects RAW 16 0 PVS_GUID

CKIS foreign key relationships

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