| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | VERID | Production Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BZOBJ | Reference Object | char | 1 | 0 | | | | Allow NULL? |
| 6 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | KALKA | Costing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | KADKY | Costing Date (Key) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | TVERS | Costing Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | BWVAR | Valuation Variant in Costing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | char | 1 | 0 | | | | Allow NULL? |
| 12 | CPUDT | Date on Which Cost Estimate Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | CPUTIME | System Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | LOSGR | Lot Size for Product Costing | decimal | 13 | 3 | | | | |
| 15 | MEINS | Valuation Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | WERT_GES_BUKRS | Total Value of Cost Estimate | decimal | 15 | 2 | | | | |
| 17 | WERT_GES_KOKRS | Total Value of Cost Estimate | decimal | 15 | 2 | | | | |
| 18 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | WAERS_KO | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | CFB_MRP_VERID_KZ | Use Production Version in MRP Run | char | 1 | 0 | | | | Allow NULL? |
| 21 | CFB_CUST_LOSGR | Lot Size Referenced by the Customer-Specific Value | decimal | 13 | 3 | | | | |
| 22 | CFB_CUST_MEINS | Valuation Unit of Measure: Lot Size for Customer-Spec. Value | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | CFB_CUST_WERT | Customer's Calculated Value of a Production Version | decimal | 15 | 2 | | | | |
| 24 | CFB_CUST_WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | CFB_CUST_SORT | Customer-Specific Sort Criterion of a Production Version | nvarchar | 10 | 0 | | | | Allow NULL? |