| 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 | SEQNR | Sequence number | char | 1 | 0 | NUMC | (N'0') | No | | FC_SEQNR | Allow NULL? |
| 3 | DIMEN | Dimension | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | FC_DIMEN | Allow NULL? |
| 4 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | FC_ITCLG | Allow NULL? |
| 5 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | FC_SITYP | Allow NULL? |
| 6 | RYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_RYEAR | Allow NULL? |
| 7 | PERID | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_PERID | Allow NULL? |
| 8 | RVERS | Migration: Base version | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | FC_MMD_RVERS | Allow NULL? |
| 9 | RSUBD | Migration: Default Subgroup | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | FC_MMD_RSUBD | Allow NULL? |
| 10 | MMD_SCRIT1 | General indicator, SAP Consolidation | char | 1 | 0 | CHAR | (N' ') | No | | FC_FLG | Allow NULL? |
| 11 | MMD_SCRIT2 | General indicator, SAP Consolidation | char | 1 | 0 | CHAR | (N' ') | No | | FC_FLG | Allow NULL? |
| 12 | MMD_SCRIT3 | General indicator, SAP Consolidation | char | 1 | 0 | CHAR | (N' ') | No | | FC_FLG | Allow NULL? |
| 13 | SCRIT1 | Migration: Sort criterion 1 -> Attribute: field name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MMD_SCRIT1 | Allow NULL? |
| 14 | SCRIT2 | Migration: Sort criterion 2 -> Attribute: field name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MMD_SCRIT2 | Allow NULL? |
| 15 | SCRIT3 | Migration: Sort criterion 3 -> Attribute: field name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MMD_SCRIT3 | Allow NULL? |
| 16 | MMD_ADFLD1 | Migration: Copy the master data for the 1st additional field | char | 1 | 0 | CHAR | (N' ') | No | | FC_MMD_ADFLD1 | Allow NULL? |
| 17 | MMD_ADFLD2 | Migration: Copy the master data for the 2nd additional field | char | 1 | 0 | CHAR | (N' ') | No | | FC_MMD_ADFLD2 | Allow NULL? |
| 18 | MMD_ADFLD3 | Migration: Copy the master data for the 3rd additional field | char | 1 | 0 | CHAR | (N' ') | No | | FC_MMD_ADFLD3 | Allow NULL? |
| 19 | ADFLD1 | Migration 1st char.: Field of table group ECMC | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MIG_ADFLD1 | Allow NULL? |
| 20 | ADFLD2 | Migration 2nd char.: Field of table group ECMC | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MIG_ADFLD2 | Allow NULL? |
| 21 | ADFLD3 | Migration 3rd char.: Field of table group ECMC | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FC_MIG_ADFLD3 | Allow NULL? |
| 22 | SIMULTAN | General indicator, SAP Consolidation | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_FLG | Allow NULL? |
