SAP table KKS1 (CKKS + CKKT)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |||||||||
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||
| KALNR | Cost Estimate Number (Unit Costing) | CHAR | 8 | 0 | KALNR | ||||||||||
| WTTYP | Unit costing value type | NUMC | 2 | 0 | WTTYP | ||||||||||
| VERSN | Version Number of the Value Type of a Unit Cost Estimate | NUMC | 2 | 0 | * | VERS2 | |||||||||
| 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 | ||||||||||
| 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 | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |||||||||
| HWGES | Total Value of Cost Estimate in Local Currency | CURR | 15 | 2 | HWGES | ||||||||||
| 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 |
|
|||||||||
| DLFLG | Deletion Flag for Unit Costing | CHAR | 1 | 0 | DLFLG | ||||||||||
| FRFLG | Release Flag | CHAR | 1 | 0 | FRFLG | ||||||||||
| PRVFN | Pricing Procedure | CHAR | 1 | 0 | PRVFN |
|
|||||||||
| PKANZ | Number of Price Components | NUMC | 1 | 0 | PKANZ | ||||||||||
| BZOBJ | Reference Object | CHAR | 1 | 0 | BZOBJ |
|
|||||||||
| PSANZ | Number of Costing Items | NUMC | 5 | 0 | * | PSANZ | |||||||||
| KNNZ1 | Unit Costing Indicator | CHAR | 1 | 0 | KZCHN | ||||||||||
| KNNZ2 | Unit Costing Indicator | CHAR | 1 | 0 | KZCHN | ||||||||||
| KNNZ3 | Unit Costing Indicator | CHAR | 1 | 0 | KZCHN | ||||||||||
| KNNZ4 | Unit Costing Indicator | CHAR | 1 | 0 | KZCHN | ||||||||||
| KNNZ5 | Unit Costing Indicator | CHAR | 1 | 0 | KZCHN | ||||||||||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |||||||||
| TXN08 | Number of the Standard Text | CHAR | 8 | 0 | TXN08 | ||||||||||
| KTEXT | General Name | CHAR | 20 | 0 | KTEXT | ||||||||||
| LTEXT | Description | CHAR | 40 | 0 | KLTXT |
KKS1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KKS1 | FWAER | TCURC | Currency Codes | MANDT |
| 0 KKS1 | FWAER | TCURC | Currency Codes | WAERS |
| 1 KKS1 | HWAER | TCURC | Currency Codes | MANDT |
| 1 KKS1 | HWAER | TCURC | Currency Codes | WAERS |
| 0 KKS1 | KOKRS | TKA01 | Controlling Areas | MANDT |
| 1 KKS1 | KURST | TCURV | Exchange rate types for currency translation | MANDT |
| 1 KKS1 | KURST | TCURV | Exchange rate types for currency translation | KURST |
| 0 KKS1 | MEEHT | T006 | Units of Measurement | MANDT |