| 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 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | RLDNR | Allow NULL? |
| 3 | RVERS | Version for changes in investments | nvarchar | 3 | 0 | CHAR | (N' ') | No | | RVERS_I | Allow NULL? |
| 4 | RCOMP | Investor | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_INV | Allow NULL? |
| 5 | RASSC | Investee | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_BTG | Allow NULL? |
| 6 | RYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RYEAR | Allow NULL? |
| 7 | PERID | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERIODE | Allow NULL? |
| 8 | SEQNR | Sequence number (2-digit) | nvarchar | 2 | 0 | CHAR | (N' ') | No | | LC_SEQNR2 | Allow NULL? |
| 9 | ITEM | Investment item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_BTL | Allow NULL? |
| 10 | RMVCT | Transaction type: Investments | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_INV | Allow NULL? |
| 11 | UCOMP | Company for transfer posting | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | UCOMP | Allow NULL? |
| 12 | VALDB | Indicator: Read value from database | char | 1 | 0 | CHAR | (N' ') | No | | KZVALDB | Allow NULL? |
| 13 | TXT | Description of activity | nvarchar | 30 | 0 | CHAR | (N' ') | No | | VGTXT | Allow NULL? |
| 14 | SIGN | Sign indicating changes in investment | char | 1 | 0 | CHAR | (N' ') | No | | SIGN_BTGL | Allow NULL? |
| 15 | CHAHO | Change in investment percentage | decimal | 7 | 4 | DEC | ((0)) | No | | BTGL_PRZ | |
| 16 | BKVLC | Investment book value in local currency | decimal | 15 | 2 | CURR | ((0)) | No | | VLCUR_INV | |
| 17 | EXTYP | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | No | | CUTYP | Allow NULL? |
| 18 | EXCHA | Exchange rate | nvarchar | 9 | 0 | NUMC | (N'000000000') | No | | KURSC | Allow NULL? |
| 19 | IQERT | Exchange rate entered at indirect quotation | char | 1 | 0 | CHAR | (N' ') | No | | LC_IQERT | Allow NULL? |
| 20 | BKVRC | Investment book value in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_INV | |
| 21 | PCNT1 | Change in investment share | decimal | 11 | 8 | DEC | ((0)) | No | | PCNT1 | |
| 22 | PCNT2 | Change in investment (w/voting rights) | decimal | 11 | 8 | DEC | ((0)) | No | | PCNT2 | |
| 23 | PCNT3 | Change in investment (w/o voting rights) | decimal | 11 | 8 | DEC | ((0)) | No | | PCNT3 | |
| 24 | PCNT4 | Change in investment (retained) | decimal | 11 | 8 | DEC | ((0)) | No | | PCNT4 | |
| 25 | KZ_PCNT | Indicator: Deviating shares | char | 1 | 0 | CHAR | (N' ') | No | | KC_PCNT | Allow NULL? |
| 26 | NV2LC | Par book value - voting | decimal | 15 | 2 | CURR | ((0)) | No | | NV2LC | |
| 27 | NV3LC | Par book value w/o voting rights | decimal | 15 | 2 | CURR | ((0)) | No | | NV3LC | |
| 28 | KZCON | Indicator: Control | char | 1 | 0 | CHAR | (N' ') | No | | KZCON | Allow NULL? |
| 29 | RLEVL | Posting level | char | 1 | 0 | CHAR | (N' ') | No | | RLEVL | Allow NULL? |
