SAP VZPARZA Partner addit. data (general part) Table
Overview
VZPARZA is a standard SAP S/4HANA table that stores Partner addit. data (general part) data. There are total 49 fields in the VZPARZA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZPARZA belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package R/3 application development for Financial Assets Management (FVV).
In addition, following links provide an overview of foreign key relationships, if any, that link VZPARZA to other SAP tables and standard CDS views available based on VZPARZA table in S/4HANA 2020.
Techincal Settings of VZPARZA
Below are technical details of the table VZPARZA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZPARZA Fields
The following table gives you an overview of the fields available in VZPARZA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PARTNR | Partner number | SPARTNR | SPRT1 | CHAR | 10 |
| SPERRE | Internal flag: Record is blocked for changes | JGESPERRT | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| ROLLERF | External role of partner | SROLEXT | TZRE | CHAR | 3 |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| ROLLBEA | External role of partner | SROLEXT | TZRE | CHAR | 3 |
| SGRDWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| SZIEL | Target group | SZIEL | TD05 | NUMC | 2 |
| JEIDVER | Submission of solemn declaration about wealth | JEIDVER | CHAR | 1 | |
| JKONKURS | Bankruptcy proceedings indicator | JKONKURS | CHAR | 1 | |
| JZWANG | Foreclosure indicator | JZWANG | CHAR | 1 | |
| JSCHUFA | Acct solicitation service status | SSCHUFA | CHAR | 1 | |
| SBONITA | Credit standing | SBONITA | CHAR | 1 | |
| SKRED | Source of credit information (informant in form of company) | SKRED | TIV61 | NUMC | 2 |
| XKRED | Summary of credit information | VVXKRED | CHAR | 50 | |
| JKWG14 | Indicator borrowers subject to reporting GBA §14 (KWG) | JKWG14 | CHAR | 1 | |
| RKWG14 | SCB borrower no. in acc. with par. 14 GBA | RKWG14 | CHAR | 8 | |
| RKWG14KE | SCB borrower unit no. according to para. 14 KWG | RKWG14KE | CHAR | 8 | |
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | |
| STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | |
| STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | |
| SFINAMT | Tax office partner key | SFINAMT | SPRT1 | CHAR | 10 |
| SORGAN | Loan to manager indicator | SORGAN | TZD1 | NUMC | 2 |
| SGRP1 | Group Key 1 (Freely-Definable - 3 Figure Number) | VVGRP_1 | TZDG1 | NUMC | 3 |
| SGRP2 | Group Key 2 (Freely-Definable - 3 Figure Number) | VVGRP_2 | TZDG2 | NUMC | 3 |
| SGRP3 | Group Key 3 (Freely-Definable - 3 Figure Number) | VVGRP_3 | TZDG3 | NUMC | 3 |
| SFRT1 | User-defined text (freely definable - 35 character text) | VVFREI_1 | CHAR | 35 | |
| SFRT2 | User-defined text (freely definable - 35 character text) | VVFREI_2 | CHAR | 35 | |
| YKONKURS | Year of bankruptcy proceedings | VVYKONKURS | NUMC | 4 | |
| YZWANG | Year of foreclosure | VVYZWANG | NUMC | 4 | |
| YEIDVER | Year of affidavit | VVYEIDVER | NUMC | 4 | |
| DSCHUFA | Date of last credit information | VVDSCHUFA | DATS | 8 | |
| SPAVIP | VIP Partner | PAVIP | TVIP | CHAR | 1 |
| SSAUSLA | Non-resident tax indicator | VVSSAUSLA | CHAR | 1 | |
| SKWG18 | Information in accordance with §18 GBA | VVSKWG18 | TZV15 | NUMC | 2 |
| XAPARNR | Partner ID in previous system | VVXAPARNR | CHAR | 15 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| ABUKR | Partner-company code allocation | VVSABUKR | T001 | CHAR | 4 |
| KALID | Factory calendar | SKALID | TFACD | CHAR | 2 |
| XID_AT | OeNB ID Number | VVXID_AT | CHAR | 11 | |
| SZG_AT | Target Group According to OeNB | VVSZG_AT | TD05_AT | CHAR | 2 |
| SID_AT | Indicator: Assign Numbers for OeNB Externally | VVSID_AT | 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 VZPARZA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZPARZA | ABUKR | 1: CN | T001 |
| VZPARZA | KALID | 1: CN | TFACD |
| VZPARZA | LIFNR | C: CN | LFA1 |
| VZPARZA | MANDT | 1: 1 | T000 |
| VZPARZA | PARTNR | 1: CN | SPRT1 |
| VZPARZA | ROLLBEA | 1: CN | TZRE |
| VZPARZA | ROLLERF | 1: CN | TZRE |
| VZPARZA | SFINAMT | 1: 1 | SPRT1 |
| VZPARZA | SGRDWHR | 1: 1 | TCURC |
| VZPARZA | SGRP1 | 1: CN | TZDG1 |
| VZPARZA | SGRP2 | 1: CN | TZDG2 |
| VZPARZA | SGRP3 | 1: CN | TZDG3 |
| VZPARZA | SKRED | : | TIV61 |
| VZPARZA | SKWG18 | 1: CN | TZV15 |
| VZPARZA | SORGAN | 1: CN | TZD1 |
| VZPARZA | SPAVIP | 1: CN | TVIP |
| VZPARZA | SZG_AT | 1: CN | TD05_AT |
| VZPARZA | SZIEL | 1: CN | TD05 |