| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KALAID | Name of Costing Run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | KALADAT | Costing Run Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | TVERS | Costing Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | DISST | Low-Level Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | KALVZAE | Numerator for Costing Run Tables (KAL*) | int | 10 | 0 | | | | Allow NULL? |
| 7 | SELKZ | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 12 | VERID | Production Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | STLAN | BOM Usage | char | 1 | 0 | | | | Allow NULL? |
| 14 | STNUM | Bill of material | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | STALT | Alternative BOM | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | PLNTY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 17 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | PLNAL | Group Counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | PLNCT | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | LOSGR | Planned lot size | decimal | 13 | 3 | | | | |
| 21 | SUMLO | Planned lot size | decimal | 13 | 3 | | | | |
| 22 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | KADAT | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | ROHSTOFF | Material Component | char | 1 | 0 | | | | Allow NULL? |
| 25 | SUMMENSATZ | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 26 | BIDAT | Costing Date To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | ALDAT | Quantity Structure Date for Costing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | BWDAT | Valuation Date of a Cost Estimate | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | FEH_A_ANZ | No. System Messages in Selection/Qty Structure Determination | int | 10 | 0 | | | | Allow NULL? |
| 31 | FEH_K_ANZ | Number of System Messages in Costing | int | 10 | 0 | | | | Allow NULL? |
| 32 | FEH_STATUS | Costing Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | ERFNM | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 36 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | LABOR | Laboratory/design office | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | VAGRP | Responsible planner group/department | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | SOBSL | Special Procurement Key for the Costing Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | SOWRK | Special Procurement Plant - Costing | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | KOSGR | Costing Overhead Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | ZSCHL | Costing Overhead Key | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | FEH_STATUF | Costing Status for Marked/Released Objects | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | LOSAU | Lot Size Taking Scrap into Account | decimal | 13 | 3 | | | | |
| 46 | CUOBJ | Object Number for Conf. Objects | nvarchar | 18 | 0 | | | | Allow NULL? |
| 47 | CUOBJID | Indicator for Configurable Objects | char | 1 | 0 | | | | Allow NULL? |
| 48 | TYPE | Configured Material (Variant) | nvarchar | 18 | 0 | | | | Allow NULL? |
| 49 | PROZESS | Process Through Which Co-Product Was Costed | nvarchar | 18 | 0 | | | | Allow NULL? |
| 50 | KZKUP | Indicator: Material can be co-product | char | 1 | 0 | | | | Allow NULL? |
| 51 | PR_LOSGR | Planned lot size | decimal | 13 | 3 | | | | |
| 52 | PR_SUMLO | Planned lot size | decimal | 13 | 3 | | | | |
| 53 | PR_LOSAU | Lot Size Taking Scrap into Account | decimal | 13 | 3 | | | | |
| 54 | PR_MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | PR_VERID | Production Version To Be Costed | nvarchar | 4 | 0 | | | | Allow NULL? |
| 56 | STVFIX | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 57 | SBDKZ | Dependent requirements ind. for individual and coll. reqmts | char | 1 | 0 | | | | Allow NULL? |
| 58 | ALTSL | Method for Selecting Alternative Bills of Material | char | 1 | 0 | | | | Allow NULL? |
| 59 | MLMAA | Material ledger activated at material level | char | 1 | 0 | | | | Allow NULL? |
| 60 | BESKZ | Procurement Type | char | 1 | 0 | | | | Allow NULL? |
| 61 | AUSSS | Assembly scrap in percent | decimal | 5 | 2 | | | | |
| 62 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 64 | MTART | Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
