| 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 | T001W | WERKS_D | Allow NULL? |
| 4 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | MCHA | CHARG_D | Allow NULL? |
| 5 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LIFNR | Allow NULL? |
| 6 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | No | T148 | SOBKZ | Allow NULL? |
| 7 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN | Allow NULL? |
| 8 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR | Allow NULL? |
| 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LFGJA | Allow NULL? |
| 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LFMON | Allow NULL? |
| 11 | CASPR | Physical Inventory Blocking Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SPERR | Allow NULL? |
| 12 | CALAB | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LABST | |
| 13 | CAINS | Stock in Quality Inspection | decimal | 13 | 3 | QUAN | ((0)) | Yes | | INSME | |
| 14 | CASPE | Blocked Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SPEME | |
| 15 | CAVLA | Valuated unrestricted-use stock in previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMLAB | |
| 16 | CAVIN | Stock in Quality Inspection in Previous Period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMINS | |
| 17 | CAVSP | Blocked stock of previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMSPE | |
| 18 | CAILL | Physical inventory indicator for whse stock in current year | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZILL | Allow NULL? |
| 19 | CAILQ | Phys. inventory ind. f. stock in qual. insp. in current year | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZILQ | Allow NULL? |
| 20 | CAILS | Physical inventory indicator for blocked stock | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZILS | Allow NULL? |
| 21 | CAVLL | Physical inventory indicator for stock in previous year | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZVLL | Allow NULL? |
| 22 | CAVLQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZVLQ | Allow NULL? |
| 23 | CAVLS | Phys. inventory indicator for blocked stock in prev. period | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZVLS | Allow NULL? |
| 24 | CAFLL | Physical inventory indicator for stock in following year | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZFLL | Allow NULL? |
| 25 | CAFLQ | Physical inventory indicator, quality insp.stck, follow.yr. | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZFLQ | Allow NULL? |
| 26 | CAFLS | Phys. inventory ind. for blocked stock in following period | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KZFLS | Allow NULL? |
| 27 | CAJIN | Fiscal year of current physical inventory indicator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJINV | Allow NULL? |
| 28 | CARUE | MxxxH rec. already exists for per. before last of Mxxx per. | char | 1 | 0 | CHAR | (N' ') | Yes | | SBRUE | Allow NULL? |
