| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 3 | MEINH | Alternative Unit of Measure for Stockkeeping Unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | LRMEI | Allow NULL? |
| 4 | UMREZ | Numerator for Conversion to Base Units of Measure | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMREZ | |
| 5 | UMREN | Denominator for conversion to base units of measure | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMREN | |
| 6 | EANNR | European Article Number (EAN) - obsolete!!!!! | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | EANNR | Allow NULL? |
| 7 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | EAN11 | Allow NULL? |
| 8 | NUMTP | Category of International Article Number (EAN) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNTP | NUMTP | Allow NULL? |
| 9 | LAENG | Length | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LAENG | |
| 10 | BREIT | Width | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BREIT | |
| 11 | HOEHE | Height | decimal | 13 | 3 | QUAN | ((0)) | Yes | | HOEHE | |
| 12 | MEABM | Unit of Dimension for Length/Width/Height | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEABM | Allow NULL? |
| 13 | VOLUM | Volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VOLUM | |
| 14 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VOLEH | Allow NULL? |
| 15 | BRGEW | Gross Weight | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BRGEW | |
| 16 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEWEI | Allow NULL? |
| 17 | MESUB | Lower-Level Unit of Measure in a Packing Hierarchy | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MESUB | Allow NULL? |
| 18 | ATINN | Internal characteristic | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | ATINN | Allow NULL? |
| 19 | MESRT | Unit of measure sort number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MESRT | Allow NULL? |
| 20 | XFHDW | Leading batch-specific unit of measure | char | 1 | 0 | CHAR | (N' ') | Yes | | XFHDW | Allow NULL? |
| 21 | XBEWW | Valuation based on the batch-specific unit of measure | char | 1 | 0 | CHAR | (N' ') | Yes | | XBEWW | Allow NULL? |
| 22 | KZWSO | Units of measure usage | char | 1 | 0 | CHAR | (N' ') | Yes | | KZWSO | Allow NULL? |
| 23 | MSEHI | Unit of Measurement of Characteristic | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TCHW2 | MSEHI_WS | Allow NULL? |
| 24 | BFLME_MARM | Generic Material with Logistical Variants | char | 1 | 0 | CHAR | (N' ') | Yes | | BFLME | Allow NULL? |
| 25 | GTIN_VARIANT | Global Trade Item Number Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GTIN_VARIANT | Allow NULL? |
| 26 | NEST_FTR | Remaining Volume after Nesting (in Percentage) | decimal | 3 | 0 | DEC | ((0)) | Yes | | CIFNESTFTR | |
| 27 | MAX_STACK | Maximum Stacking Factor | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CIFMXSTACK | |
| 28 | CAPAUSE | Capacity Usage | decimal | 15 | 3 | DEC | ((0)) | Yes | | CIFCAPAUSE | |
| 29 | TY2TQ | EWM-CW: Category of Unit of Measure | char | 1 | 0 | CHAR | (N' ') | Yes | | DE_EWMTY2TQ | Allow NULL? |
