| 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 | RVERS | Consolidation (end-result) version | nvarchar | 3 | 0 | CHAR | (N' ') | No | | FC_RVERS | Allow NULL? |
| 3 | STRVS | Version: Structures | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF202 | FC_STRVS | Allow NULL? |
| 4 | INPVS | Version for data entry | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF204 | FC_INPVS | Allow NULL? |
| 5 | CTRVS | Version: Currency translation method | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF206 | FC_CTRVS | Allow NULL? |
| 6 | CURVS | Version: Exchange rates | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF208 | FC_CURVS | Allow NULL? |
| 7 | LDRVS | Version: Ledger | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF210 | FC_LDRVS | Allow NULL? |
| 8 | FIXVS | Version: Selected FS items | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF212 | FC_FIXVS | Allow NULL? |
| 9 | TAXVS | Version: Tax rate | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF214 | FC_TAXVS | Allow NULL? |
| 10 | COIVS | Version: Consolidation of investments method | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF216 | FC_COIVS | Allow NULL? |
| 11 | INVVS | Version: Changes in investments | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF218 | FC_INVVS | Allow NULL? |
| 12 | EQUVS | Version: Changes in investee equity | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF220 | FC_EQUVS | Allow NULL? |
| 13 | GWAVS | Version: Goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF228 | FC_GWAVS | Allow NULL? |
| 14 | HIRVS | Version: Hidden reserves (fair value adjustments) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF222 | FC_HIRVS | Allow NULL? |
| 15 | RHRVS | Version: Eliminated hidden reserves (fair value adjustments) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF224 | FC_RHRVS | Allow NULL? |
| 16 | ASSVS | Version: Equity holdings adjustments | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF226 | FC_ASSVS | Allow NULL? |
| 17 | RCLVS | Version: Reclassifications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF232 | FC_RCLVS | Allow NULL? |
| 18 | IPIVS | Version: Elimination of IU profit/loss in inventory | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF234 | FC_IPIVS | Allow NULL? |
| 19 | ATRVS | Version: Attributes of Master Data | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF236 | FC_ATRVS | Allow NULL? |
| 20 | DBSVS | Base version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF200 | FC_DBSVS | Allow NULL? |
| 21 | BCFIND | Carry forward version | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_BCFIND | Allow NULL? |
| 22 | CPYRD | Enable copying of reported financial data | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CPYRD | Allow NULL? |
| 23 | CPYCE | Enable copying of standardizing/consolidation entries | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CPYCE | Allow NULL? |
| 24 | OVRRD | Enable overwriting of reported financial data | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_OVRRD | Allow NULL? |
| 25 | OVRCE | Overwriting of standardizing/consolidation entries enabled | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_OVRCE | Allow NULL? |
