SAP VZBAVV Variable BAV Master Data Table
Overview
VZBAVV is a standard SAP S/4HANA table that stores Variable BAV Master Data data. There are total 27 fields in the VZBAVV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZBAVV belongs to Treasury (TR) module and is located in the package Objects for System AL0 (Stable Detached Objects) (VVSRG_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link VZBAVV to other SAP tables and standard CDS views available based on VZBAVV table in S/4HANA 2020.
Techincal Settings of VZBAVV
Below are technical details of the table VZBAVV
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of VZBAVV Fields
The following table gives you an overview of the fields available in VZBAVV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| VVKEY | DARWIN universal key (no client) | VVKEY | VZBAVF | CHAR | 34 |
| DGUEL_AB | Entry effective from | DGUEL_AB | DATS | 8 | |
| SUDEC | Insurance Line of Business Indicator | SUDEC | TW05 | NUMC | 2 |
| SSKZB | BAV stock indicator | SSKZB | TZ11 | NUMC | 1 |
| SDVNR | Key for BAV List in TZBAV | SDVNR | TW09B | CHAR | 4 |
| SUABNDV | *** Internal usage *** | SUABNDV | TW10B | NUMC | 2 |
| SOEFFKL | Indicator BAV opening clause | SOEFFKL | CHAR | 1 | |
| RINUM | BAV identification number | RINUM | CHAR | 22 | |
| SSKZF | Tax office stock indicator | SSKZF | TZ13 | NUMC | 1 |
| RINUMH | BAV hist. identifications number | RINUMH | CHAR | 30 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DAEND | Changed on | DAEND | DATS | 8 | |
| TAEND | Time changed | TAEND | TIMS | 6 | |
| SANLART | BAV asset type PRF3 and PRF8 | VVSANLART | TZ19 | CHAR | 6 |
| BARWBAV | BAV accepted value | BARWBAV | CURR | 13 | |
| SAWHR | Currency of accepted value_FISO | SAWHR | TCURC | CUKY | 5 |
| BVWERT | Current market value_BAV | BVWERT | CURR | 13 | |
| SVWHR | Market value currency_FISO | SVWHR | TCURC | CUKY | 5 |
| BARW_VU | Accepted value_VU | BARW_VU | CURR | 13 | |
| SAWHR_VU | Currency of accepted value_VV | SAWHR_VU | TCURC | CUKY | 5 |
| SAART | Asset Type According to Regulatory Accounting Requirements | VVSAART | TZ28 | CHAR | 6 |
| SDV | Premium reserve fund list number | VVSDV | TZ30 | CHAR | 2 |
| SUABT | Subsection number of premium reserve fund list | VVSUABT | TZ31 | CHAR | 2 |
| SMWWHR | Settlement or cover provision currency (Regulat. reporting) | VVSMWWHR | TCURC | CUKY | 5 |
| SNW600 | Asset group BAV stmt 101 201 and 600 | VVSNW600 | TZ29P | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VZBAVV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZBAVV | MANDT | 1: CN | T000 |
| VZBAVV | SAART | : | TZ28 |
| VZBAVV | SANLART | 1: CN | TZ19 |
| VZBAVV | SAWHR | 1: CN | TCURC |
| VZBAVV | SAWHR_VU | 1: CN | TCURC |
| VZBAVV | SDV | 1: CN | TZ30 |
| VZBAVV | SDVNR | 1: CN | TW09B |
| VZBAVV | SMWWHR | 1: CN | TCURC |
| VZBAVV | SNW600 | 1: CN | TZ29P |
| VZBAVV | SSKZB | 1: CN | TZ11 |
| VZBAVV | SSKZF | 1: CN | TZ13 |
| VZBAVV | SUABNDV | 1: CN | TW10B |
| VZBAVV | SUABT | 1: CN | TZ31 |
| VZBAVV | SUDEC | 1: CN | TW05 |
| VZBAVV | SVWHR | 1: CN | TCURC |
| VZBAVV | VVKEY | 1: CN | VZBAVF |