SAP TABLES | Financial Services | Loans Management(FS-CML) SAP FS

VDREPAYMENT SAP Payoff Master Data Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VDREPAYMENT Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VDREPAYMENT Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
.INCLUDEVDARL_KEY VDARL Key Structure
BUKRSBUKRSCHAR4
*
Company Code
SARCHIVSARCHIVCHAR1 Archiving Category Indicator
RANLRANLCHAR13 Contract NumberALPHA
RBORBOCHAR15 Business Operation Number (Loans)
.INCLUDERREPAY_HEAD Header Data for Payoff
SBO_STATUSTB_SBOSTATUSCHAR1 Bus. operation status
SFGKZTB_SFGKZACHAR1 Release Workflow Indicator for the Business Operation
SRELSTATTB_SRELSTATCHAR1 Internal Release Status in the Business Operations
SNOTIZSNOTIZCHAR1 Indicator for stored memo
.INCLUDERREPAY_BASIS Basic Data for Payoff
DFAELLTB_DFAELLRDATS8 Due Date of Business Operation
BRVWRTB_BRVWRCURR15(2) Available Capital on Due Date
DEFSZTB_REPAY_DEFSZDATS8 Date of End of Fixed-Rate Period
BRPWRTB_BRPWRCURR15(2) Remaining Capital at the End of the Fixed Period
SBOTERMTB_SBOTERMCHAR1 Repayment Change During Partial Payoff
XTEXTTEXT15CHAR15 Text (15 characters)
SBWHRSBWHRCUKY5
*
Position Currency (Currency of Position Amount)
SBRUTTOTB_SBRUTTOCHAR1 Gross procedure
SNETTOTB_SNETTOCHAR1 Net procedure
BBBWHRTB_BBBWHRCURR13(2) Gross Payoff Amount
BCWHRTB_BBNWHRCURR13(2) Net Payoff Amount
BADDFLOWSTB_ADDFLOWSCURR13(2) Other Flows
BOVERDUE_ITEMSTB_OVERDUE_ITEMSCURR13(2) Overdue Items
BCREDITSTB_CREDITSCURR13(2) Credit Balance
BPROPPAYMENTSTB_PROPPAYMENTSCURR13(2) Proportional Payments
BDEFPAYMENTSTB_DEFPAYMENTSCURR13(2) Deferred Payments
BREGPAYMENTSTB_REGPAYMENTSCURR13(2) Regular Payments
BFELD1TB_FELD1CURR13(2) Amount Field 1
BFELD2TB_FELD2CURR13(2) Amount Field 2
BFELD3TB_FELD3CURR13(2) Amount Field 3
BFELD4TB_FELD4CURR13(2) Amount Field 4
BOUTSTANDINGTB_OUTSTANDINGCURR13(2) Payments Outstanding Until Payoff Due Date
IOA_AMOUNTTB_IOA_CALCULATION_RESULTCURR13(2) Interest on Arrears Calculated
BOFFSETNG_FLOWSTB_OFFSETNG_FLOWSCURR13(2) Offsetting Flows/Waivers/Write-Offs
.APPENDRREPAY_PPI_CMLCHN Structure for Refund in PPI
BREFUNDTB_REFUND_CMLCHNCURR13(2) Refund for PPI
.INCLUDERREPAY_DETAIL Detail Data for Payoff


