| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | FTMSTM | From/start time stamp (BDRP) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 4 | ASSCNT | Multiple material assignment counter (equal from timestamp) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | TTMSTM | To/end timestamp (BDRP) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 6 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 7 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 8 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | BSTAR | Stock type | char | 1 | 0 | | | | Allow NULL? |
| 11 | NS_STOCK | Non-special stock indicator | char | 1 | 0 | | | | Allow NULL? |
| 12 | SO_STOCK | Sales order stock indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | VC_STOCK | Vendor consignment stock indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | PR_STOCK | Project stock indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | KAPAZ_IND | Planned capacity (UoM VOL) per material segment | decimal | 13 | 3 | | | | |
| 19 | VOLUN | Volume UoM (Oil BDRP) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | PLD_TTMSTM | Planned to/end timestamp (BDRP) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 21 | ERDAT | Date record created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | ERZEIT | Time record created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | ERNAM | User who created record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | AEDAT | Date record changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | AENAM | User who changed record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | BLOIND | Blocking indicator | char | 1 | 0 | | | | Allow NULL? |
| 28 | DELIND | Deletion indicator | char | 1 | 0 | | | | Allow NULL? |
