SAP VDDEBTTRANS Borrower Change Without Capital Transfer Table data and field list

VDDEBTTRANS is a standard SAP Table which is used to store Borrower Change Without Capital Transfer data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDDEBTTRANS table consists of various fields, each holding specific information or linking keys about Borrower Change Without Capital Transfer data available in SAP. These include BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (Contract Number), RBO (Business Operation Number (Loans))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VDDEBTTRANS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP VDDEBTTRANS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDDEBTTRANS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBO_STATUSBusiness Operation Status of Borrower Change TB_SBOSTATUS_DEBTTRCHAR1T_SBOSTATUS_DEBTTR
SFGKZRelease Workflow Indicator for the Business Operation TB_SFGKZACHAR1T_SFGKZ
SRELSTATInternal Release Status in the Business Operations TB_SRELSTATCHAR1T_SRELSTAT
SNOTIZIndicator for stored memo SNOTIZCHAR1JANEI
XBO_TEXTText for Business Operation XBOTEXTCHAR30TEXT30
BVTYP_NEWBank Details ID of New Main Borrower TB_BVTYP_DEBTTRCHAR4BVTYP
ZSCHL_NEWPayment Method of New Main Borrower TB_DZLSCH_DEBTTRCHAR1Assigned to domainZLSCH
PARTNER_NEWNew Main Borrower TB_PARTNERCHAR10Assigned to domainALPHAKUNNR
DATE_FROMTransfer Date for the Borrower Change TB_UEBDAT_DEBTTRDATS8DATUM
DEBTTR_REASONReason for the Borrower Change TB_DEBTTR_REASNCHAR3TDDEBTTR_REASONT_DEBTTR_REASON
ABWZAHLERIndicator - Keep Alternative Payer TB_ABWZAHLCHAR1CHAR1
VERFUEBIndicator - Keep Authorized Drawer TB_VERFUEGGCHAR1CHAR1
ZINSBESID: Creation of Interest Certificate TB_ZINSBESNUMC1BZVERARB
GEBUEHRCharge amount TB_GEBUEHRCURR13(2) WERTV7
BEWARTFlow Type TB_SBEWART_DEBTTRCHAR4Assigned to domainSBEWART
DFAELLDue Date TB_DFAELL_DEBTTRDATS8DATUM
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
XTESTSingle-Character Indicator CHAR1CHAR1CHAR1
KUNNR_NEWCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
KUNNR_OLDCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
PARTNER_OLDOld Main Borrower TB_PARTNER_OLDCHAR10Assigned to domainALPHAKUNNR
RREFKONTAccount Assignment Reference in Financial Assets Management RREFKONTCHAR8Assigned to domainUSTRUKRE
XPARTNAME_OLDName of Old Main Loan Partner TB_XPARTNAME_OLDCHAR30TEXT30
PARTNER_TONew Main Borrower TB_PARTNERCHAR10Assigned to domainALPHAKUNNR
PARTNER_FROMOld Main Borrower TB_PARTNER_OLDCHAR10Assigned to domainALPHAKUNNR
KUNNR_TOCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
KUNNR_FROMCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
CHANGED 0

Key field Non-key field



How do I retrieve data from SAP table VDDEBTTRANS using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDDEBTTRANS to SELECT all data from the table
DATA: WA_VDDEBTTRANS TYPE VDDEBTTRANS.

SELECT SINGLE *
FROM VDDEBTTRANS
INTO CORRESPONDING FIELDS OF WA_VDDEBTTRANS
WHERE...

How to access SAP table VDDEBTTRANS

Within an ECC or HANA version of SAP you can also view further information about VDDEBTTRANS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).