| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ID | Job ID (direct input) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | TRANC | Transaction counter for data transfer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | D_IND | Which number within a transaction must be reset? | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | MEINH | Alternative Unit of Measure for Stockkeeping Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | UMREZ | Numerator for Conversion to Base Units of Measure | decimal | 5 | 0 | | | | |
| 8 | UMREN | Denominator for conversion to base units of measure | decimal | 5 | 0 | | | | |
| 9 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | | | | Allow NULL? |
| 10 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | | | | Allow NULL? |
| 11 | NUMTP | Category of International Article Number (EAN) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | LAENG | Length | decimal | 13 | 3 | | | | |
| 13 | BREIT | Width | decimal | 13 | 3 | | | | |
| 14 | HOEHE | Height | decimal | 13 | 3 | | | | |
| 15 | MEABM | Unit of Dimension for Length/Width/Height | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | VOLUM | Volume | decimal | 13 | 3 | | | | |
| 17 | VOLEH | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | BRGEW | Gross Weight | decimal | 13 | 3 | | | | |
| 19 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | MESUB | Lower-Level Unit of Measure in a Packing Hierarchy | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | ATINN | Internal characteristic | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | MESRT | Unit of measure sort number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | XFHDW | Leading batch-specific unit of measure | char | 1 | 0 | | | | Allow NULL? |
| 24 | XBEWW | Valuation based on the batch-specific unit of measure | char | 1 | 0 | | | | Allow NULL? |
| 25 | KZWSO | Units of measure usage | char | 1 | 0 | | | | Allow NULL? |
| 26 | MSEHI | Unit of Measurement of Characteristic | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | BFLME_MARM | Generic Material with Logistical Variants | char | 1 | 0 | | | | Allow NULL? |
| 28 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | NEST_FTR | Remaining Volume after Nesting (in Percentage) | decimal | 3 | 0 | | | | |
| 30 | MAX_STACK | Maximum Stacking Factor | tinyint | 3 | 0 | | | | |
| 31 | CAPAUSE | Capacity Usage | decimal | 15 | 3 | | | | |
| 32 | TY2TQ | EWM-CW: Category of Unit of Measure | char | 1 | 0 | | | | Allow NULL? |
