| 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 | METH | Consolidation method | nvarchar | 5 | 0 | CHAR | (N' ') | No | | METH | Allow NULL? |
| 3 | TYPE | Consolidation of investments method | char | 1 | 0 | CHAR | (N' ') | No | | KK_TYPE | Allow NULL? |
| 4 | VARI | Valuation basis | char | 1 | 0 | CHAR | (N' ') | No | | KK_VARI | Allow NULL? |
| 5 | DEPLG | Goodwill amortization: Duration in years | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DEPLG | Allow NULL? |
| 6 | PERID | Goodwill amortization: Duration in months | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DEPLG_PERI | Allow NULL? |
| 7 | FDEP | Amortization of new goodwill over remaining life | char | 1 | 0 | CHAR | (N' ') | No | | DEP_NGW | Allow NULL? |
| 8 | DITC | Differential: Debit item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DD | Allow NULL? |
| 9 | DITD | Differential: Credit item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DC | Allow NULL? |
| 10 | MVT1C | Transaction type: Investments on credits side | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_INVC | Allow NULL? |
| 11 | MVT1D | Transaction type: Investments on debits side | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_INVD | Allow NULL? |
| 12 | MVT2C | Transaction type: Equity on credits side | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_EQC | Allow NULL? |
| 13 | MVT2D | Transaction type: Equity on debits side | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_EQD | Allow NULL? |
| 14 | MVT3C | Transaction type: Debit difference | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_GWD | Allow NULL? |
| 15 | MVT3D | Transaction type: Credit difference | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_BWC | Allow NULL? |
| 16 | MVT4C | Transaction type: Amortization | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_DCPC | Allow NULL? |
| 17 | MVT4D | Transaction type: Write-ups | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | RMVCT_DCPD | Allow NULL? |
| 18 | DEPC | Amortization item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DCPG | Allow NULL? |
| 19 | DEPD | Write-up item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DCPB | Allow NULL? |
| 20 | RLEVL | Posting level for inclusion in consolidation of investments | char | 1 | 0 | CHAR | (N' ') | No | | RLEVL_KK | Allow NULL? |
| 21 | EQNEG | Indicator: negative NBV of investment | char | 1 | 0 | CHAR | (N' ') | No | | KZ_EQNEG | Allow NULL? |
| 22 | NOGVW | Indicator: No posting to appropriation of retained earnings | char | 1 | 0 | CHAR | (N' ') | No | | KZ_NOGVW | Allow NULL? |
| 23 | URES | Reverse hidden reserves (fair value adjustments) | char | 1 | 0 | NUMC | (N'0') | No | | HDRES | Allow NULL? |
| 24 | RDEPRT | Depreciation method | char | 1 | 0 | CHAR | (N' ') | No | | DEPRT | Allow NULL? |
| 25 | BGWAM | Start of goodwill amortization with step acquisition | char | 1 | 0 | CHAR | (N' ') | No | | BGWAM | Allow NULL? |
| 26 | SETIN | Set ID for investment items | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SETNR_INV | Allow NULL? |
| 27 | SETEQ | Equity: FS item set for subsequent consolidation | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SETNR_EQ | Allow NULL? |
| 28 | ASORT | Seqiemce of consolidation of investments activities | nvarchar | 7 | 0 | CHAR | (N' ') | No | | EQ_ORDER | Allow NULL? |
| 29 | GWAMT | Financial statement item for amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DPGW | Allow NULL? |
| 30 | ACTIVE | Method is activated | char | 1 | 0 | CHAR | (N' ') | No | | KAP_PRF | Allow NULL? |
| 31 | CHECKED | Check indicator | char | 1 | 0 | CHAR | (N' ') | No | | UMR_PRF | Allow NULL? |
| 32 | DAT_CHECK | Creation date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CRDAT | Allow NULL? |
| 33 | USER_CHECK | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CRNAM | Allow NULL? |
| 34 | MVT5A | TTy: Acquisition of hidden reserves/debts | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | MVT5A | Allow NULL? |
| 35 | MVT5B | Transaction type: Amortization of hidden reserves/debts | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | MVT5B | Allow NULL? |
| 36 | MVT5C | Transaction type: Write-up of hidden reserves/debts | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | MVT5C | Allow NULL? |
| 37 | GWB | Handling of goodwill | char | 1 | 0 | CHAR | (N' ') | No | | GWB | Allow NULL? |
| 38 | SETEQ2 | Equity: FS item set for first consolidation | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SETNR_EQ2 | Allow NULL? |
| 39 | MSETEQ1 | Equity: Transaction type set for subsequent consolidation | nvarchar | 12 | 0 | CHAR | (N' ') | No | | MVTSET_EQ1 | Allow NULL? |
| 40 | MSETEQ2 | Equity: Transaction type set for first consolidation | nvarchar | 12 | 0 | CHAR | (N' ') | No | | MVTSET_EQ2 | Allow NULL? |
| 41 | VALDB | Indicator: Always read values from database | char | 1 | 0 | CHAR | (N' ') | No | | KZVALDBO | Allow NULL? |
| 42 | MVT6A | Transaction type: Proporational elimination | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | MVT6A | Allow NULL? |
| 43 | NGAFLG | Ind.: Amortization of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | NGAFLG | Allow NULL? |
| 44 | SETEQI1 | Set of earnings items | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR_EQI1 | Allow NULL? |
| 45 | SETEQI2 | Set of items for distribution of dividends | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR_EQI2 | Allow NULL? |
| 46 | SETEQI3 | Set of items for translation differences | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR_EQI3 | Allow NULL? |
