VDREPAYMENT SAP (Payoff Master Data) Table details

Dictionary Type: Table
Description: Payoff Master Data




ABAP Code to SELECT data from VDREPAYMENT
Related tables to VDREPAYMENT
Access table VDREPAYMENT




Table field list including key, data, relationships and ABAP select examples

VDREPAYMENT is a standard SAP Table which is used to store Payoff Master Data data and is available within R/3 SAP systems depending on the version and release level.

The VDREPAYMENT table consists of various fields, each holding specific information or linking keys about Payoff Master Data 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. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBO_STATUSBus. operation status TB_SBOSTATUSCHAR1SBO_STATUS
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
DFAELLDue Date of Business Operation TB_DFAELLRDATS8DATUM
BRVWRAvailable Capital on Due Date TB_BRVWRCURR15(2) WERTV8_TR
DEFSZDate of End of Fixed-Rate Period TB_REPAY_DEFSZDATS8DATUM
BRPWRRemaining Capital at the End of the Fixed Period TB_BRPWRCURR15(2) WERTV8_TR
SBOTERMRepayment Change During Partial Payoff TB_SBOTERMCHAR1T_SBO_TERM
XTEXTText (15 characters) TEXT15CHAR15TEXT15
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
SBRUTTOGross procedure TB_SBRUTTOCHAR1JFLAGG
SNETTONet procedure TB_SNETTOCHAR1JFLAGG
BBBWHRGross Payoff Amount TB_BBBWHRCURR13(2) WERTV7
BCWHRNet Payoff Amount TB_BBNWHRCURR13(2) WERTV7
BADDFLOWSOther Flows TB_ADDFLOWSCURR13(2) WERTV7
BOVERDUE_ITEMSOverdue Items TB_OVERDUE_ITEMSCURR13(2) WERTV7
BCREDITSCredit Balance TB_CREDITSCURR13(2) WERTV7
BPROPPAYMENTSProportional Payments TB_PROPPAYMENTSCURR13(2) WERTV7
BDEFPAYMENTSDeferred Payments TB_DEFPAYMENTSCURR13(2) WERTV7
BREGPAYMENTSRegular Payments TB_REGPAYMENTSCURR13(2) WERTV7
BFELD1Amount Field 1 TB_FELD1CURR13(2) WERTV7
BFELD2Amount Field 2 TB_FELD2CURR13(2) WERTV7
BFELD3Amount Field 3 TB_FELD3CURR13(2) WERTV7
BFELD4Amount Field 4 TB_FELD4CURR13(2) WERTV7
BOUTSTANDINGPayments Outstanding Until Payoff Due Date TB_OUTSTANDINGCURR13(2) WERTV7
IOA_AMOUNTInterest on Arrears Calculated TB_IOA_CALCULATION_RESULTCURR13(2) WERTV7
BOFFSETNG_FLOWSOffsetting Flows/Waivers/Write-Offs TB_OFFSETNG_FLOWSCURR13(2) WERTV7
.INCLU--AP 0
BREFUNDRefund for PPI TB_REFUND_CMLCHNCURR13(2) WERTV7
BHWHRPayoff Amount in Local Currency TB_BHNWHRCURR13(2) WERTV7
KURS1Exchange rate VVKURSFDEC9(5) EXCRTKURSF
SINCLInclusive Indicator for Due Date TB_SINCLCHAR1XFELD
SINCLINTInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SVULTMonth-End Indicator for Due Date TB_SVULTCHAR1VVSULT
DDISPOPayment Date TB_PAYDATEDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2Assigned to domainWFCIDH_TFACD
SKALID2Calendar ID 2 (valid in connection with calendar ID 1) VVSKALID2CHAR2Assigned to domainWFCID
SBEWARTPayoff Flow Type TB_SBEWARTCHAR4TZB0ASBEWART
SGTXTItem Text SGTXTCHAR50TEXT50
BRPWR_FAELLRemaining Capital on Due Date TB_BRPWR_FAELLCURR15(2) WERTV8_TR
DELFZPrevious Term End Without Payoff (Calculated) TB_DELFZ_WITHOUT_REPAYDATS8DATUM
DELFZ_REPAYNew Term End With Payoff TB_DELFZ_WITH_REPAYDATS8DATUM
BAVWRAvailable Disbursement Obligation on Due Date TB_BAVVWRCURR15(2) WERTV8_TR
BPARTREDUCTIONReduction TB_PARTREDUCTIONCURR13(2) WERTV7
BNONSETTLEDREPAYRepayment not Settled TB_NONSETTLEDREPAYCURR13(2) WERTV7
JREPAY_SETTLEMRepayment Settlement TB_JREPAY_SETTLEMENTCHAR1JFLAGG
JREGPAYMENTSTreatment of Regular Payments TB_JREGPAYMENTSCHAR1JFLAGG
SKOARTPartial Payoff: Condition Type for Repayment ChangeC TB_SKOARTNUMC4TZK01SKOART
DGUEL_KPRepayment Change Effective From TB_DGUEL_KP_REPAYDATS8DATUM
BBASISBase Amount for Repayment Change TB_BBASIS_REPAYCURR13(2) WERTV7
PKONDRepayment Rate for Repayment Change TB_PKOND_REPAYDEC10(7) DECV3_7
BKONDPayment Installment for Repayment Change TB_BKOND_REPAYCURR13(2) WERTV7
SCONDCOLLRepayment Clash TB_SCONDCOLLCHAR1TB_SCONDCOLL
DDEFERRAL_FROMStart of Deferral Period TB_DEFERRAL_FROMDATS8DATUM
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
SPAYSIMIndicator: Full Clearing for Actual Principle 1 TB_SPAYSIMCHAR1JFLAGG
PSSDKURSExchange Rate For Net Posted Borrower's Notes TB_PSSDKURSDEC10(7) PWKURS
BNWHRNominal Payoff Amount TB_REPAY_BNWHRCURR13(2) WERTV7
JNOREGSETTLEAvailable Capital Contains Regular Repayments TB_NO_REG_SETTLEMENTCHAR1JFLAGG
.INCLU--AP 0
DFAELL_ADJDue date adjustment indicator TB_DFAELLR_ADJ_CMLCHNCHAR1TD_DFAELLR_ADJ_CMLCHN
PARTNRPayer of Payoff TB_PARTNR_REPAYCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
BVTYPBank Details ID TB_BVTYPCHAR4BVTYP
SZARTPayment transaction TB_SZARTCHAR1XFELD
JNODOIPBlocked by Payoff: No Open Item Clearing for Loan TB_JNODOIPCHAR1XFELD
XNODUNNExclude Loan from Dunning Run XNODUNNCHAR1XFELD
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
SBUSTPosting control key VVSBUSTNUMC2TZB09VVSBUST
SZEGENGenerate incoming payment immediately SZEGENNUMC2TD21SZEGEN
DANGAMCreation Date for the Offer TB_DANGAM_REPAYDATS8DATUM
DANGBISEnd of the Validity Period of the Offer TB_DANGBIS_REPAYDATS8DATUM
DANNAHMEAcceptance Date of the Offer TB_DANNAHME_REPAYDATS8DATUM
DKUENDDGDate of Receipt of Notice TB_DKUEND_REPAYDATS8DATUM
SKUENDReason for Notice TB_SKUEND_REPAYNUMC3TD04SKUEART
RREJECT_REASONReason for Rejection TB_REJECT_REASONCHAR3TDREPAY_REJECTT_REASON
RREPAY_REASONPayoff Reason TB_REPAY_REASONNUMC3TD04SKUEART
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
XCONDPAYDATAKeep Payment Data for Condition-Based Flows Acc to Cond. XCONDPAYDATACHAR1XFELD
MABERDunning Area MABERCHAR2T047MMABER
MANSPDunning block MANSPCHAR1T040SMANSP
REMIT_INFOPayment Notes Info TB_REMIT_INFOCHAR140T_REMIT_INFO
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
XNODUNN_OLDExclude Loan from Dunning Run XNODUNNCHAR1XFELD
JNODOIP_OLDBlocked by Payoff: No Open Item Clearing for Loan TB_JNODOIPCHAR1XFELD
DEFSZ_OLDDate of fixed period end VVDEFSZDATS8DATUM
CHANGED 0
DFPOSPODate of Earliest Possible Payoff TB_DFPOSPODATS8T_DFPOSPO
MREQUESTORBusiness Partner Requesting Payoff (BP Number) TB_MREQUESTORCHAR10ALPHAT_MREQUESTOR
MSTOPCODETechnical Key for Stop TB_STOPCHAR3T_STOP
MQUOTEBusiness Operation Is Payoff Quote Or Payoff TB_MQUOTECHAR1T_MQUOTE
MCOM_STATUSCommunication Status TB_MCOM_STATUSNUMC3TDREPAY_COMSTATUT_MCOM_STATUS
DCOM_STATUSLast Change to Communication Status TB_DCOM_STATUSDATS8T_DCOM_STATUS
MREMITCODERemittance Code TB_REMIT_CODECHAR4CHAR4
AACCRUEDPayments Accrued TB_AACCRUEDCURR13(2) T_AAMOUNT
APROJECTEDProjected Payments TB_APROJECTEDCURR13(2) T_AAMOUNT
AINS_DEBITInsurance Receivables (Debit) TB_AINS_DEBITCURR13(2) T_AAMOUNT
AINS_CREDITInsurance Credit Memos (Credit) TB_AINS_CREDITCURR13(2) T_AAMOUNT
AINTDIEMInterest per Day TB_AINTDIEMCURR13(2) T_AAMOUNT
MNOINSNo Insurance Calculation TB_NOINSCHAR1XFELD
.INCLU--AP 0
LIFE_REPAYCurrent Total Term of the Loan in Months TB_LIFE_REPAYDEC6DEC6
OVERDUE_ITEMSArrears of Contract Capital as a Percentage TB_OVERDUE_ITEMS_REPAYDEC6DEC6
FIRST_POS_NOTICEEarliest Possible Notice Date TB_FIRST_POS_NOTICEDATS8DATE
INTERIM_ACCOUNTReceivables Interim Account TB_INTERIM_ACCOUNTCHAR10ALPHAT_INTERIM_ACCOUNT
ENFORCM_PAYMCollector TB_ENFORCM_PAYMCHAR10Assigned to domainALPHABU_PARTNER
STATI_OLDContract Status Before Activation of Notice TB_NOTICE_STATI_OLDNUMC2Assigned to domainSTATI
DUNNING_DATEDate of Last Dunning Notice TB_DUNNING_DATE_REPAYDATS8DATE
DUNNING_LEVELLast Dunning Level TB_DUNNING_LEVEL_REPAYNUMC1MAHNS
CLR_CATEGORYClearing Category TB_REPAY_CLR_CATEGORYNUMC2T_REPAY_CLR_CATEGORY
NO_INST_OLDPrevious Total of Loan Installments TB_NO_INST_OLDNUMC3
INST_NEWNew Figure for Payment Installments TB_INST_NEWCURR13(2) WERTV7
NO_INST_NEWNew Total Number of Loan Installments TB_NO_INST_NEWNUMC3
EXIT_INST_NEWAmount of the Final Installment Payment for the Contract TB_EXIT_INSTCURR13(2) WERTV7
EXIT_INST_OLDPrevious Amount of Clearing Installment TB_EXIT_INST_OLDCURR13(2) WERTV7
MONTHS_OLDOverall Term in Months Without Payoff TB_MONTHS_OLDNUMC3
MONTHS_NEWOverall Term in Months with Payoff TB_MONTHS_NEWNUMC3
.INCLU--AP 0
AREIMBURSEMENTCredit Life Insurance Reimbursement TB_CLI_RECALC_CONTRCURR13(2) WERTV7
AINSURANCE_CONTRSingle Premium for Credit Life Insurance TB_CLI_INSURANCECURR13(2) WERTV7
ADIFFERENCECalculated Difference for Credit Life Insurance TB_LOLIINBALCURR13(2) WERTV7
ICONSIDERTransfer CLI Difference TB_ICONSIDERCHAR1XFELD
CALCULATION_DATECLI: Key Date for Calculation of Credit Life Insurance TB_CLI_CALCULATION_DATEDATS8DATUM
UCLICURRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
CLI_FLOW_SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
CLI_CHANGEDCheckbox XFELDCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM VDREPAYMENT
INTO CORRESPONDING FIELDS OF WA_VDREPAYMENT
WHERE...

How to access SAP table VDREPAYMENT

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!