| 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 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | LGORT | Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | PSTAT | Maintenance status | nvarchar | 15 | 0 | | | | Allow NULL? |
| 9 | LVORM | Flag Material for Deletion at Storage Location Level | char | 1 | 0 | | | | Allow NULL? |
| 10 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | SPERR | Physical Inventory Blocking Indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | LABST | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | | | | |
| 14 | UMLME | Stock in transfer (from one storage location to another) | decimal | 13 | 3 | | | | |
| 15 | INSME | Stock in Quality Inspection | decimal | 13 | 3 | | | | |
| 16 | EINME | Total Stock of All Restricted Batches | decimal | 13 | 3 | | | | |
| 17 | SPEME | Blocked Stock | decimal | 13 | 3 | | | | |
| 18 | RETME | Blocked Stock Returns | decimal | 13 | 3 | | | | |
| 19 | VMLAB | Valuated unrestricted-use stock in previous period | decimal | 13 | 3 | | | | |
| 20 | VMUML | Stock in Transfer in Previous Period | decimal | 13 | 3 | | | | |
| 21 | VMINS | Stock in Quality Inspection in Previous Period | decimal | 13 | 3 | | | | |
| 22 | VMEIN | Restricted-Use Stock in Previous Period | decimal | 13 | 3 | | | | |
| 23 | VMSPE | Blocked stock of previous period | decimal | 13 | 3 | | | | |
| 24 | VMRET | Blocked Stock Returns in Previous Period | decimal | 13 | 3 | | | | |
| 25 | KZILL | Physical inventory indicator for whse stock in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | KZILQ | Phys. inventory ind. f. stock in qual. insp. in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | KZILE | Physical inventory indicator for restricted-use stock | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | KZILS | Physical inventory indicator for blocked stock | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | KZVLL | Physical inventory indicator for stock in previous year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | KZVLQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | KZVLE | Physical inventory ind. for restricted-use stock, prev.pd | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | KZVLS | Phys. inventory indicator for blocked stock in prev. period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | DISKZ | Storage location MRP indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | LSOBS | Special procurement type at storage location level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | LMINB | Reorder point for storage location MRP | decimal | 13 | 3 | | | | |
| 36 | LBSTF | Replenishment quantity for storage location MRP | decimal | 13 | 3 | | | | |
| 37 | HERKL | Country of origin of the material | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | EXPPG | Preference indicator (deactivated) | char | 1 | 0 | | | | Allow NULL? |
| 39 | EXVER | Export indicator (deactivated) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | LGPBE | Storage Bin | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | KLABS | Unrestricted-Use Consignment Stock | decimal | 13 | 3 | | | | |
| 42 | KINSM | Consignment Stock in Quality Inspection | decimal | 13 | 3 | | | | |
| 43 | KEINM | Restricted-Use Consignment Stock | decimal | 13 | 3 | | | | |
| 44 | KSPEM | Blocked Consignment Stock | decimal | 13 | 3 | | | | |
| 45 | DLINL | Date of Last Posted Count for Unrestricted-Use Stock | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | PRCTL | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | ERSDA | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 48 | VKLAB | Stock value of a value-only material at sales price | decimal | 13 | 2 | | | | |
| 49 | VKUML | Sales value in stock transfer (SLOc to SLoc) | decimal | 13 | 2 | | | | |
| 50 | LWMKB | Picking area for lean WM | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | BSKRF | Inventory correction factor | float | 15 | 16 | | | | |
| 52 | MDRUE | MARDH rec. already exists for per. before last of MARD per. | char | 1 | 0 | | | | Allow NULL? |
| 53 | MDJIN | Fiscal year of current physical inventory indicator | nvarchar | 4 | 0 | | | | Allow NULL? |
