| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | KALNR | Cost Estimate Number (Unit Costing) | nvarchar | 8 | 0 | CHAR | (N' ') | No | | KALNR | Allow NULL? |
| 4 | WTTYP | Unit costing value type | nvarchar | 2 | 0 | NUMC | (N'00') | No | | WTTYP | Allow NULL? |
| 5 | VERSN | Version Number of the Value Type of a Unit Cost Estimate | nvarchar | 2 | 0 | NUMC | (N'00') | No | | VERS2 | Allow NULL? |
| 6 | KKART | Costing Variant (Corresponds to KLVAR) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKKEA | KKART | Allow NULL? |
| 7 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 8 | ERFDT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDT | Allow NULL? |
| 9 | ERFNM | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFNM | Allow NULL? |
| 10 | AENDT | Date of last change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDT | Allow NULL? |
| 11 | AENNM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENNM | Allow NULL? |
| 12 | ABSDT | Close date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABSDT | Allow NULL? |
| 13 | ABSNM | User ID of the person who closed the cost estimate | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ABSNM | Allow NULL? |
| 14 | STATK | Header Status | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STATK | Allow NULL? |
| 15 | STRNG | Internal header control | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STRNG | Allow NULL? |
| 16 | PSDAT | Pricing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PSDAT | Allow NULL? |
| 17 | MENGE | Lot Size | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MENGE_KPF | |
| 18 | MEEHT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 19 | HWGES | Total Value of Cost Estimate in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | HWGES | |
| 20 | FWGES | Total Value for Cost Estimate in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FWGES | |
| 21 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 22 | FWAER | Foreign Currency in Header | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FWAER | Allow NULL? |
| 23 | UKURS | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | UKURS_D | |
| 24 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 25 | FFACT | Factor for the "From" Currency Units | decimal | 9 | 0 | DEC | ((0)) | Yes | | FFACT | |
| 26 | TFACT | Factor for the "To" Currency Units | decimal | 9 | 0 | DEC | ((0)) | Yes | | TFACT_D | |
| 27 | GWRT1 | Total Value of Price Component 1 | decimal | 15 | 2 | CURR | ((0)) | Yes | | GWRT1 | |
| 28 | GWRT2 | Total Value of Price Component 1 | decimal | 15 | 2 | CURR | ((0)) | Yes | | GWRT1 | |
| 29 | GWRT3 | Total Value of Price Component 1 | decimal | 15 | 2 | CURR | ((0)) | Yes | | GWRT1 | |
| 30 | GWRT4 | Total Value of Price Component 1 | decimal | 15 | 2 | CURR | ((0)) | Yes | | GWRT1 | |
| 31 | GWRT5 | Total Value of Price Component 1 | decimal | 15 | 2 | CURR | ((0)) | Yes | | GWRT1 | |
| 32 | STFLG | Sales Order Cost Estimate Is Marked | char | 1 | 0 | CHAR | (N' ') | Yes | | STFLG | Allow NULL? |
| 33 | ZTFLG | Flag for time-based unit costing | char | 1 | 0 | CHAR | (N' ') | Yes | | DZTFLG | Allow NULL? |
| 34 | FVFLG | Fixed/Variable Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FVFLG | Allow NULL? |
| 35 | DLFLG | Deletion Flag for Unit Costing | char | 1 | 0 | CHAR | (N' ') | Yes | | DLFLG | Allow NULL? |
| 36 | FRFLG | Release Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FRFLG | Allow NULL? |
| 37 | PRVFN | Pricing procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | PRVFN | Allow NULL? |
| 38 | PKANZ | Number of Price Components | char | 1 | 0 | NUMC | (N'0') | Yes | | PKANZ | Allow NULL? |
| 39 | BZOBJ | Reference Object | char | 1 | 0 | CHAR | (N' ') | Yes | | BZOBJ | Allow NULL? |
| 40 | PSANZ | Number of Costing Items | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | PSANZ | Allow NULL? |
| 41 | KNNZ1 | Unit Costing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCHN | Allow NULL? |
| 42 | KNNZ2 | Unit Costing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCHN | Allow NULL? |
| 43 | KNNZ3 | Unit Costing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCHN | Allow NULL? |
| 44 | KNNZ4 | Unit Costing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCHN | Allow NULL? |
| 45 | KNNZ5 | Unit Costing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCHN | Allow NULL? |
