The CKKS table in SAP ERP or S/4HANA stores Header: Unit Costing (Control + Totals) data. There are total 45 fields in CKKS table. The Header: Unit Costing (Control + Totals) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CKKS table. It is in Cost Accounting: Unit Costing (KKEK) ABAP package and is part of the Product Cost Planning (CO-PC-PCP) module.
SAP CKKS Table Fields
Following is the list of fields that are available in SAP CKKS table. The primary key fields of the table are MANDT (Client), KOKRS (Controlling Area), KALNR (Cost Estimate Number (Unit Costing)), WTTYP (Unit costing value type), VERSN (Version Number of the Value Type of a Unit Cost Estimate).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
| KALNR | Cost Estimate Number (Unit Costing) | KALNR | CHAR (8) | |
| WTTYP | Unit costing value type | WTTYP | NUMC (2) | |
| VERSN | Version Number of the Value Type of a Unit Cost Estimate | VERS2 | NUMC (2) | |
| KKART | Costing Variant (Corresponds to KLVAR) | KKART | TKKEA | CHAR (4) |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| ERFDT | Entered On | ERFDT | DATS (8) | |
| ERFNM | Entered By | ERFNM | CHAR (12) | |
| AENDT | Date of last change | AENDT | DATS (8) | |
| AENNM | Last Changed By | AENNM | CHAR (12) | |
| ABSDT | Close date | ABSDT | DATS (8) | |
| ABSNM | User ID of the person who closed the cost estimate | ABSNM | CHAR (12) | |
| STATK | Header Status | STATK | CHAR (4) | |
| STRNG | Internal header control | STRNG | CHAR (4) | |
| PSDAT | Pricing Date | PSDAT | DATS (8) | |
| MENGE | Lot Size | MENGE_KPF | QUAN (15) | |
| MEEHT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| HWGES | Total Value of Cost Estimate in Local Currency | HWGES | CURR (15) | |
| FWGES | Total Value for Cost Estimate in Foreign Currency | FWGES | CURR (15) | |
| HWAER | Local Currency | HWAER | TCURC | CUKY (5) |
| FWAER | Foreign Currency in Header | FWAER | TCURC | CUKY (5) |
| UKURS | Exchange Rate | UKURS_D | DEC (9) | |
| KURST | Exchange Rate Type | KURST | TCURV | CHAR (4) |
| FFACT | Factor for the “From” Currency Units | FFACT | DEC (9) | |
| TFACT | Factor for the “To” Currency Units | TFACT_D | DEC (9) | |
| GWRT1 | Total Value of Price Component 1 | GWRT1 | CURR (15) | |
| GWRT2 | Total Value of Price Component 1 | GWRT1 | CURR (15) | |
| GWRT3 | Total Value of Price Component 1 | GWRT1 | CURR (15) | |
| GWRT4 | Total Value of Price Component 1 | GWRT1 | CURR (15) | |
| GWRT5 | Total Value of Price Component 1 | GWRT1 | CURR (15) | |
| STFLG | Sales Order Cost Estimate Is Marked | STFLG | CHAR (1) | |
| ZTFLG | Flag for time-based unit costing | DZTFLG | CHAR (1) | |
| FVFLG | Fixed/Variable Indicator | FVFLG | CHAR (1) | |
| DLFLG | Deletion Flag for Unit Costing | DLFLG | CHAR (1) | |
| FRFLG | Release Flag | FRFLG | CHAR (1) | |
| PRVFN | Pricing Procedure | PRVFN | CHAR (1) | |
| PKANZ | Number of Price Components | PKANZ | NUMC (1) | |
| BZOBJ | Reference Object | BZOBJ | CHAR (1) | |
| PSANZ | Number of Costing Items | PSANZ | NUMC (5) | |
| KNNZ1 | Unit Costing Indicator | KZCHN | CHAR (1) | |
| KNNZ2 | Unit Costing Indicator | KZCHN | CHAR (1) | |
| KNNZ3 | Unit Costing Indicator | KZCHN | CHAR (1) | |
| KNNZ4 | Unit Costing Indicator | KZCHN | CHAR (1) | |
| KNNZ5 | Unit Costing Indicator | KZCHN | CHAR (1) |
