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