SAP VZZUSP Payment splitting Table
Overview
VZZUSP is a standard SAP S/4HANA table that stores Payment splitting data. There are total 20 fields in the VZZUSP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZZUSP 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 VZZUSP to other SAP tables and standard CDS views available based on VZZUSP table in S/4HANA 2020.
Techincal Settings of VZZUSP
Below are technical details of the table VZZUSP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZZUSP Fields
The following table gives you an overview of the fields available in VZZUSP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SNUMOBJ | Key for number range object | VVNUMOBJ | CHAR | 2 | |
| SOBJEKT | Internal key for object for business partner table | VVSOBJGPO | CHAR | 13 | |
| DGUELTAB | Date Condition Effective from | DGUEL | DATS | 8 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| SANWDG | Application type | VVSANWDG | CHAR | 1 | |
| BZUBETR | Subsidy/allowance amount | VVZUBETR | CURR | 13 | |
| PROZTEIL | Percentage rate for condition items | PKOND | DEC | 10 | |
| BMAXBETR | Subsidy/grant maximum amount | VVMAXBETR | CURR | 13 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | * | NUMC | 4 |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| ZLSCH | Payment Method | DZLSCH | * | CHAR | 1 |
| DGUELBIS | Effective until date | DGUELBIS | DATS | 8 | |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| ZLSPR | Payment Block Key | DZLSPR | T008 | CHAR | 1 |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 |
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 VZZUSP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZZUSP | KUNNR | 1: CN | KNA1 |
| VZZUSP | MANDT | 1: 1 | T000 |
| VZZUSP | ZLSPR | : | T008 |