| 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 | COILV | Calculation base for the consolidation of investments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_COILV | Allow NULL? |
| 4 | INVVAL | Location of investment holdings values | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_INVVAL | Allow NULL? |
| 5 | EQUVAL | Location of equity data | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_EQUVAL | Allow NULL? |
| 6 | EQIVAL | Location of data for subsequent equity consolidation | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_EQIVAL | Allow NULL? |
| 7 | ESHFLG | Net display of equity aging report | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ESHFLG | Allow NULL? |
| 8 | ESHSIT | Subitem category for investee equity | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_ESHSIT | Allow NULL? |
| 9 | ESHMDS | Debits subitem for minority interest | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_ESHMDS | Allow NULL? |
| 10 | ESHMCS | Credits subitem for minority interest | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_ESHMCS | Allow NULL? |
| 11 | NIPDFLG | Affect net income when posting partial divestitures | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NIPDFLG | Allow NULL? |
| 12 | NIIDFLG | Affect net income when reducing indirect investments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NIIDFLG | Allow NULL? |
| 13 | ASSDT | Doc. type assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ASSDT | Allow NULL? |
| 14 | PUACHK | Validation of Push-down Goodwill | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_PUACHK | Allow NULL? |
| 15 | XRINDGWBS | Goodwill in Local Crcy: Exchange Rate Ind., Balance Sheet | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_XRINDGWBS | Allow NULL? |
| 16 | XRINDGWIS | Goodwill in Local Crcy: Exchange Rate Ind., Income Statement | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_XRINDGWIS | Allow NULL? |
| 17 | CTKEYGWIS | Goodwill in Local Crcy: Currency Trl. Key, Income Statement | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CTKEYGWIS | Allow NULL? |
| 18 | GWTBEGFLG | Currency Translation for Goodwill at Beginning of Period | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWTBEGFLG | Allow NULL? |
| 19 | GWPROCDA | Treatment of Goodwill in Increases in Direct Investment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWPROCDA | Allow NULL? |
| 20 | GWPROCIA | Treatment of Goodwill in Increases in Indirect Investment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWPROCIA | Allow NULL? |
| 21 | NGPROCDA | Neg.GW Treatment in Incr.in Direct Invest.(exc. First Cons) | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGPROCDA | Allow NULL? |
| 22 | NGPROCIA | Neg.GW Treatment in Increase in Indirect Investment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGPROCIA | Allow NULL? |
| 23 | LDTYR | Fiscal Year of Legacy Data Transfer | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FC_LDTYR | Allow NULL? |
| 24 | LDTPE | Period of Legacy Data Transfer | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_LDTPE | Allow NULL? |
| 25 | NINVFLG | Enable negative investments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NINVFLG | Allow NULL? |
| 26 | NMINFLG | No calculation of minority interest | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NMINFLG | Allow NULL? |
| 27 | HRREV | Procedure for eliminating hidden reserves/contingencies(FVA) | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRREV | Allow NULL? |
| 28 | HRSHA | Scope of elimination of hidden reserves/contingencies | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRSHA | Allow NULL? |
| 29 | HRSITYP | Subitem category for hidden reserves (fair value adjustment) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_HRSITYP | Allow NULL? |
| 30 | HRAQDSI | Subitem for transferring hidden reserves (fair value adj.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRAQDSI | Allow NULL? |
| 31 | HRDPCSI | Subitem for amortization of hidden reserves (fair value adj) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRDPCSI | Allow NULL? |
| 32 | HRDPDSI | Subitem for writeups of hidden reserves (fair value adj.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRDPDSI | Allow NULL? |
| 33 | NHSITYP | Subitem category for hidden contingencies (fair value adj.) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NHSITYP | Allow NULL? |
| 34 | NHAQCSI | Subitem for transferring hidden contingencies (fair val.adj) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHAQCSI | Allow NULL? |
| 35 | NHDPDSI | Subitem for changes to hidden contingencies - debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHDPDSI | Allow NULL? |
| 36 | NHDPCSI | Subitem for changes to hidden contingencies - credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHDPCSI | Allow NULL? |
| 37 | GWAYR | Life of goodwill amortization in years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_GWAYR | Allow NULL? |
| 38 | GWAPE | Life of goodwill amortization in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_GWAPE | Allow NULL? |
| 39 | GWABG | Start date for the amortization of new goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWABG | Allow NULL? |
| 40 | GWARFLG | Amortize new goodwill over remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWARFLG | Allow NULL? |
| 41 | GWALFLG | Threshold value for the amortization of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWALFLG | Allow NULL? |
| 42 | GWALVAL | Threshold value for the amortization of goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_GWALVAL | |
| 43 | GWALCUR | Group currency for threshold for goodwill amortization | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_GWALCUR | Allow NULL? |
| 44 | GWAMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 45 | GWRYR | Life of the periodic reduction of goodwill - years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_GWRYR | Allow NULL? |
| 46 | GWRPE | Life of periodic reduction of goodwill - months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_GWRPE | Allow NULL? |
| 47 | GWRBG | Beginning date of the periodic reduction of new goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRBG | Allow NULL? |
| 48 | GWRRFLG | Reduce the new goodwill over its remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRRFLG | Allow NULL? |
| 49 | GWRLFLG | Threshold value for the periodic reduction of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRLFLG | Allow NULL? |
| 50 | GWRLVAL | Threshold value for the periodic reduction of goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_GWRLVAL | |
| 51 | GWRLCUR | Group currency for threshold for periodic reduction of GW | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_GWRLCUR | Allow NULL? |
| 52 | GWRMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 53 | NGAYR | Life of amortization of negative goodwill in years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_NGAYR | Allow NULL? |
| 54 | NGAPE | Life of amortization of negative goodwill in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_NGAPE | Allow NULL? |
| 55 | NGABG | Beginning date of amortization of new negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGABG | Allow NULL? |
| 56 | NGARFLG | Amortization of new negative goodwill over remain. life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGARFLG | Allow NULL? |
| 57 | NGALFLG | Threshold for amortization of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGALFLG | Allow NULL? |
| 58 | NGALVAL | Threshold for amortization of negative goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NGALVAL | |
| 59 | NGALCUR | Group currency f. threshold of neg. goodwill amortization | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_NGALCUR | Allow NULL? |
| 60 | NGAMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 61 | NGRYR | Life of periodic reduction of negative goodwill - years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_NGRYR | Allow NULL? |
| 62 | NGRPE | Life of periodic reduction of negative goodwill - months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_NGRPE | Allow NULL? |
| 63 | NGRBG | Beginning date of the reduction of new negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRBG | Allow NULL? |
| 64 | NGRRFLG | Reduce new negative goodwill over its remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRRFLG | Allow NULL? |
| 65 | NGRLFLG | Threshold for periodic reduction of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRLFLG | Allow NULL? |
| 66 | NGRLVAL | Threshold for periodic reduction of negative goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NGRLVAL | |
| 67 | NGRLCUR | Group currency of threshold for periodic reduction of neg.GW | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_NGRLCUR | Allow NULL? |
| 68 | NGRMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
