SAP VDDEBTTRANS Borrower Change Without Capital Transfer Table
Overview
VDDEBTTRANS is a standard SAP S/4HANA table that stores Borrower Change Without Capital Transfer data. There are total 32 fields in the VDDEBTTRANS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDDEBTTRANS belongs to Loans Management (FS-CML) module and is located in the package Borrower Change Without Capital Transfer (FVVD_DEBTTR).
In addition, following links provide an overview of foreign key relationships, if any, that link VDDEBTTRANS to other SAP tables and standard CDS views available based on VDDEBTTRANS table in S/4HANA 2020.
Techincal Settings of VDDEBTTRANS
Below are technical details of the table VDDEBTTRANS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDDEBTTRANS Fields
The following table gives you an overview of the fields available in VDDEBTTRANS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SBO_STATUS | Business Operation Status of Borrower Change | TB_SBOSTATUS_DEBTTR | CHAR | 1 | |
| SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | |
| SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | |
| SNOTIZ | Indicator for stored memo | SNOTIZ | CHAR | 1 | |
| XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | |
| BVTYP_NEW | Bank Details ID of Main Borrower | TB_BVTYP_DEBTTR | CHAR | 4 | |
| ZSCHL_NEW | Payment Method of Main Borrower | TB_DZLSCH_DEBTTR | * | CHAR | 1 |
| PARTNER_NEW | New Main Borrower | TB_PARTNER | * | CHAR | 10 |
| DATE_FROM | Transfer Date for the Borrower Change | TB_UEBDAT_DEBTTR | DATS | 8 | |
| DEBTTR_REASON | Reason for the Borrower Change | TB_DEBTTR_REASN | TDDEBTTR_REASON | CHAR | 3 |
| ABWZAHLER | Indicator - Keep Alternative Payer | TB_ABWZAHL | CHAR | 1 | |
| VERFUEB | Indicator - Keep Authorized Drawer | TB_VERFUEGG | CHAR | 1 | |
| ZINSBES | ID: Creation of Interest Certificate | TB_ZINSBES | NUMC | 1 | |
| GEBUEHR | Charge amount | TB_GEBUEHR | CURR | 13 | |
| BEWART | Flow Type | TB_SBEWART_DEBTTR | * | CHAR | 4 |
| DFAELL | Due Date | TB_DFAELL_DEBTTR | DATS | 8 | |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| XTEST | Single-Character Flag | CHAR1 | CHAR | 1 | |
| KUNNR_NEW | Customer Number | KUNNR | * | CHAR | 10 |
| KUNNR_OLD | Customer Number | KUNNR | * | CHAR | 10 |
| PARTNER_OLD | Old Main Borrower | TB_PARTNER_OLD | * | CHAR | 10 |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | * | CHAR | 8 |
| XPARTNAME_OLD | Name of Old Main Loan Partner | TB_XPARTNAME_OLD | CHAR | 30 | |
| PARTNER_TO | New Main Borrower | TB_PARTNER | * | CHAR | 10 |
| PARTNER_FROM | Old Main Borrower | TB_PARTNER_OLD | * | CHAR | 10 |
| KUNNR_TO | Customer Number | KUNNR | * | CHAR | 10 |
| KUNNR_FROM | Customer Number | KUNNR | * | CHAR | 10 |
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 VDDEBTTRANS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDDEBTTRANS | BEWART | 1: C | * |
| VDDEBTTRANS | DEBTTR_REASON | 1: CN | TDDEBTTR_REASON |