SAP VZBAVF BAV Master Data Without History Management Table
Overview
VZBAVF is a standard SAP S/4HANA table that stores BAV Master Data Without History Management data. There are total 42 fields in the VZBAVF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZBAVF 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 VZBAVF to other SAP tables and standard CDS views available based on VZBAVF table in S/4HANA 2020.
Techincal Settings of VZBAVF
Below are technical details of the table VZBAVF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZBAVF Fields
The following table gives you an overview of the fields available in VZBAVF
| 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 | CHAR | 34 | |
| JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | |
| JBAVG | BAV approval | JBAVG | CHAR | 1 | |
| XAKTZBAV | BAV file number | XAKTZBAV | CHAR | 32 | |
| DBAVGEN | Date of BAV authorization | DBAVGEN | DATS | 8 | |
| SGBAV | BAV asset group (C11/74) indicator | SGBAV | TW06 | NUMC | 3 |
| SBAV501 | *** Internal usage *** | SBAV501 | TW12B | CHAR | 4 |
| SBILK | Balance Sheet Indicator | SBILK | TW11 | CHAR | 2 |
| JARW | *** Not used *** | JARW | CHAR | 1 | |
| DARWGEN | Date for fixing the accepted value | DARWGEN | DATS | 8 | |
| XAKTZARW | BAV file character_accepted value | XAKTZARW | CHAR | 20 | |
| XAUFORT | Storage location | XAUFORT | CHAR | 22 | |
| BARWBAV | BAV accepted value | BARWBAV | CURR | 13 | |
| SAWHR | Currency of accepted value_FISO | SAWHR | TCURC | CUKY | 5 |
| DERWMEL | Date when the acquistion was reported to FISO | DERWMEL | DATS | 8 | |
| 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 |
| SNW101 | *** Internal usage *** | VVSNW101 | TZ14 | NUMC | 2 |
| SNW102 | *** Internal usage *** | VVSNW102 | TZ15 | CHAR | 7 |
| SNW201 | *** Internal usage *** | VVSNW201 | TZ16 | CHAR | 7 |
| SJBUE | Asset group R11/76 Asset 6 (yearly stock overview) | VVSJBUE | TZ17 | CHAR | 6 |
| SNEU_ANL | Asset group R11/76 appendix 3 and 4 | VVSNEU_ANL | TZ18 | CHAR | 9 |
| XR5_91_1 | Indicator R5/91 appendix 1 | VVXR5_91_1 | CHAR | 2 | |
| XR5_91_2 | Indicator R5/91 appendix 1 | VVXR5_91_2 | CHAR | 1 | |
| XR5_91_3 | Indicator R5/91 appendix 3 | VVXR5_91_3 | CHAR | 1 | |
| XTREU | *** Internal usage *** | VVXTREU | CHAR | 1 | |
| XDECK | Indicator for eligibility for premium reserve fund | VVXDECK | CHAR | 1 | |
| XARW | BAV approval of accepted value | VVXARW | CHAR | 1 | |
| SMW102 | BAV asset group stmt 102 | VVSMW102 | TZ32 | CHAR | 5 |
| X_R97_03 | Indicator for circular R5/97 appendix 3 and 4 | VVX_R97_03 | TZ36 | CHAR | 2 |
| X_R97_05 | Indicator for R5/97 appendix 5 | VVX_R97_05 | TZ37 | CHAR | 2 |
| X_R97_06 | Indicator for R5/97 appendix 6 - Collateral | VVX_R97_06 | CHAR | 1 | |
| X_R97_08 | Indicator for R5/97 appendix 8 | VVX_R97_08 | TZ38 | CHAR | 1 |
| X_R97_101 | Indicator for R5/97 appendix 10 | VVX_R97_10 | TZ39B | CHAR | 4 |
| X_R97_102 | Indicator for R5/97 appendix 10 | VVX_R97_10 | TZ39B | CHAR | 4 |
| X_R97_103 | Indicator for R5/97 appendix 10 | VVX_R97_10 | TZ39B | CHAR | 4 |
| X_R97_104 | Indicator for R5/97 appendix 10 | VVX_R97_10 | TZ39B | CHAR | 4 |
| XTREU1 | Trustee inflow/outflow list indicator | VVXTREU1 | CHAR | 1 |
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 VZBAVF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZBAVF | MANDT | 1: CN | T000 |
| VZBAVF | SAWHR | 1: CN | TCURC |
| VZBAVF | SAWHR_VU | 1: CN | TCURC |
| VZBAVF | SBAV501 | 1: CN | TW12B |
| VZBAVF | SBILK | 1: CN | TW11 |
| VZBAVF | SGBAV | 1: CN | TW06 |
| VZBAVF | SJBUE | 1: CN | TZ17 |
| VZBAVF | SMW102 | 1: CN | TZ32 |
| VZBAVF | SNEU_ANL | 1: CN | TZ18 |
| VZBAVF | SNW101 | 1: CN | TZ14 |
| VZBAVF | SNW102 | 1: CN | TZ15 |
| VZBAVF | SNW201 | 1: CN | TZ16 |
| VZBAVF | SVWHR | 1: CN | TCURC |
| VZBAVF | X_R97_03 | 1: CN | TZ36 |
| VZBAVF | X_R97_05 | 1: CN | TZ37 |
| VZBAVF | X_R97_08 | 1: CN | TZ38 |
| VZBAVF | X_R97_101 | 1: CN | TZ39B |
| VZBAVF | X_R97_102 | 1: CN | TZ39B |
| VZBAVF | X_R97_103 | 1: CN | TZ39B |
| VZBAVF | X_R97_104 | 1: CN | TZ39B |