SAP table CKHS (Header: Unit Costing (Control + Totals))

SAP table CKHS has 9 primary key fields being MANDT,LEDNR,BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR,KKZMA.

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 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
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
FCPMG Distribution Key CHAR 4 0 T821S SPRED
FROPER First Valid Period (from Period) NUMC 3 0 CK_FROPER
DIPER Interval Between Planned Periods NUMC 3 0 CK_DIPER
TOPER Last Posting Period Allowed NUMC 3 0 CK_TOPER
KKART Costing Variant (Corresponds to KLVAR) CHAR 4 0 TKKEA KKART
GJAHR Fiscal Year NUMC 4 0 GJAHR
ERFDT Entered On DATS 8 0 ERFDT
ERFNM Entered By CHAR 12 0 ERFNM
AENDT Date of last change DATS 8 0 AENDT
AENNM Last Changed By CHAR 12 0 AENNM
ABSDT Close date DATS 8 0 ABSDT
ABSNM User ID of the person who closed the cost estimate CHAR 12 0 ABSNM
KRSDT Exchange Rate Date DATS 8 0 KRSDT
STATK Header Status CHAR 4 0 STATK
STRNG Internal header control CHAR 4 0 STRNG
PSDAT Pricing Date DATS 8 0 PSDAT
MENGE Lot Size QUAN 15 3 MENGE_KPF
MEEHT Valuation Unit of Measure UNIT 3 0 T006 CK_MEINH_BEW
HWGES Total Value of Cost Estimate in Local Currency CURR 15 2 HWGES
HWGFX Fixed Portion of Costing Value in Local Currency CURR 15 2 HWFIX
FWGES Total Value for Cost Estimate in Foreign Currency CURR 15 2 FWGES
HWAER Local Currency CUKY 5 0 TCURC HWAER
FWAER Foreign Currency in Header CUKY 5 0 TCURC FWAER
UKURS Exchange Rate DEC 9 5 UKURS_D
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
FFACT Factor for the "From" Currency Units DEC 9 0 FFACT
TFACT Factor for the "To" Currency Units DEC 9 0 TFACT_D
GWRT1 Total Value of Price Component 1 CURR 15 2 GWRT1
GWRT2 Total Value of Price Component 1 CURR 15 2 GWRT1
GWRT3 Total Value of Price Component 1 CURR 15 2 GWRT1
GWRT4 Total Value of Price Component 1 CURR 15 2 GWRT1
GWRT5 Total Value of Price Component 1 CURR 15 2 GWRT1
STFLG Sales Order Cost Estimate Is Marked CHAR 1 0 STFLG
ZTFLG Flag for time-based unit costing CHAR 1 0 DZTFLG
FVFLG Fixed/Variable Indicator CHAR 1 0 FVFLG
F
V
DLFLG Deletion Flag for Unit Costing CHAR 1 0 DLFLG
FRFLG Release Flag CHAR 1 0 FRFLG
PRVFN Pricing Procedure CHAR 1 0 PRVFN
1 Total price
2 Fixed/variable
3 Price components
4 Price components and factors
PKANZ Number of Price Components NUMC 1 0 PKANZ
PSANZ Number of Costing Items NUMC 5 0 * CK_PSANZ
KNNZ1 Cost Estimate Created with Excel CHAR 1 0 KK_KZEXL
KNNZ2 Indicator - Postprocessing of product cost estimate CHAR 1 0 KK_KZEZN
KNNZ3 Unit Costing Indicator CHAR 1 0 KZCHN
KNNZ4 Unit Costing Indicator CHAR 1 0 KZCHN
KNNZ5 Unit Costing Indicator CHAR 1 0 KZCHN
ME_SUMM1 Unit of Measure for Quantity Total UNIT 3 0 T006 CK_MESUMM
SUMM1_KPF Quantities total for item category S QUAN 15 3 SUMME_MNG
SUMM2_KPF Capital Spending Total for Item Category S CURR 15 2 SUMME_INV
SUMM3_KPF Total of two or more items CURR 15 2 SUMME_POS
EXTNR Base Planning Object (External Number) CHAR 18 0 CKBS EXTNR
KOSTL Cost Center CHAR 10 0 * KOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
KSTAR Cost Element CHAR 10 0 * KSTAR
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 * HRKFT
KALSM Costing Sheet CHAR 6 0 * AUFKALSM
ZSCHL Overhead key CHAR 6 0 AUFZSCHL
TEMPLATE Template CHAR 10 0 * ABC_TEMPL
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
TWGES Total Value in Item Foreign Currency CURR 15 2 TWGES
TKURST Exchange Rate Type for Item Foreign Currency CHAR 4 0 TCURV TKURST
TWAER Item Foreign Currency CUKY 5 0 TCURC KKTWAER
KKBWVAR Valuation Variant in Costing CHAR 3 0 TCK05 KK_BWVAR
KKSAPRL Release the document as it was last saved CHAR 4 0 KK_SAPRL
TKURS Exchange Rate for Item Foreign Currency DEC 9 5 TKURS
KZROH Material Component CHAR 1 0 CK_KZROH
FILEPATH Description CHAR 66 0 KK_PATH
FILENAME File or Macro Name for Communication with MS Excel CHAR 12 0 KKXL_NAME
CKCM Costing Model CHAR 10 0 CKCM CK_COSTMODEL
CKCMV Costing Model: Model Instance NUMC 15 0 CKCMV CKI_MODELINSTANCE
MAXCID PCP: Highest Component ID Already Assigned NUMC 7 0 CK_MAX_COMPONENT_ID
INTHIER PCP: Cost Estimate Contains Internal Hierarchy CHAR 1 0 CK_INT_HIERARCHY
LOG_HANDLE Application Log: Log Handle CHAR 22 0 BALLOGHNDL

CKHS foreign key relationships

Table Field Check Table Check Field
0 CKHS AUFNR AUFK Order master data AUFNR
1 CKHS BUKRS T001 Company Codes BUKRS
0 CKHS CKCM CKCM Costing Model MANDT
0 CKHS CKCM CKCM Costing Model MODEL
1 CKHS EXTNR CKBS Base Planning Object - Unit Costing MANDT
1 CKHS EXTNR CKBS Base Planning Object - Unit Costing KOKRS
0 CKHS FCPMG T821S Distribution keys MANDT
0 CKHS FCPMG T821S Distribution keys SPRED
1 CKHS FWAER TCURC Currency Codes MANDT
1 CKHS FWAER TCURC Currency Codes WAERS
0 CKHS HWAER TCURC Currency Codes MANDT
0 CKHS HWAER TCURC Currency Codes WAERS
1 CKHS KKBWVAR TCK05 Valuation Variants in Costing MANDT
0 CKHS KOKRS TKA01 Controlling Areas MANDT
1 CKHS KURST TCURV Exchange rate types for currency translation MANDT
1 CKHS KURST TCURV Exchange rate types for currency translation KURST
0 CKHS MANDT T000 Clients MANDT
1 CKHS MEEHT T006 Units of Measurement MANDT
0 CKHS ME_SUMM1 T006 Units of Measurement MANDT
0 CKHS ME_SUMM1 T006 Units of Measurement MSEHI
1 CKHS OBJNR ONR00 General Object Number MANDT
0 CKHS TKURST TCURV Exchange rate types for currency translation MANDT
0 CKHS TKURST TCURV Exchange rate types for currency translation KURST
1 CKHS TWAER TCURC Currency Codes MANDT
1 CKHS TWAER TCURC Currency Codes WAERS