| 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 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | SOBKZ | Special Stock Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | OWNER | Owner of stock | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | IDSPR | Physical Inventory Blocking Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | IDLAB | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | | | | |
| 12 | IDINS | Stock in Quality Inspection | decimal | 13 | 3 | | | | |
| 13 | IDVLA | Valuated unrestricted-use stock in previous period | decimal | 13 | 3 | | | | |
| 14 | IDVIN | Stock in Quality Inspection in Previous Period | decimal | 13 | 3 | | | | |
| 15 | IDILL | Physical inventory indicator for whse stock in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | IDILQ | Phys. inventory ind. f. stock in qual. insp. in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | IDVLL | Physical inventory indicator for stock in previous year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | IDVLQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | IDFLL | Physical inventory indicator for stock in following year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | IDFLQ | Physical inventory indicator, quality insp.stck, follow.yr. | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | IDDLL | Date of Last Posted Count for Unrestricted-Use Stock | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | IDEIN | Total Stock of All Restricted Batches | decimal | 13 | 3 | | | | |
| 23 | IDVEI | Restricted-Use Stock in Previous Period | decimal | 13 | 3 | | | | |
| 24 | ERSDA | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | IDJIN | Fiscal year of current physical inventory indicator | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | IDRUE | MxxxH rec. already exists for per. before last of Mxxx per. | char | 1 | 0 | | | | Allow NULL? |
