| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SNKOM | Record number of communication document for WMS link | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | LNKOM | Sequence Number in a Communication Record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | SSKOM | Status of Communication Record for WMS Link | char | 1 | 0 | | | | Allow NULL? |
| 5 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | BNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | KZHZU | Indicator: Create material master, otherwise change | char | 1 | 0 | | | | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | MTART | Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | MBRSH | Industry sector | char | 1 | 0 | | | | Allow NULL? |
| 12 | SPRAS | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 13 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 14 | XCHPF | Batch management requirement indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | AUSME | Unit of issue | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | UMRZ1 | Numerator for converting to base unit of measure(NUM format) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | UMRN1 | Factor for converting to base unit of measure (NUM format) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | UMRZ2 | Numerator for converting to base unit of measure(NUM format) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | UMRN2 | Factor for converting to base unit of measure (NUM format) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | BRGEW | Gross weight (NUMC format) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 23 | GEWEI | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | VOLUM | Volume (NUM format) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 25 | VOLEH | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | LVOMA | Flag Material for Deletion at Client Level | char | 1 | 0 | | | | Allow NULL? |
| 27 | LVOWK | Flag Material for Deletion at Plant Level | char | 1 | 0 | | | | Allow NULL? |
