| 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 | COIMETH | Method | nvarchar | 5 | 0 | CHAR | (N' ') | No | TF550 | FC_CMETH | Allow NULL? |
| 4 | COITP | Accounting technique for the consolidation of investments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_COITP | Allow NULL? |
| 5 | USGAAP | Calculate acquisitions with direct shares/group shares | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_USGAAP | Allow NULL? |
| 6 | GWPROC | Treatment of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWPROC | Allow NULL? |
| 7 | NGPROC | Treatment of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGPROC | Allow NULL? |
| 8 | GWLCFLG | Carry Goodwill in Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWLCFLG | Allow NULL? |
| 9 | GWIEFLG | Post Goodwill at Investee Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWIEFLG | Allow NULL? |
| 10 | HIREXC | Exception for fair value adjustments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HIREXC | Allow NULL? |
| 11 | GWNEXC | Exception Goodwill Extraordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWNEXC | Allow NULL? |
| 12 | GWAEXC | Exception Goodwill Ordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWAEXC | Allow NULL? |
| 13 | GWDEXC | Exception for direct elimination of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWDEXC | Allow NULL? |
| 14 | GWREXC | Exception for periodic reduction of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWREXC | Allow NULL? |
| 15 | NGNEXC | Exception Negative Goodwill Extraordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGNEXC | Allow NULL? |
| 16 | NGAEXC | Exception Negative Goodwill Ordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGAEXC | Allow NULL? |
| 17 | NGDEXC | Exception for direct elimination of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGDEXC | Allow NULL? |
| 18 | NGREXC | Exception for periodic reduction of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGREXC | Allow NULL? |
| 19 | NEQEXC | Exception for Negative Stockholders' Equity | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NEQEXC | Allow NULL? |
| 20 | NINVFLG | Enable negative investments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NINVFLG | Allow NULL? |
| 21 | NMINFLG | No calculation of minority interest | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NMINFLG | Allow NULL? |
| 22 | HRREV | Procedure for eliminating hidden reserves/contingencies(FVA) | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRREV | Allow NULL? |
| 23 | HRSHA | Scope of elimination of hidden reserves/contingencies | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRSHA | Allow NULL? |
| 24 | HRSITYP | Subitem category for hidden reserves (fair value adjustment) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_HRSITYP | Allow NULL? |
| 25 | HRAQDSI | Subitem for transferring hidden reserves (fair value adj.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRAQDSI | Allow NULL? |
| 26 | HRDPCSI | Subitem for amortization of hidden reserves (fair value adj) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRDPCSI | Allow NULL? |
| 27 | HRDPDSI | Subitem for writeups of hidden reserves (fair value adj.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_HRDPDSI | Allow NULL? |
| 28 | NHSITYP | Subitem category for hidden contingencies (fair value adj.) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NHSITYP | Allow NULL? |
| 29 | NHAQCSI | Subitem for transferring hidden contingencies (fair val.adj) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHAQCSI | Allow NULL? |
| 30 | NHDPDSI | Subitem for changes to hidden contingencies - debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHDPDSI | Allow NULL? |
| 31 | NHDPCSI | Subitem for changes to hidden contingencies - credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NHDPCSI | Allow NULL? |
| 32 | GWAYR | Life of goodwill amortization in years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_GWAYR | Allow NULL? |
| 33 | GWAPE | Life of goodwill amortization in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_GWAPE | Allow NULL? |
| 34 | GWABG | Start date for the amortization of new goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWABG | Allow NULL? |
| 35 | GWARFLG | Amortize new goodwill over remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWARFLG | Allow NULL? |
| 36 | GWALFLG | Threshold value for the amortization of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWALFLG | Allow NULL? |
| 37 | GWALVAL | Threshold value for the amortization of goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_GWALVAL | |
| 38 | GWALCUR | Group currency for threshold for goodwill amortization | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_GWALCUR | Allow NULL? |
| 39 | GWAMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 40 | GWRYR | Life of the periodic reduction of goodwill - years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_GWRYR | Allow NULL? |
| 41 | GWRPE | Life of periodic reduction of goodwill - months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_GWRPE | Allow NULL? |
| 42 | GWRBG | Beginning date of the periodic reduction of new goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRBG | Allow NULL? |
| 43 | GWRRFLG | Reduce the new goodwill over its remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRRFLG | Allow NULL? |
| 44 | GWRLFLG | Threshold value for the periodic reduction of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRLFLG | Allow NULL? |
| 45 | GWRLVAL | Threshold value for the periodic reduction of goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_GWRLVAL | |
| 46 | GWRLCUR | Group currency for threshold for periodic reduction of GW | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_GWRLCUR | Allow NULL? |
| 47 | GWRMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 48 | NGAYR | Life of amortization of negative goodwill in years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_NGAYR | Allow NULL? |
| 49 | NGAPE | Life of amortization of negative goodwill in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_NGAPE | Allow NULL? |
| 50 | NGABG | Beginning date of amortization of new negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGABG | Allow NULL? |
| 51 | NGARFLG | Amortization of new negative goodwill over remain. life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGARFLG | Allow NULL? |
| 52 | NGALFLG | Threshold for amortization of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGALFLG | Allow NULL? |
| 53 | NGALVAL | Threshold for amortization of negative goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NGALVAL | |
| 54 | NGALCUR | Group currency f. threshold of neg. goodwill amortization | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_NGALCUR | Allow NULL? |
| 55 | NGAMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
| 56 | NGRYR | Life of periodic reduction of negative goodwill - years | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_NGRYR | Allow NULL? |
| 57 | NGRPE | Life of periodic reduction of negative goodwill - months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FC_NGRPE | Allow NULL? |
| 58 | NGRBG | Beginning date of the reduction of new negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRBG | Allow NULL? |
| 59 | NGRRFLG | Reduce new negative goodwill over its remaining life | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRRFLG | Allow NULL? |
| 60 | NGRLFLG | Threshold for periodic reduction of negative goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRLFLG | Allow NULL? |
| 61 | NGRLVAL | Threshold for periodic reduction of negative goodwill | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_NGRLVAL | |
| 62 | NGRLCUR | Group currency of threshold for periodic reduction of neg.GW | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FC_NGRLCUR | Allow NULL? |
| 63 | NGRMETH | Amortization method | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_DEPMETH | Allow NULL? |
