SAP VTBZV Payment Details for Transaction Table
Overview
VTBZV is a standard SAP S/4HANA table that stores Payment Details for Transaction data. There are total 31 fields in the VTBZV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBZV belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBZV to other SAP tables and standard CDS views available based on VTBZV table in S/4HANA 2020.
Techincal Settings of VTBZV
Below are technical details of the table VTBZV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBZV Fields
The following table gives you an overview of the fields available in VTBZV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | 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 | 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 | |
| RPCODE | Repetitive Code | RPCODE | FIBL_RPCODE | CHAR | 20 |
| RP_TEXT | Reference Text for Repetitive Code | RPCODE_TEXT | CHAR | 50 | |
| LZBKZ | State Central Bank Indicator | LZBKZ | T015L | CHAR | 3 |
| LANDL | Supplying Country | LANDL | T005 | CHAR | 3 |
| NOVATION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | |
| 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 VTBZV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBZV | BUKRS | 1: CN | T001 |
| VTBZV | HBKID | 1: CN | T012 |
| VTBZV | HKTID | 1: CN | T012K |
| VTBZV | LANDL | C: CN | T005 |
| VTBZV | LZBKZ | C: CN | T015L |
| VTBZV | MANDT | 1: CN | T000 |
| VTBZV | RFHA | 1: CN | VTBFHA |
| VTBZV | RPCODE | : | FIBL_RPCODE |
| VTBZV | SBEWART | 1: CN | TZB0A |
| VTBZV | UZAWE | 1: CN | T042F |
| VTBZV | WAERS | 1: CN | TCURC |
| VTBZV | ZLSCH | 1: CN | T042Z |