| 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 | TF150 | FC_DIMEN | Allow NULL? |
| 3 | STRVS | Version: Structures | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF202 | FC_STRVS | Allow NULL? |
| 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF180 | FC_CONGR | Allow NULL? |
| 5 | BUNIT | Consolidation group / Consolidation unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_BU_CG | Allow NULL? |
| 6 | RYEAR | Effective from fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_FRYEAR | Allow NULL? |
| 7 | PERID | Effective from period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_FRPERID | Allow NULL? |
| 8 | TYEAR | Effective until (fiscal) year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_TYEAR | Allow NULL? |
| 9 | TPERI | Effective until period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_TPERI | Allow NULL? |
| 10 | FYEAR | Year of first consolidation | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_FYEAR | Allow NULL? |
| 11 | FPERI | Period of first consolidation | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_FPERI | Allow NULL? |
| 12 | FEFLG | First consolidation at the end of period | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_FEFLG | Allow NULL? |
| 13 | FORGCHFLG | Indicator for Organizational Change at First Consolidation | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_FORGCHFLG | Allow NULL? |
| 14 | FORGCH | Organizational Change at First Consolidation | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | TF820 | FC_FORGCH | Allow NULL? |
| 15 | HFSYEAR | Year of Intention for Sale | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_HFSYEAR | Allow NULL? |
| 16 | HFSPERI | Period of Intention for Sale | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_HFSPERI | Allow NULL? |
| 17 | DOPYEAR | Year of Discontinued Operations | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_DOPYEAR | Allow NULL? |
| 18 | DOPPERI | Period of Discontinued Operations | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_DOPPERI | Allow NULL? |
| 19 | LYEAR | Year of divestiture accounting | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_LYEAR | Allow NULL? |
| 20 | LPERI | Period of divestiture accounting | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_LPERI | Allow NULL? |
| 21 | LBFLG | Divestiture accounting at beginning of period | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_LBFLG | Allow NULL? |
| 22 | LORGCHFLG | Indicator for Organizational Change at Divestiture Acctg | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_LORGCHFLG | Allow NULL? |
| 23 | LMERGERFLG | Divestiture Accounting Due to Merger | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_LMERGERFLG | Allow NULL? |
| 24 | PCIND | Parent unit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PCIND | Allow NULL? |
| 25 | CUIND | The assigned node is a consolidation unit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CUIND | Allow NULL? |
| 26 | IEIND | 'I'=Include/'E'=Exclude the assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_IEIND | Allow NULL? |
