| 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 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | FC_RLDNR | Allow NULL? |
| 4 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 5 | INVVS | Version: Changes in investments | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF218 | FC_INVVS | Allow NULL? |
| 6 | COICU | Investee unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_COICU | Allow NULL? |
| 7 | RYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_RYEAR | Allow NULL? |
| 8 | PERID | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_PERID | Allow NULL? |
| 9 | BUNIT | Consolidation unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_BUNIT | Allow NULL? |
| 10 | SEQNR | Sequence number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | FC_SEQNR2 | Allow NULL? |
| 11 | COIAC | C/I Activity: Investment holdings | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FC_COIACIN | Allow NULL? |
| 12 | COINR | Consolidation of investments activity number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FC_COINR | Allow NULL? |
| 13 | ITEM | Financial statement item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_ITEM | Allow NULL? |
| 14 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 15 | SITEM | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 16 | BUPTR | Partner unit | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | TF160 | FC_BUPTR | Allow NULL? |
| 17 | SPCNT | Sign of the change in investment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SPCNT | Allow NULL? |
| 18 | PCNT1 | Change in investment share | decimal | 11 | 8 | DEC | ((0)) | Yes | | FC_PCNT1 | |
| 19 | PCNT2 | Change in voting shares | decimal | 11 | 8 | DEC | ((0)) | Yes | | FC_PCNT2 | |
| 20 | PCNT3 | Change in non-voting shares | decimal | 11 | 8 | DEC | ((0)) | Yes | | FC_PCNT3 | |
| 21 | PCNT4 | Change in share in annual net income | decimal | 11 | 8 | DEC | ((0)) | Yes | | FC_PCNT4 | |
| 22 | SVALU | Sign of book value change | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SVALU | Allow NULL? |
| 23 | BKVLC | Investment book value in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VLC_INV | |
| 24 | BKVRC | Investment book value in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VRC_INV | |
| 25 | CTYPE | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRIND | Allow NULL? |
| 26 | CRATE | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | FC_CRATE | |
| 27 | DBIND | Database value indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DBIND | Allow NULL? |
| 28 | NV2LC | Nominal book value of voting shares | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NV2LC | |
| 29 | NV3LC | Nominal book value of non-voting shares | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NV3LC | |
| 30 | NSHR2 | Number of shares with voting rights | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | FC_NSHR2 | Allow NULL? |
| 31 | NSHR3 | Number of non-voting shares | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | FC_NSHR3 | Allow NULL? |
| 32 | ORGCH | Organizational Change Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | TF820 | FC_ORGCH | Allow NULL? |
| 33 | ORGCHFLG | Organizational Change Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ORGCHFLG | Allow NULL? |
| 34 | CTLCH | Change of Control | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CTLCH | Allow NULL? |
| 35 | LCVALIE | Investment Book Value of Investee Unit in LC | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_LCVALIE | |
| 36 | LCKEYIE | Local Currency Key of Investee Unit | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_LCKEYIE | Allow NULL? |
| 37 | ACQDATE | Date of Acquisition | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FC_ACQDATE | Allow NULL? |
| 38 | GWREDFLG | Complete Reduction of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWREDFLG | Allow NULL? |
