SAP VZBAVZ Stock totals for PRF-O Table
Overview
VZBAVZ is a standard SAP S/4HANA table that stores Stock totals for PRF-O data. There are total 14 fields in the VZBAVZ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZBAVZ belongs to Germany (FS-SR-DE) module and is located in the package Statutory Reporting Germany (VVSRG).
In addition, following links provide an overview of foreign key relationships, if any, that link VZBAVZ to other SAP tables and standard CDS views available based on VZBAVZ table in S/4HANA 2020.
Techincal Settings of VZBAVZ
Below are technical details of the table VZBAVZ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZBAVZ Fields
The following table gives you an overview of the fields available in VZBAVZ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| 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 | TW09 | CHAR | 4 |
| SUABNDV | *** Internal usage *** | SUABNDV | TW10 | NUMC | 2 |
| RINUM | BAV identification number | RINUM | CHAR | 22 | |
| DGUEL_AB | Entry effective from | DGUEL_AB | DATS | 8 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| SDV | Premium reserve fund list number | VVSDV | TZ30 | CHAR | 2 |
| SUABT | Subsection number of premium reserve fund list | VVSUABT | TZ31 | CHAR | 2 |
| DERST_AM | BAV stock list creation date | VVDERST_AM | DATS | 8 | |
| BHWHR | Position amount in local currency | VVBBSTHWHR | CURR | 13 | |
| BBOKLFW | Position amount opening clause | VVBBOKLFW | CURR | 13 |
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 VZBAVZ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZBAVZ | BUKRS | 1: CN | T001 |
| VZBAVZ | MANDT | 1: CN | T000 |
| VZBAVZ | SDV | : | TZ30 |
| VZBAVZ | SDVNR | 1: CN | TW09 |
| VZBAVZ | SSKZB | 1: CN | TZ11 |
| VZBAVZ | SUABNDV | 1: CN | TW10 |
| VZBAVZ | SUABT | : | TZ31 |
| VZBAVZ | SUDEC | 1: CN | TW05 |