| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | UNTPER | Value Structure Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | PRICETYPE | Price Type for Material Prices | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | MEINH | Unit of Measure for Display | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | FROMYEARPER | Valid from Period | nvarchar | 7 | 0 | | | | Allow NULL? |
| 8 | TIMESTAMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | | | |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | PRICE | Price for Ending Inventory Valuation | decimal | 11 | 2 | | | | |
| 11 | PEINH | Price Unit | decimal | 5 | 0 | | | | |
| 12 | TOYEARPER | Valid to period | nvarchar | 7 | 0 | | | | Allow NULL? |
| 13 | FROMDAT | Valid-from Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | TODAT | Valid to Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | USED | Price Has Been Used for Price Change | char | 1 | 0 | | | | Allow NULL? |
| 16 | BZOBJ | Reference Object | char | 1 | 0 | | | | Allow NULL? |
| 17 | KALKA | Costing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | KADKY | Costing Date (Key) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | TVERS | Costing Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | BWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | char | 1 | 0 | | | | Allow NULL? |
| 22 | ERZKA | Cost Estimate Created with Product Costing | char | 1 | 0 | | | | Allow NULL? |
| 23 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | FUNCTION | Function of BAPI | nvarchar | 3 | 0 | | | | Allow NULL? |