| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | | | Allow NULL? |
| 5 | LVORM | Deletion flag for all material data of a warehouse number | char | 1 | 0 | | | | Allow NULL? |
| 6 | LGBKZ | Storage Section Indicators | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | LTKZE | Storage type indicator for stock placement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | LTKZA | Storage type indicator for stock removal | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | LHMG1 | Loading equipment quantity 1 | decimal | 13 | 3 | | | | |
| 10 | LHMG2 | Loading equipment quantity 2 | decimal | 13 | 3 | | | | |
| 11 | LHMG3 | Loading equipment quantity 3 | decimal | 13 | 3 | | | | |
| 12 | LHME1 | Unit of measure for loading equipment quantity 1 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | LHME2 | Unit of measure for loading equipment quantity 2 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | LHME3 | Unit of measure for loading equipment quantity 3 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | LETY1 | 1st storage unit type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | LETY2 | 2nd storage unit type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | LETY3 | 3rd storage unit type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | LVSME | Warehouse Management Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | KZZUL | Indicator: Allow addition to existing stock | char | 1 | 0 | | | | Allow NULL? |
| 20 | BLOCK | Bulk storage indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | KZMBF | Indicator: Message to inventory management | char | 1 | 0 | | | | Allow NULL? |
| 22 | BSSKZ | Special movement indicator for warehouse management | char | 1 | 0 | | | | Allow NULL? |
| 23 | MKAPV | Capacity usage | decimal | 11 | 3 | | | | |
| 24 | BEZME | Unit of measure for capacity consumption | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | PLKPT | Picking storage type for rough-cut and detailed planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | VOMEM | Default for unit of measure from material master record | char | 1 | 0 | | | | Allow NULL? |
| 27 | L2SKR | Material relevance for 2-step picking | char | 1 | 0 | | | | Allow NULL? |
