| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BZOBJ | Reference Object | char | 1 | 0 | | | | Allow NULL? |
| 3 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | KALKA | Costing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | KADKY | Costing Date (Key) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | TVERS | Costing Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | BWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | char | 1 | 0 | | | | Allow NULL? |
| 9 | COMPONENT_ID | Unique Pointer to the Itemization Line (Persistent) | nvarchar | 7 | 0 | | | | Allow NULL? |
| 10 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | ZAW01 | Value of Addition or Deduction | decimal | 15 | 2 | | | | |
| 13 | ZAW02 | Value of Addition or Deduction | decimal | 15 | 2 | | | | |
| 14 | ZAW03 | Value of Addition or Deduction | decimal | 15 | 2 | | | | |
| 15 | ZAW04 | Value of Addition or Deduction | decimal | 15 | 2 | | | | |
| 16 | ZAW05 | Value of Addition or Deduction | decimal | 15 | 2 | | | | |
| 17 | ZAP01 | Percent Addition or Deduction | decimal | 5 | 2 | | | | |
| 18 | ZAP02 | Percent Addition or Deduction | decimal | 5 | 2 | | | | |
| 19 | ZAP03 | Percent Addition or Deduction | decimal | 5 | 2 | | | | |
| 20 | ZAP04 | Percent Addition or Deduction | decimal | 5 | 2 | | | | |
| 21 | ZAP05 | Percent Addition or Deduction | decimal | 5 | 2 | | | | |
| 22 | QUANTITY_B | Quantity | decimal | 15 | 3 | | | | |
| 23 | BASIC_PRICE_T | BOS: Basic Price Total | decimal | 15 | 2 | | | | |
| 24 | BASIC_PRICE_F | BOS: Fixed Basic Price | decimal | 15 | 2 | | | | |
| 25 | BASIC_VALUE_T | BOS: Total Basic Costs | decimal | 15 | 2 | | | | |
| 26 | BASIC_VALUE_F | BOS: Fixed Basic Costs | decimal | 15 | 2 | | | | |
| 27 | QUANTITY_T | Quantity | decimal | 15 | 3 | | | | |
| 28 | TARGET_PRICE_T | BOS: Total Target Price | decimal | 15 | 2 | | | | |
| 29 | TARGET_PRICE_F | BOS: Fixed Target Price | decimal | 15 | 2 | | | | |
| 30 | TARGET_VALUE_T | BOS: Total Target Costs | decimal | 15 | 2 | | | | |
| 31 | TARGET_VALUE_F | BOS: Fixed Target Costs | decimal | 15 | 2 | | | | |
