| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MCINF | Name of information structure | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | GSTRU | Generated DDIC table for LIS, conditions, messages | nvarchar | 30 | 0 | | | | Allow NULL? |
| 4 | STABL | Report Writer table | nvarchar | 30 | 0 | | | | Allow NULL? |
| 5 | DDICT | Table Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 6 | SPERI | Period split: info structure | char | 1 | 0 | | | | Allow NULL? |
| 7 | MCAPP | Number of application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | KBTCH | Indicator for U1/U2/U3 updating of info structures | char | 1 | 0 | | | | Allow NULL? |
| 9 | MCITY | Type of info structure, type <> space: internal use | char | 1 | 0 | | | | Allow NULL? |
| 10 | SPZIS | Type of info structure | char | 1 | 0 | | | | Allow NULL? |
| 11 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | HIERT | Hierarchy category for Sales and Operations Planning | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | MCSTI | LIS: status of the information structure | char | 1 | 0 | | | | Allow NULL? |
| 14 | PLREL | Information structure without planning (Yes/No) | char | 1 | 0 | | | | Allow NULL? |