| 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 | KALST | Costing Level | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | KALVZAE | Numerator for Costing Run Tables (KAL*) | int | 10 | 0 | | | | Allow NULL? |
| 7 | DISST | Low-Level Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | CYCLENR | Cycle Number Within a Run | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 11 | KALNR | Cost Estimate Number - Product Costing | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | VERID | Production Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | PSPNR | Work Breakdown Structure Element (WBS element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | STLAN | BOM Usage | char | 1 | 0 | | | | Allow NULL? |
| 18 | STNUM | Bill of material | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | STALT | Alternative BOM | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | STVFIX | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 21 | ALTSL | Method for Selecting Alternative Bills of Material | char | 1 | 0 | | | | Allow NULL? |
| 22 | PLNTY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 23 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | PLNAL | Group Counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | PLNCT | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | LOSGR | Planned lot size | decimal | 13 | 3 | | | | |
| 27 | SUMLO | Planned lot size | decimal | 13 | 3 | | | | |
| 28 | LOSAU | Lot Size Taking Scrap into Account | decimal | 13 | 3 | | | | |
| 29 | AUSSS | Assembly scrap in percent | decimal | 5 | 2 | | | | |
| 30 | MEINS | Valuation Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | KADAT | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | BIDAT | Costing Date To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | ALDAT | Quantity Structure Date for Costing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | BEDAT | Requirements Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | BWDAT | Valuation Date of a Cost Estimate | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | FEH_A_ANZ | No. System Messages in Selection/Qty Structure Determination | int | 10 | 0 | | | | Allow NULL? |
| 37 | FEH_K_ANZ | Number of System Messages in Costing | int | 10 | 0 | | | | Allow NULL? |
| 38 | FEH_STATUS | Costing Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | FEH_STATUF | Costing Status for Marked/Released Objects | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 41 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | LABOR | Laboratory/design office | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | VAGRP | Responsible planner group/department | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | SOBSL | Special Procurement Key for the Costing Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | SOBES | Special procurement type | char | 1 | 0 | | | | Allow NULL? |
| 46 | SOWRK | Special Procurement Plant - Costing | nvarchar | 4 | 0 | | | | Allow NULL? |
| 47 | SODUM | Phantom item indicator | char | 1 | 0 | | | | Allow NULL? |
| 48 | SBDKZ | Dependent requirements ind. for individual and coll. reqmts | char | 1 | 0 | | | | Allow NULL? |
| 49 | BESKZ | Procurement Type | char | 1 | 0 | | | | Allow NULL? |
| 50 | KOSGR | Costing Overhead Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | ZSCHL | Costing Overhead Key | nvarchar | 6 | 0 | | | | Allow NULL? |
| 52 | CUOBJ | Object Number for Conf. Objects | nvarchar | 18 | 0 | | | | Allow NULL? |
| 53 | CUOBJID | Indicator for Configurable Objects | char | 1 | 0 | | | | Allow NULL? |
| 54 | TYPE | Configured Material (Variant) | nvarchar | 18 | 0 | | | | Allow NULL? |
| 55 | WRKLT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 56 | PROZESS | Process Through Which Co-Product Was Costed | nvarchar | 18 | 0 | | | | Allow NULL? |
| 57 | KZKUP | Indicator: Material can be co-product | char | 1 | 0 | | | | Allow NULL? |
| 58 | FXPRU | Fixed-Price Co-Product | char | 1 | 0 | | | | Allow NULL? |
| 59 | PR_LOSGR | Planned lot size | decimal | 13 | 3 | | | | |
| 60 | PR_SUMLO | Planned lot size | decimal | 13 | 3 | | | | |
| 61 | PR_LOSAU | Lot Size Taking Scrap into Account | decimal | 13 | 3 | | | | |
| 62 | PR_MEINS | Valuation Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 63 | PR_VERID | Production Version To Be Costed | nvarchar | 4 | 0 | | | | Allow NULL? |
| 64 | MLMAA | Material ledger activated at material level | char | 1 | 0 | | | | Allow NULL? |
| 65 | ERFNM | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 66 | ROHSTOFF | Material Component | char | 1 | 0 | | | | Allow NULL? |
| 67 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 68 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 69 | MTART | Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 70 | BALTKZ | Cost Estimate for a Procurement Alternative | char | 1 | 0 | | | | Allow NULL? |
| 71 | KALNR_BA | Cost Estimate Number of Procurement Alternative | nvarchar | 12 | 0 | | | | Allow NULL? |
| 72 | MKALK | Mixed Costing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 73 | BTYP | Process Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 74 | SGT_COVS | Segmentation Strategy | nvarchar | 8 | 0 | | | | Allow NULL? |
| 75 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | | | Allow NULL? |
