| 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 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 4 | COIMETH | Method | nvarchar | 5 | 0 | CHAR | (N' ') | No | TF600 | FC_CMETH | Allow NULL? |
| 5 | GWAAQDI | Item for the acquisition cost of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAAQDI | Allow NULL? |
| 6 | GWAAQDT | Subitem category for the acquisition cost of goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAAQDT | Allow NULL? |
| 7 | GWAAQDS | Subitem for the acquisition cost of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAQDS | Allow NULL? |
| 8 | GWAAQCTPYS | Subitem Goodwill Amortization CTD Orig.Cost, Opening Balance | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAQCTPYS | Allow NULL? |
| 9 | GWAAQCTCYS | Subitem Goodwill Amortization CTD Orig.Cost, Current Year | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAQCTCYS | Allow NULL? |
| 10 | GWAOFFSDI | Offsetting Item, Goodwill Amortization, Acquisition Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAOFFSDI | Allow NULL? |
| 11 | GWAOFFSDT | Subitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Cost | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAOFFSDT | Allow NULL? |
| 12 | GWAOFFSDS | Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAOFFSDS | Allow NULL? |
| 13 | GWAOFFSCS | Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAOFFSCS | Allow NULL? |
| 14 | GWAAQCI | Item for the accumulated amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAAQCI | Allow NULL? |
| 15 | GWAAQCT | Subitem category for accumulated amortization of goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAAQCT | Allow NULL? |
| 16 | GWADPCS | Subitem for the amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWADPCS | Allow NULL? |
| 17 | GWADPDS | Subitem for writeups of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWADPDS | Allow NULL? |
| 18 | GWADPCTPYS | Subitem Goodwill Amortization CTD Val.Allow., Opening Bal. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWADPCTPYS | Allow NULL? |
| 19 | GWADPCTCYS | Subitem Goodwill Amortization CTD Val.Allow., Current Year | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWADPCTCYS | Allow NULL? |
| 20 | GWAAMDI | Item for the amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAAMDI | Allow NULL? |
| 21 | GWAAMDT | Subitem category for the amortization of goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAAMDT | Allow NULL? |
| 22 | GWAAMDS | Subitem for the amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAMDS | Allow NULL? |
| 23 | GWAAMCI | Item for goodwill writeups | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAAMCI | Allow NULL? |
| 24 | GWAAMCT | Subitem category for goodwill writeups | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAAMCT | Allow NULL? |
| 25 | GWAAMCS | Subitem for writeups of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAMCS | Allow NULL? |
| 26 | GWASTAT | Item for Goodwill Val.Allowances: Amortization, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWASTAT | Allow NULL? |
| 27 | GWASTATCT | Item Goodwill Amortization CTD, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWASTATCT | Allow NULL? |
| 28 | GWASTATOFFS | Offsetting Item, Goodwill Amortization, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWASTATOFFS | Allow NULL? |
| 29 | GWRAQDI | Bal.sheet item: periodic reduction of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWRAQDI | Allow NULL? |
| 30 | GWRAQDT | Subitem category for B/S item for periodic reduction of GW | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWRAQDT | Allow NULL? |
| 31 | GWRAQDS | Subitem for periodic reduction of goodwill - acquisition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWRAQDS | Allow NULL? |
| 32 | GWRAQCS | Subitem for periodic reduction of goodwill - divestiture | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWRAQCS | Allow NULL? |
| 33 | GWROFFSDI | Offset.Item: Goodwill Periodic Reduction, Acquisition Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWROFFSDI | Allow NULL? |
| 34 | GWROFFSDT | Subitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APC | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWROFFSDT | Allow NULL? |
| 35 | GWROFFSDS | Subitem: Offset.Entry, Goodwill Periodic Reduction, Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWROFFSDS | Allow NULL? |
| 36 | GWROFFSCS | Subitem: Offset.Entry, Goodwill Periodic Reduction, Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWROFFSCS | Allow NULL? |
| 37 | GWRAMDI | Item for periodic reduction of goodwill: debits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWRAMDI | Allow NULL? |
| 38 | GWRAMDT | Subitem category for periodic reduction of goodwill: debits | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWRAMDT | Allow NULL? |
| 39 | GWRAMDS | Subitem for periodic reduction of goodwill: debits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWRAMDS | Allow NULL? |
| 40 | GWRAMCI | Item for periodic reduction of goodwill: credits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWRAMCI | Allow NULL? |
| 41 | GWRAMCT | Subitem category for periodic reduction of goodwill: credits | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWRAMCT | Allow NULL? |
| 42 | GWRAMCS | Subitem for periodic reduction of goodwill: credits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWRAMCS | Allow NULL? |
| 43 | GWRSTAT | Item for Goodwill Val.Allow.: Periodic Reduction, Stat. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWRSTAT | Allow NULL? |
| 44 | GWRSTATOFFS | Offsetting Item: Goodwill Periodic Reduction, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWRSTATOFFS | Allow NULL? |
| 45 | GWDAQDI | Item for the direct elimination of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWDAQDI | Allow NULL? |
| 46 | GWDAQDT | Subitem category for the direct elimination of goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWDAQDT | Allow NULL? |
| 47 | GWDAQDS | Subitem for the direct elimination of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWDAQDS | Allow NULL? |
| 48 | GWDOFFSDI | Offset.Item, Goodwill Direct Elimination, Acquisition Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWDOFFSDI | Allow NULL? |
| 49 | GWDOFFSDT | Subitem Cat.: Offset.Entry, Goodwill Direct Elimination, APC | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWDOFFSDT | Allow NULL? |
| 50 | GWDOFFSDS | Subitem: Offset.Entry, Goodwill Direct Elimination, Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWDOFFSDS | Allow NULL? |
| 51 | GWDOFFSCS | Subitem: Offset.Entry, Goodwill Direct Elimination, Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWDOFFSCS | Allow NULL? |
| 52 | GWDSTAT | Item for Goodwill Val.Allow.: Direct Elimination, Stat. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWDSTAT | Allow NULL? |
| 53 | GWDSTATOFFS | Offsetting Item: Goodwill Direct Elimination, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWDSTATOFFS | Allow NULL? |
| 54 | NGAAQDI | Item for acquisition cost of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAAQDI | Allow NULL? |
| 55 | NGAAQDT | Subitem category for acquisition cost of negative goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAAQDT | Allow NULL? |
| 56 | NGAAQDS | Subitem for acquisition cost of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAQDS | Allow NULL? |
| 57 | NGAAMCTPYS | Subitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balance | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAMCTPYS | Allow NULL? |
| 58 | NGAAMCTCYS | Subitem: Neg. Goodwill Amort., C/T Diff. OC Current Year | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAMCTCYS | Allow NULL? |
| 59 | NGAOFFSDI | Offsetting Item: Negative Goodwill Amortization, Acq.Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAOFFSDI | Allow NULL? |
| 60 | NGAOFFSDT | Subitem Categ.: Offset.Entry, Negative Goodwill Amort. APC | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAOFFSDT | Allow NULL? |
| 61 | NGAOFFSDS | Subitem: Offset.Entry, Negative Goodwill Amort. APC, Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAOFFSDS | Allow NULL? |
| 62 | NGAOFFSCS | Subitem: Offset.Entry, Negative Goodwill Amort. APC, Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAOFFSCS | Allow NULL? |
| 63 | NGAAQCI | Item for accumulated amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAAQCI | Allow NULL? |
| 64 | NGAAQCT | Subitem category for accum.amortization of negative goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAAQCT | Allow NULL? |
| 65 | NGADPCS | Subitem for the amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGADPCS | Allow NULL? |
| 66 | NGADPDS | Subitem for writeups of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGADPDS | Allow NULL? |
| 67 | NGADPCTPYS | Subitem: Neg. Goodwill Amort., CTD Val.All., Opening Balance | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGADPCTPYS | Allow NULL? |
| 68 | NGADPCTCYS | Subitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Year | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGADPCTCYS | Allow NULL? |
| 69 | NGAAMDI | Item for the amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAAMDI | Allow NULL? |
| 70 | NGAAMDT | Subitem category for amortization of negative goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAAMDT | Allow NULL? |
| 71 | NGAAMDS | Subitem for the amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAMDS | Allow NULL? |
| 72 | NGAAMCI | Item for writeups of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAAMCI | Allow NULL? |
| 73 | NGAAMCT | Subitem category for goodwill writeups | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAAMCT | Allow NULL? |
| 74 | NGAAMCS | Subitem for writeups of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAMCS | Allow NULL? |
| 75 | NGASTAT | Item for Neg.Goodwill Val.Allow.: Amortization, Stat. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGASTAT | Allow NULL? |
| 76 | NGASTATCT | Item: Negative Goodwill Amortization, C/T Diff, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGASTATCT | Allow NULL? |
| 77 | NGASTATOFFS | Offsetting Item: Negative Goodwill Amortization, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGASTATOFFS | Allow NULL? |
| 78 | NGRAQDI | B/S item for periodic reduction of negative GW | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGRAQDI | Allow NULL? |
| 79 | NGRAQDT | Subitem cat. for B/S item for periodic reduction of neg. GW | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGRAQDT | Allow NULL? |
| 80 | NGRAQDS | Subitem for periodic reduction of negative GW: acquisitions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGRAQDS | Allow NULL? |
| 81 | NGRAQCS | Subitem for periodic reduction of negative GW: divestiture | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGRAQCS | Allow NULL? |
| 82 | NGROFFSDI | Offsetting Item: Neg.Goodwill Periodic Reduction, Acq.Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGROFFSDI | Allow NULL? |
| 83 | NGROFFSDT | SI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APC | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGROFFSDT | Allow NULL? |
| 84 | NGROFFSDS | Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGROFFSDS | Allow NULL? |
| 85 | NGROFFSCS | Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGROFFSCS | Allow NULL? |
| 86 | NGRAMDI | Item for periodic reduction of negative GW: debits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGRAMDI | Allow NULL? |
| 87 | NGRAMDT | Subitem cat. for periodic reduction of negative GW: debits | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGRAMDT | Allow NULL? |
| 88 | NGRAMDS | Subitem for periodic reduction of negative goodwill: debits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGRAMDS | Allow NULL? |
| 89 | NGRAMCI | Item for periodic reduction of negative goodwill: credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGRAMCI | Allow NULL? |
| 90 | NGRAMCT | Subitem cat. for periodic reduction of negative GW: credits | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGRAMCT | Allow NULL? |
| 91 | NGRAMCS | Subitem for periodic reduction of negative goodwill: credits | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGRAMCS | Allow NULL? |
| 92 | NGRSTAT | Item for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGRSTAT | Allow NULL? |
| 93 | NGRSTATOFFS | Offset.Item: Neg.Goodwill Periodic Reduction, Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGRSTATOFFS | Allow NULL? |
| 94 | NGDAQCI | Item for direct elimination of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGDAQCI | Allow NULL? |
| 95 | NGDAQCT | Subitem category for direct elimination of negative goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGDAQCT | Allow NULL? |
| 96 | NGDAQCS | Subitem for the direct elimination of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGDAQCS | Allow NULL? |
| 97 | NGDOFFSDI | Offsetting Item: Neg.Goodwill Direct Elimination, Acq.Cost | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGDOFFSDI | Allow NULL? |
| 98 | NGDOFFSDT | Subitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APC | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGDOFFSDT | Allow NULL? |
| 99 | NGDOFFSDS | Subitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGDOFFSDS | Allow NULL? |
| 100 | NGDOFFSCS | Subitem: Offset.Entry, Neg.Goodwill Direct Elim., Credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGDOFFSCS | Allow NULL? |
| 101 | NGDSTAT | Item for Neg.Goodwill Val.Allow.: Direct Elimination, Stat. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGDSTAT | Allow NULL? |
| 102 | NGDSTATOFFS | Offsetting Item: Neg.Goodwill Direct Elim., Statistical | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGDSTATOFFS | Allow NULL? |