BHWHRTB_BHNWHRCURR13(2) Payoff Amount in Local Currency
KURS1VVKURSFDEC9(5) Exchange rateEXCRT
SINCLTB_SINCLCHAR1 Inclusive Indicator for Due Date
SINCLINTVVSINCLNUMC1 Inclusive indicator for beginning and end of a period
SVULTTB_SVULTCHAR1 Month-End Indicator for Due Date
DDISPOTB_PAYDATEDATS8 Payment Date
SKALIDSKALIDCHAR2
*
Factory calendar
SKALID2VVSKALID2CHAR2
*
Calendar ID 2 (valid in connection with calendar ID 1)
SBEWARTTB_SBEWARTCHAR4 TZB0APayoff Flow Type
SGTXTSGTXTCHAR50 Item Text
BRPWR_FAELLTB_BRPWR_FAELLCURR15(2) Remaining Capital on Due Date
DELFZTB_DELFZ_WITHOUT_REPAYDATS8 Previous Term End Without Payoff (Calculated)
DELFZ_REPAYTB_DELFZ_WITH_REPAYDATS8 New Term End With Payoff
BAVWRTB_BAVVWRCURR15(2) Available Disbursement Obligation on Due Date
BPARTREDUCTIONTB_PARTREDUCTIONCURR13(2) Reduction
BNONSETTLEDREPAYTB_NONSETTLEDREPAYCURR13(2) Repayment not Settled
JREPAY_SETTLEMTB_JREPAY_SETTLEMENTCHAR1 Repayment Settlement
JREGPAYMENTSTB_JREGPAYMENTSCHAR1 Treatment of Regular Payments
SKOARTTB_SKOARTNUMC4 TZK01Partial Payoff: Condition Type for Repayment ChangeC
DGUEL_KPTB_DGUEL_KP_REPAYDATS8 Repayment Change Effective From
BBASISTB_BBASIS_REPAYCURR13(2) Base Amount for Repayment Change
PKONDTB_PKOND_REPAYDEC10(7) Repayment Rate for Repayment Change
BKONDTB_BKOND_REPAYCURR13(2) Payment Installment for Repayment Change
SCONDCOLLTB_SCONDCOLLCHAR1 Repayment Clash
DDEFERRAL_FROMTB_DEFERRAL_FROMDATS8 Start of Deferral Period
DGUEL_KKDGUELDATS8 Date Condition Effective from
SPAYSIMTB_SPAYSIMCHAR1 Indicator: Full Clearing for Actual Principle 1
PSSDKURSTB_PSSDKURSDEC10(7) Exchange Rate For Net Posted Borrower's Notes
BNWHRTB_REPAY_BNWHRCURR13(2) Nominal Payoff Amount
JNOREGSETTLETB_NO_REG_SETTLEMENTCHAR1 Available Capital Contains Regular Repayments
.APPENDRREPAY_DETAIL_ADV_PYOFF_CMLCHN Due date adjustment indicator
DFAELL_ADJTB_DFAELLR_ADJ_CMLCHNCHAR1 Due date adjustment indicator
.INCLUDERREPAY_ADMIN Administration Data for Payoff
PARTNRTB_PARTNR_REPAYCHAR10
*
Payer of PayoffALPHA
ZLSCHDZLSCHCHAR1
*
Payment Method
BVTYPTB_BVTYPCHAR4 Bank Details ID
SZARTTB_SZARTCHAR1 Payment transaction
JNODOIPTB_JNODOIPCHAR1 Blocked by Payoff: No Open Item Clearing for Loan
XNODUNNXNODUNNCHAR1 Exclude Loan from Dunning Run


KOSTLKOSTLCHAR10
*
Cost CenterALPHA
SBUSTVVSBUSTNUMC2 TZB09Posting control key
SZEGENSZEGENNUMC2 TD21Generate incoming payment immediately
DANGAMTB_DANGAM_REPAYDATS8 Creation Date for the Offer
DANGBISTB_DANGBIS_REPAYDATS8 End of the Validity Period of the Offer
DANNAHMETB_DANNAHME_REPAYDATS8 Acceptance Date of the Offer
DKUENDDGTB_DKUEND_REPAYDATS8 Date of Receipt of Notice
SKUENDTB_SKUEND_REPAYNUMC3 TD04Reason for Notice
RREJECT_REASONTB_REJECT_REASONCHAR3 TDREPAY_REJECTReason for Rejection
RREPAY_REASONTB_REPAY_REASONNUMC3 TD04Payoff Reason
KUNNRKUNNRCHAR10
*
Customer NumberALPHA
ZAHLSDZAHLSCHAR1
*
Block Key for Payment
XCONDPAYDATAXCONDPAYDATACHAR1 Keep Payment Data for Condition-Based Flows Acc to Cond.
MABERMABERCHAR2 T047MDunning Area
MANSPMANSPCHAR1 T040SDunning block
.INCLUDERSEPA_INFO Payment Notes Info
REMIT_INFOTB_REMIT_INFOCHAR140 Payment Notes Info
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient
UZAWEUZAWECHAR2
*
Payment Method Supplement
.INCLUDERREPAY_INTERN Internal Data for Payoff
XNODUNN_OLDXNODUNNCHAR1 Exclude Loan from Dunning Run
JNODOIP_OLDTB_JNODOIPCHAR1 Blocked by Payoff: No Open Item Clearing for Loan
DEFSZ_OLDVVDEFSZDATS8 Date of fixed period end
.INCLUDERREPAY_CUSTOM Customer Data for Payoff
CHANGEDCHAR1
.INCLUDERREPAY_PO Installment Loan-Specific Data for the Payoff
DFPOSPOTB_DFPOSPODATS8 Date of Earliest Possible Payoff
MREQUESTORTB_MREQUESTORCHAR10 Business Partner Requesting Payoff (BP Number)ALPHA
MSTOPCODETB_STOPCHAR3 Technical Key for Stop
MQUOTETB_MQUOTECHAR1 Business Operation Is Payoff Quote Or Payoff
MCOM_STATUSTB_MCOM_STATUSNUMC3 TDREPAY_COMSTATUCommunication Status
DCOM_STATUSTB_DCOM_STATUSDATS8 Last Change to Communication Status
MREMITCODETB_REMIT_CODECHAR4 Remittance Code
AACCRUEDTB_AACCRUEDCURR13(2) Payments Accrued
APROJECTEDTB_APROJECTEDCURR13(2) Projected Payments
AINS_DEBITTB_AINS_DEBITCURR13(2) Insurance Receivables (Debit)
AINS_CREDITTB_AINS_CREDITCURR13(2) Insurance Credit Memos (Credit)
AINTDIEMTB_AINTDIEMCURR13(2) Interest per Day
MNOINSTB_NOINSCHAR1 No Insurance Calculation

