| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | BZOBJ | Reference Object | char | 1 | 0 | | | | Allow NULL? |
| 4 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | KALKA | Costing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | KADKY | Costing Date (Key) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TVERS | Costing Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | BWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | char | 1 | 0 | | | | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | KOKRS | Controlling Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | FCPMG | Distribution Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | FROPER | First Valid Period (from Period) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | DIPER | Interval Between Planned Periods | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | TOPER | Last Posting Period Allowed | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | KKART | Costing Variant (Corresponds to KLVAR) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | ERFDT | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ERFNM | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | AENDT | Date of last change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | AENNM | Last changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | ABSDT | Close date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | ABSNM | User ID of the person who closed the cost estimate | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | KRSDT | Exchange Rate Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | STATK | Header Status | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | STRNG | Internal header control | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | PSDAT | Pricing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | MENGE | Lot Size | decimal | 15 | 3 | | | | |
| 29 | MEEHT | Valuation Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | HWGES | Total Value of Cost Estimate in Local Currency | decimal | 15 | 2 | | | | |
| 31 | HWGFX | Fixed Portion of Costing Value in Local Currency | decimal | 15 | 2 | | | | |
| 32 | FWGES | Total Value for Cost Estimate in Foreign Currency | decimal | 15 | 2 | | | | |
| 33 | HWAER | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | FWAER | Foreign Currency in Header | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | UKURS | Exchange Rate | decimal | 9 | 5 | | | | |
| 36 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | FFACT | Factor for the "From" Currency Units | decimal | 9 | 0 | | | | |
| 38 | TFACT | Factor for the "To" Currency Units | decimal | 9 | 0 | | | | |
| 39 | GWRT1 | Total Value of Price Component 1 | decimal | 15 | 2 | | | | |
| 40 | GWRT2 | Total Value of Price Component 1 | decimal | 15 | 2 | | | | |
| 41 | GWRT3 | Total Value of Price Component 1 | decimal | 15 | 2 | | | | |
| 42 | GWRT4 | Total Value of Price Component 1 | decimal | 15 | 2 | | | | |
| 43 | GWRT5 | Total Value of Price Component 1 | decimal | 15 | 2 | | | | |
| 44 | STFLG | Sales Order Cost Estimate Is Marked | char | 1 | 0 | | | | Allow NULL? |
| 45 | ZTFLG | Flag for time-based unit costing | char | 1 | 0 | | | | Allow NULL? |
| 46 | FVFLG | Fixed/Variable Indicator | char | 1 | 0 | | | | Allow NULL? |
| 47 | DLFLG | Deletion Flag for Unit Costing | char | 1 | 0 | | | | Allow NULL? |
| 48 | FRFLG | Release Flag | char | 1 | 0 | | | | Allow NULL? |
| 49 | PRVFN | Pricing procedure | char | 1 | 0 | | | | Allow NULL? |
| 50 | PKANZ | Number of Price Components | char | 1 | 0 | | | | Allow NULL? |
| 51 | PSANZ | Number of Costing Items | nvarchar | 5 | 0 | | | | Allow NULL? |
| 52 | KNNZ1 | Cost Estimate Created with Excel | char | 1 | 0 | | | | Allow NULL? |
| 53 | KNNZ2 | Indicator - Postprocessing of product cost estimate | char | 1 | 0 | | | | Allow NULL? |
| 54 | KNNZ3 | Unit Costing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 55 | KNNZ4 | Unit Costing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 56 | KNNZ5 | Unit Costing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 57 | ME_SUMM1 | Unit of Measure for Quantity Total | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | SUMM1_KPF | Quantities total for item category S | decimal | 15 | 3 | | | | |
| 59 | SUMM2_KPF | Capital Spending Total for Item Category S | decimal | 15 | 2 | | | | |
| 60 | SUMM3_KPF | Total of two or more items | decimal | 15 | 2 | | | | |
| 61 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | | | Allow NULL? |
| 62 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 64 | KSTAR | Cost Element | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | HRKFT | Origin Group as Subdivision of Cost Element | nvarchar | 4 | 0 | | | | Allow NULL? |
| 66 | KALSM | Costing Sheet | nvarchar | 6 | 0 | | | | Allow NULL? |
| 67 | ZSCHL | Overhead key | nvarchar | 6 | 0 | | | | Allow NULL? |
| 68 | TEMPLATE | Template | nvarchar | 10 | 0 | | | | Allow NULL? |
| 69 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 70 | TWGES | Total Value in Item Foreign Currency | decimal | 15 | 2 | | | | |
| 71 | TKURST | Exchange Rate Type for Item Foreign Currency | nvarchar | 4 | 0 | | | | Allow NULL? |
| 72 | TWAER | Item Foreign Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 73 | KKBWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 74 | KKSAPRL | Release the document as it was last saved | nvarchar | 4 | 0 | | | | Allow NULL? |
| 75 | TKURS | Exchange Rate for Item Foreign Currency | decimal | 9 | 5 | | | | |
| 76 | KZROH | Material Component | char | 1 | 0 | | | | Allow NULL? |
| 77 | FILEPATH | Description | nvarchar | 66 | 0 | | | | Allow NULL? |
| 78 | FILENAME | File or Macro Name for Communication with MS Excel | nvarchar | 12 | 0 | | | | Allow NULL? |
| 79 | CKCM | Costing Model | nvarchar | 10 | 0 | | | | Allow NULL? |
| 80 | CKCMV | Costing Model: Model Instance | nvarchar | 15 | 0 | | | | Allow NULL? |
| 81 | MAXCID | PCP: Highest Component ID Already Assigned | nvarchar | 7 | 0 | | | | Allow NULL? |
| 82 | INTHIER | PCP: Cost Estimate Contains Internal Hierarchy | char | 1 | 0 | | | | Allow NULL? |
| 83 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
