| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DIMEN | Dimension | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | STRVS | Version: Structures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | BUNIT | Consolidation group / Consolidation unit | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | RYEAR | Effective from fiscal year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | PERID | Effective from period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | TYEAR | Effective until (fiscal) year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | TPERI | Effective until period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | FYEAR | Year of first consolidation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | FPERI | Period of first consolidation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | FEFLG | First consolidation at the end of period | char | 1 | 0 | | | | Allow NULL? |
| 13 | FORGCHFLG | Indicator for Organizational Change at First Consolidation | char | 1 | 0 | | | | Allow NULL? |
| 14 | FORGCH | Organizational Change at First Consolidation | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | HFSYEAR | Year of Intention for Sale | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | HFSPERI | Period of Intention for Sale | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | DOPYEAR | Year of Discontinued Operations | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | DOPPERI | Period of Discontinued Operations | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | LYEAR | Year of divestiture accounting | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | LPERI | Period of divestiture accounting | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | LBFLG | Divestiture accounting at beginning of period | char | 1 | 0 | | | | Allow NULL? |
| 22 | LORGCHFLG | Indicator for Organizational Change at Divestiture Acctg | char | 1 | 0 | | | | Allow NULL? |
| 23 | LMERGERFLG | Divestiture Accounting Due to Merger | char | 1 | 0 | | | | Allow NULL? |
| 24 | PCIND | Parent unit | char | 1 | 0 | | | | Allow NULL? |
| 25 | CUIND | The assigned node is a consolidation unit | char | 1 | 0 | | | | Allow NULL? |
| 26 | IEIND | 'I'=Include/'E'=Exclude the assignment | char | 1 | 0 | | | | Allow NULL? |