.APPENDRREPAY_CL_APPEND Fields for the Consumer Loan and for the Business Op. Notice
.INCLUDERREPAY_CL Payoff Data in the Consumer Loan
LIFE_REPAYTB_LIFE_REPAYDEC6 Current Total Term of the Loan in Months
OVERDUE_ITEMSTB_OVERDUE_ITEMS_REPAYDEC6 Arrears of Contract Capital as a Percentage
FIRST_POS_NOTICETB_FIRST_POS_NOTICEDATS8 Earliest Possible Notice Date
INTERIM_ACCOUNTTB_INTERIM_ACCOUNTCHAR10 Receivables Interim AccountALPHA
ENFORCM_PAYMTB_ENFORCM_PAYMCHAR10
*
CollectorALPHA
STATI_OLDTB_NOTICE_STATI_OLDNUMC2
*
Contract Status Before Activation of Notice
DUNNING_DATETB_DUNNING_DATE_REPAYDATS8 Date of Last Dunning Notice
DUNNING_LEVELTB_DUNNING_LEVEL_REPAYNUMC1 Last Dunning Level
CLR_CATEGORYTB_REPAY_CLR_CATEGORYNUMC2 Clearing Category
NO_INST_OLDTB_NO_INST_OLDNUMC3 Previous Total of Loan Installments
INST_NEWTB_INST_NEWCURR13(2) New Figure for Payment Installments
NO_INST_NEWTB_NO_INST_NEWNUMC3 New Total Number of Loan Installments
EXIT_INST_NEWTB_EXIT_INSTCURR13(2) Amount of the Final Installment Payment for the Contract
EXIT_INST_OLDTB_EXIT_INST_OLDCURR13(2) Previous Amount of Clearing Installment
MONTHS_OLDTB_MONTHS_OLDNUMC3 Overall Term in Months Without Payoff
MONTHS_NEWTB_MONTHS_NEWNUMC3 Overall Term in Months with Payoff
.APPENDVDREPAY_KLV Credit Life Insurance Data
.INCLUDERCLICALC_RES Results for Recalculation of Credit Life Insurance
AREIMBURSEMENTTB_CLI_RECALC_CONTRCURR13(2) Credit Life Insurance Reimbursement
AINSURANCE_CONTRTB_CLI_INSURANCECURR13(2) Single Premium for Credit Life Insurance
ADIFFERENCETB_LOLIINBALCURR13(2) Calculated Difference for Credit Life Insurance
ICONSIDERTB_ICONSIDERCHAR1 Transfer CLI Difference
CALCULATION_DATETB_CLI_CALCULATION_DATEDATS8 CLI: Key Date for Calculation of Credit Life Insurance
UCLICURRSBWHRCUKY5
*
Position Currency (Currency of Position Amount)
CLI_FLOW_SBEWARTSBEWARTCHAR4
*
Flow Type
CLI_CHANGEDXFELDCHAR1 Checkbox



Key field
Non-key field