| 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 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | FC_RLDNR | Allow NULL? |
| 4 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 5 | HIRVS | Version: Hidden reserves (fair value adjustments) | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF222 | FC_HIRVS | Allow NULL? |
| 6 | COICU | Investee unit | nvarchar | 18 | 0 | CHAR | (N' ') | No | TF160 | FC_COICU | Allow NULL? |
| 7 | RYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | FC_RYEAR | Allow NULL? |
| 8 | PERID | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FC_PERID | Allow NULL? |
| 9 | HRES1 | Fair value adjustment: main number | nvarchar | 12 | 0 | CHAR | (N' ') | No | TF640 | FC_HRES1 | Allow NULL? |
| 10 | HRES2 | Fair value adjustment: Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | No | TF641 | FC_HRES2 | Allow NULL? |
| 11 | VLCPP | Original FVA in prior periods in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCPP | |
| 12 | VRCPP | Orig. FVA in prior periods in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCPP | |
| 13 | VLCBG | Opening book value of fair adjustments in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCBG | |
| 14 | VRCBG | Opening book value of fair value adjustments in group crcy | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCBG | |
| 15 | VLCAP | Fair value increase in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCAP | |
| 16 | VRCAP | Fair value increase in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCAP | |
| 17 | CTYAP | Exchange rate indicator for fair value adjustment increases | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRINDAP | Allow NULL? |
| 18 | CRAAP | Exchange rate for fair value increases | decimal | 9 | 5 | DEC | ((0)) | Yes | | FC_CRATEAP | |
| 19 | ACQEN | Increase fair value adjustment at the end of the period | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRACQEN | Allow NULL? |
| 20 | VLCDA | Fair value decrease in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCDA | |
| 21 | VRCDA | Fair value decrease in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCDA | |
| 22 | CTYDA | Exchange rate indicator for fair value decreases | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRINDDA | Allow NULL? |
| 23 | CRADA | Exchange rate for fair value decreases | decimal | 9 | 5 | DEC | ((0)) | Yes | | FC_CRATEDA | |
| 24 | DIVBG | Decrease fair value adjustment at beginning of period | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HRDIVBG | Allow NULL? |
| 25 | VLCDN | Amortization of fair value adjustments in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCDN | |
| 26 | VRCDN | Amortization of fair value adjustments in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCDN | |
| 27 | VLCDE | Extraordinary amortization of FVA in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCDE | |
| 28 | VRCDE | Extraordinary amortization of FVA in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCDE | |
| 29 | CTYDE | Exchange rate indicator for extraordinary amortization | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRINDDE | Allow NULL? |
| 30 | CRADE | Exchange rate for extraordinary amortization | decimal | 9 | 5 | DEC | ((0)) | Yes | | FC_CRATEDE | |
| 31 | VLCWU | Writeup of fair value adjustments in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCWU | |
| 32 | VRCWU | Writeup of fair value adjustments in group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCWU | |
| 33 | CTYWU | Exchange rate indicator for writeups | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRINDWU | Allow NULL? |
| 34 | CRAWU | Exchange rate for writeups | decimal | 9 | 5 | DEC | ((0)) | Yes | | FC_CRATEWU | |
| 35 | VLCDD | Adj. to accum. amortization from decrease of FVA in LC | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCDD | |
| 36 | VRCDD | Adj. to accum. amort. from decrease in FVA - group currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCDD | |
| 37 | VLCEN | Closing book value of fair value adjustments in local crcy | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVLCEN | |
| 38 | VRCEN | Closing book value of fair value adjustments in group crcy | decimal | 17 | 2 | CURR | ((0)) | Yes | | FC_HRVRCEN | |
