SAP Table CKKS

Header: Unit Costing (Control + Totals)

CKKS (Header: Unit Costing (Control + Totals)) 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 CKKS to other SAP tables.

CKKS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KALNR Cost Estimate Number (Unit Costing) KALNR CHAR 8 0
WTTYP Unit costing value type WTTYP NUMC 2 0
VERSN Version Number of the Value Type of a Unit Cost Estimate VERS2 NUMC 2 0
KKART Costing Variant (Corresponds to KLVAR) KKART TKKEA CHAR 4 0
GJAHR Fiscal Year GJAHR NUMC 4 0
ERFDT Created on ERFDT DATS 8 0
ERFNM Entered by ERFNM CHAR 12 0
AENDT Date of last change AENDT DATS 8 0
AENNM Last changed by AENNM CHAR 12 0
ABSDT Close date ABSDT DATS 8 0
ABSNM User ID of the person who closed the cost estimate ABSNM CHAR 12 0
STATK Header Status STATK CHAR 4 0
STRNG Internal header control STRNG CHAR 4 0
PSDAT Pricing Date PSDAT DATS 8 0
MENGE Lot Size MENGE_KPF QUAN 15 3
MEEHT Base Unit of Measure MEINS T006 UNIT 3 0
HWGES Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
FWGES Total Value for Cost Estimate in Foreign Currency FWGES CURR 15 2
HWAER Local Currency HWAER TCURC CUKY 5 0
FWAER Foreign Currency in Header FWAER TCURC CUKY 5 0
UKURS Exchange Rate UKURS_D DEC 9 5
KURST Exchange Rate Type KURST TCURV CHAR 4 0
FFACT Factor for the "From" Currency Units FFACT DEC 9 0
TFACT Factor for the "To" Currency Units TFACT_D DEC 9 0
GWRT1 Total Value of Price Component 1 GWRT1 CURR 15 2
GWRT2 Total Value of Price Component 1 GWRT1 CURR 15 2
GWRT3 Total Value of Price Component 1 GWRT1 CURR 15 2
GWRT4 Total Value of Price Component 1 GWRT1 CURR 15 2
GWRT5 Total Value of Price Component 1 GWRT1 CURR 15 2
STFLG Sales Order Cost Estimate Is Marked STFLG CHAR 1 0
NULL no
X yes
ZTFLG Flag for time-based unit costing DZTFLG CHAR 1 0
NULL no
X yes
FVFLG Fixed/Variable Indicator FVFLG CHAR 1 0
F
V
DLFLG Deletion Flag for Unit Costing DLFLG CHAR 1 0
NULL no
X yes
FRFLG Release Flag FRFLG CHAR 1 0
NULL no
X yes
PRVFN Pricing procedure PRVFN CHAR 1 0
1 Total price
2 Fixed/variable
3 Price components
4 Price components and factors
PKANZ Number of Price Components PKANZ NUMC 1 0
BZOBJ Reference Object BZOBJ CHAR 1 0
0 Not currently used
1 Base Planning Object
2 Cost Center/Cost Element
3 Order/Cost Element
PSANZ Number of Costing Items PSANZ NUMC 5 0
KNNZ1 Unit Costing Indicator KZCHN CHAR 1 0
KNNZ2 Unit Costing Indicator KZCHN CHAR 1 0
KNNZ3 Unit Costing Indicator KZCHN CHAR 1 0
KNNZ4 Unit Costing Indicator KZCHN CHAR 1 0
KNNZ5 Unit Costing Indicator KZCHN CHAR 1 0

CKKS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKKS FWAER CKKS MANDT TCURC Currency Codes MANDT
CKKS FWAER CKKS FWAER TCURC Currency Codes WAERS
CKKS HWAER CKKS MANDT TCURC Currency Codes MANDT
CKKS HWAER CKKS HWAER TCURC Currency Codes WAERS
CKKS KKART CKKS MANDT TKKEA Unit Costing Types MANDT
CKKS KKART CKKS KKART TKKEA Unit Costing Types KKART
CKKS KOKRS CKKS MANDT TKA01 Controlling Areas MANDT
CKKS KOKRS CKKS KOKRS TKA01 Controlling Areas KOKRS
CKKS KURST CKKS MANDT TCURV Exchange rate types for currency translation MANDT
CKKS KURST CKKS KURST TCURV Exchange rate types for currency translation KURST
CKKS MEEHT CKKS MANDT T006 Units of Measurement MANDT
CKKS MEEHT CKKS MEEHT T006 Units of Measurement MSEHI