| 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 | DIMEN | Dimension | nvarchar | 2 | 0 | CHAR | (N' ') | No | | FC_DIMEN | Allow NULL? |
| 3 | IAIND | Status indicator | char | 1 | 0 | CHAR | (N' ') | No | | FC_IAIND_D | Allow NULL? |
| 4 | BULGH | Length of the consolidation unit | nvarchar | 2 | 0 | NUMC | (N'00') | No | | FC_BULGH | Allow NULL? |
| 5 | CGLGH | Length of consolidation group | nvarchar | 2 | 0 | NUMC | (N'00') | No | | FC_CGLGH | Allow NULL? |
| 6 | INDGS | Company consolidation activated | char | 1 | 0 | CHAR | (N' ') | No | | GSNK | Allow NULL? |
| 7 | INDGB | Business area consolidation active | char | 1 | 0 | CHAR | (N' ') | No | | GSBK | Allow NULL? |
| 8 | INDPC | Profit center consolidation activated | char | 1 | 0 | CHAR | (N' ') | No | | PCK | Allow NULL? |
| 9 | ITCLG_FI | Consolidation chart of accounts for data transfer | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG_I | Allow NULL? |
| 10 | SITYP_FI | Subitem category for data transfers | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF110 | FC_SITYP_I | Allow NULL? |
| 11 | SIGNC_FI | Delimiter for Companies & Business Areas | char | 1 | 0 | CHAR | (N' ') | No | | FC_SIGNCFI | Allow NULL? |
| 12 | IGSGB_FI | Sequence for converting companies/business areas | char | 1 | 0 | NUMC | (N'0') | No | | FC_IGSGBFI | Allow NULL? |
| 13 | HLIND | Use hierarchy levels | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HLIND | Allow NULL? |
| 14 | PCUIND | Substitute the partner unit during the rollup | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PCUIND | Allow NULL? |
| 15 | REVIND | Reverse documents | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_REVIND | Allow NULL? |
| 16 | PROTYP | Apportionment Procedure for Two-sided Eliminations | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_PROTYP | Allow NULL? |
| 17 | CIINVCHECK | Check Investment Against Equity | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CIINVCHECK | Allow NULL? |
| 18 | HRFSCAT | Cons frequency of amortization of reported fair value adjs | char | 1 | 0 | CHAR | (N' ') | Yes | TF240 | FC_HRFSCAT | Allow NULL? |
| 19 | USTPFLG | Universal Statistical Posting Logic | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_USTPFLG | Allow NULL? |
| 20 | NEWLL_YEAR | Fiscal Year from Which New Level Logic Is to Be Applied | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_NEWLL_YEAR | Allow NULL? |
| 21 | SETGENMODE | Options for automatic set generation | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_SETGENMODE | Allow NULL? |
| 22 | SETGENCGY | Year or Period-dependent Sets for Cons Groups | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SETGENCGY | Allow NULL? |
| 23 | DOCTY_ACS | Document type for standardizing entries | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TF500 | FC_DOCTY_10 | Allow NULL? |
| 24 | ASTHFS | Assets Held for Sale | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ASTHFS | Allow NULL? |
