| 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 | * | MANDT | Allow NULL? |
| 2 | TAB | Totals Table | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | GLTAB | Allow NULL? |
| 3 | FELD | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 4 | TINPUT | Indicator: Required for master data texts? | char | 1 | 0 | CHAR | (N' ') | Yes | | TINPUT | Allow NULL? |
| 5 | ZUSATZEXIT | Ind.: Exit for additional values or additional information | char | 1 | 0 | CHAR | (N' ') | Yes | | DZUSATZEXI | Allow NULL? |
| 6 | MASTTAB | Master data table (validation) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | MASTTAB | Allow NULL? |
| 7 | RFIELD1 | Necessary field for master data calculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFIELD | Allow NULL? |
| 8 | RFIELD2 | Necessary field for master data calculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFIELD | Allow NULL? |
| 9 | RFIELD3 | Necessary field for master data calculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFIELD | Allow NULL? |
| 10 | RFIELD4 | Necessary field for master data calculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFIELD | Allow NULL? |
| 11 | RFIELD5 | Necessary field for master data calculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFIELD | Allow NULL? |
| 12 | PLANFIX | Indicator: Is the dimension a fixed planning field? | char | 1 | 0 | CHAR | (N' ') | Yes | | PLANFIX | Allow NULL? |
| 13 | PLANSET | Indicator: May field be used in planning set? | char | 1 | 0 | CHAR | (N' ') | Yes | | PLANSET | Allow NULL? |
| 14 | PRTDIM | Partner field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | PRTDIM | Allow NULL? |
| 15 | VALUE_TAB | Value table for FI-SL master data validation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | VALUE_TAB | Allow NULL? |
| 16 | VALUE_FIELD | Field name in value table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | VALUE_FIELD | Allow NULL? |
| 17 | TEXT_TAB | Text table for FI-SL master data | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TEXT_TAB | Allow NULL? |
| 18 | TEXT_FIELD_S | Field for short text | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TEXT_FIELDS_S | Allow NULL? |
| 19 | TEXT_FIELD_L | Field name for long text | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TEXT_FIELD_L | Allow NULL? |
| 20 | PLANINIT | Indicator: Upload of Initial Values Allowed in Planning | char | 1 | 0 | CHAR | (N' ') | Yes | | PLANINIT | Allow NULL? |
