| 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 | RVERS | Consolidation (end-result) version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF200 | FC_RVERS | Allow NULL? |
| 5 | CONGR | Consolidation group | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF180 | FC_CONGR | Allow NULL? |
| 6 | COICU | Investee unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_COICU | Allow NULL? |
| 7 | CYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_RYEAR | Allow NULL? |
| 8 | CPERI | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_PERID | Allow NULL? |
| 9 | BUNIT | Consolidation unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_BUNIT | Allow NULL? |
| 10 | BUPTR | Partner unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_BUPTR | Allow NULL? |
| 11 | HRES1 | Fair value adjustment: main number | nvarchar | 12 | 0 | CHAR | (N' ') | No | TF640 | FC_HRES1 | Allow NULL? |
| 12 | HRES2 | Fair value adjustment: Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | No | TF641 | FC_HRES2 | Allow NULL? |
| 13 | COIAC | Activity for consolidation of investments | nvarchar | 2 | 0 | CHAR | (N' ') | No | | FC_COIAC | Allow NULL? |
| 14 | COINR | Consolidation of investments activity number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | FC_COINR | Allow NULL? |
| 15 | AYEAR | Year of incurrence of the amount to be amortized/depreciated | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_AYEAR | Allow NULL? |
| 16 | APERI | Period of incurrence of the amount to be amortized/depr'd | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_APERI | Allow NULL? |
| 17 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FC_RLDNR | Allow NULL? |
| 18 | VGRAP | Gross book value of acquisition of fair value adjustment | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVGRAP | |
| 19 | VALAP | Original Book Value (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALAP | |
| 20 | VALDP | Acc.Adjustment of Orig.Cost for Divest. in Pr.Periods (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALDP | |
| 21 | VALBG | Beginning Book Value (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALBG | |
| 22 | VALDN | Amortization Amount, Ordinary (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALDN | |
| 23 | VALDE | Amortization Amount, Extraordinary (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALDE | |
| 24 | VALWU | Writeup (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALWU | |
| 25 | VALDA | Acc. Adjustment of Orig.Cost for Divest. in Curr.Period(GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALDA | |
| 26 | VALDD | Accumulated Amortization for Divestiture in Curr.Period(GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALDD | |
| 27 | VALEN | Ending Book Value (GC) | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_VALEN | |
