SAP table CKIT (Texts for CKIS)
SAP table CKIT has 11 primary key fields being MANDT,LEDNR,BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR,KKZMA,POSNR,SPRAS.
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
Possible values
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
CKIS
CK_POSNR
SPRAS
Language Key
LANG
1
0
T002
SPRAS
LTEXT
Description
CHAR
40
0
KLTXT
CKIT foreign key relationships
Table
Field
Check Table
Check Field
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
MANDT
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
LEDNR
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
KALNR
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
KALKA
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
KADKY
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
TVERS
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
BWVAR
0 CKIT
KALNR
CKHS
Header: Unit Costing (Control + Totals)
KKZMA
1 CKIT
MANDT
T000
Clients
MANDT
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
LEDNR
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
KALKA
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
KADKY
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
TVERS
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
KKZMA
0 CKIT
POSNR
CKIS
Items Unit Costing/Itemization Product Costing
POSNR
1 CKIT
SPRAS
T002
Language Keys (Component BC-I18)
SPRAS