SAP VDZV Payment Details for the Loan Table
Overview
VDZV is a standard SAP S/4HANA table that stores Payment Details for the Loan data. There are total 26 fields in the VDZV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDZV belongs to Loans Management (FS-CML) module and is located in the package TR-LO: Payment Requests for Loans (FVVZ).
In addition, following links provide an overview of foreign key relationships, if any, that link VDZV to other SAP tables and standard CDS views available based on VDZV table in S/4HANA 2020.
Techincal Settings of VDZV
Below are technical details of the table VDZV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDZV Fields
The following table gives you an overview of the fields available in VDZV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Contract Number | RANL | VDARL | CHAR | 13 |
| SSIGN | Direction of Flow | TB_SSIGN | CHAR | 1 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| DZVERB | Payment Details Effective From | TB_DZVERB | DATS | 8 | |
| SBEWART | Flow Type | SBEWART | TZB0A | CHAR | 4 |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DCRDAT | Entered On | TB_CRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 |
| HKTID | ID for Account Details | HKTID | T012K | CHAR | 5 |
| RPZAHL | Payer/Payee | TB_RPZAHL_NEW | BUT000 | CHAR | 10 |
| RPBANK | Partner Bank Details | TB_RPBANK | CHAR | 4 | |
| SZART | Payment Transaction | TB_SZART | CHAR | 1 | |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| UZAWE | Payment method supplement | UZAWE | T042F | CHAR | 2 |
| SPAYRQ | Generate Payment Request | TB_SPAYRQK | CHAR | 1 | |
| SPRSNG | Individual Payment | TB_SPRSNGK | CHAR | 1 | |
| SPRGRD | Determine Grouping Definition | TB_SPRGRD | CHAR | 1 | |
| SCSPAY | Same Direction Necessary for Joint Payment? | TB_SCSPAY | CHAR | 1 | |
| ZWELS | List of Respected Payment Methods | DZWELS | CHAR | 10 | |
| 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 VDZV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDZV | BUKRS | 1: CN | T001 |
| VDZV | HBKID | 1: CN | T012 |
| VDZV | HKTID | 1: CN | T012K |
| VDZV | MANDT | 1: CN | T000 |
| VDZV | RFHA | 1: CN | VDARL |
| VDZV | RPZAHL | : | BUT000 |
| VDZV | SBEWART | 1: CN | TZB0A |
| VDZV | UZAWE | 1: CN | T042F |
| VDZV | WAERS | 1: CN | TCURC |
| VDZV | ZLSCH | 1: CN | T042Z |