| 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 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | KUSPR | Physical Inventory Blocking Indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | KULAB | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | | | | |
| 11 | KUINS | Stock in Quality Inspection | decimal | 13 | 3 | | | | |
| 12 | KUVLA | Valuated unrestricted-use stock in previous period | decimal | 13 | 3 | | | | |
| 13 | KUVIN | Stock in Quality Inspection in Previous Period | decimal | 13 | 3 | | | | |
| 14 | KUILL | Physical inventory indicator for whse stock in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | KUILQ | Phys. inventory ind. f. stock in qual. insp. in current year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | KUVLL | Physical inventory indicator for stock in previous year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | KUVLQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | KUFLL | Physical inventory indicator for stock in following year | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | KUFLQ | Physical inventory indicator, quality insp.stck, follow.yr. | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | KUDLL | Date of Last Posted Count for Unrestricted-Use Stock | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | KUEIN | Total Stock of All Restricted Batches | decimal | 13 | 3 | | | | |
| 22 | KUVEI | Restricted-Use Stock in Previous Period | decimal | 13 | 3 | | | | |
| 23 | ERSDA | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | KUJIN | Fiscal year of current physical inventory indicator | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | KURUE | MxxxH rec. already exists for per. before last of Mxxx per. | char | 1 | 0 | | | | Allow NULL? |
| 26 | KUUML | Stock in Transfer for Customer Consignment (Plant to Plant) | decimal | 13 | 3 | | | | |
| 27 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | | | | Allow NULL? |
