| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RVERS | Consolidation (end-result) version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | STRVS | Version: Structures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | INPVS | Version for data entry | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | CTRVS | Version: Currency translation method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | CURVS | Version: Exchange rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | LDRVS | Version: Ledger | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | FIXVS | Version: Selected FS items | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | TAXVS | Version: Tax rate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | COIVS | Version: Consolidation of investments method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | INVVS | Version: Changes in investments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | EQUVS | Version: Changes in investee equity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | GWAVS | Version: Goodwill | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | HIRVS | Version: Hidden reserves (fair value adjustments) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | RHRVS | Version: Eliminated hidden reserves (fair value adjustments) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | ASSVS | Version: Equity holdings adjustments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | RCLVS | Version: Reclassifications | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | IPIVS | Version: Elimination of IU profit/loss in inventory | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | ATRVS | Version: Attributes of Master Data | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | DBSVS | Base version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | BCFIND | Carry forward version | char | 1 | 0 | | | | Allow NULL? |
| 22 | CPYRD | Enable copying of reported financial data | char | 1 | 0 | | | | Allow NULL? |
| 23 | CPYCE | Enable copying of standardizing/consolidation entries | char | 1 | 0 | | | | Allow NULL? |
| 24 | OVRRD | Enable overwriting of reported financial data | char | 1 | 0 | | | | Allow NULL? |
| 25 | OVRCE | Overwriting of standardizing/consolidation entries enabled | char | 1 | 0 | | | | Allow NULL? |