SAP VDREPAYMENT Payoff Master Data Table

Overview

VDREPAYMENT is a standard SAP S/4HANA table that stores Payoff Master Data data. There are total 126 fields in the VDREPAYMENT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDREPAYMENT belongs to Loans Management (FS-CML) module and is located in the package Payoff (FVVD_REP).

In addition, following links provide an overview of foreign key relationships, if any, that link VDREPAYMENT to other SAP tables and standard CDS views available based on VDREPAYMENT table in S/4HANA 2020.

Techincal Settings of VDREPAYMENT

Below are technical details of the table VDREPAYMENT

Buffering not allowed
No buffering
Storage type is Column Store

List of VDREPAYMENT Fields

The following table gives you an overview of the fields available in VDREPAYMENT

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	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	Bus. operation status	TB_SBOSTATUS		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
DFAELL	Due Date of Business Operation	TB_DFAELLR		DATS	8
BRVWR	Available Capital on Due Date	TB_BRVWR		CURR	15
DEFSZ	Date of End of Fixed-Rate Period	TB_REPAY_DEFSZ		DATS	8
BRPWR	Remaining Capital at the End of the Fixed Period	TB_BRPWR		CURR	15
SBOTERM	Repayment Change During Partial Payoff	TB_SBOTERM		CHAR	1
XTEXT	Text (15 characters)	TEXT15		CHAR	15
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	*	CUKY	5
SBRUTTO	Gross procedure	TB_SBRUTTO		CHAR	1
SNETTO	Net procedure	TB_SNETTO		CHAR	1
BBBWHR	Gross Payoff Amount	TB_BBBWHR		CURR	13
BCWHR	Net Payoff Amount	TB_BBNWHR		CURR	13
BADDFLOWS	Other Flows	TB_ADDFLOWS		CURR	13
BOVERDUE_ITEMS	Overdue Items	TB_OVERDUE_ITEMS		CURR	13
BCREDITS	Credit Balance	TB_CREDITS		CURR	13
BPROPPAYMENTS	Proportional Payments	TB_PROPPAYMENTS		CURR	13
BDEFPAYMENTS	Deferred Payments	TB_DEFPAYMENTS		CURR	13
BREGPAYMENTS	Regular Payments	TB_REGPAYMENTS		CURR	13
BFELD1	Amount Field 1	TB_FELD1		CURR	13
BFELD2	Amount Field 2	TB_FELD2		CURR	13
BFELD3	Amount Field 3	TB_FELD3		CURR	13
BFELD4	Amount Field 4	TB_FELD4		CURR	13
BOUTSTANDING	Payments Outstanding Until Payoff Due Date	TB_OUTSTANDING		CURR	13
IOA_AMOUNT	Interest on Arrears Calculated	TB_IOA_CALCULATION_RESULT		CURR	13
BOFFSETNG_FLOWS	Offsetting Flows/Waivers/Write-Offs	TB_OFFSETNG_FLOWS		CURR	13
BREFUND	Refund for PPI	TB_REFUND_CMLCHN		CURR	13
BHWHR	Payoff Amount in Local Currency	TB_BHNWHR		CURR	13
KURS1	Exchange rate	VVKURSF		DEC	9
SINCL	Inclusive Indicator for Due Date	TB_SINCL		CHAR	1
SINCLINT	Inclusive indicator for beginning and end of a period	VVSINCL		NUMC	1
SVULT	Month-End Indicator for Due Date	TB_SVULT		CHAR	1
DDISPO	Payment Date	TB_PAYDATE		DATS	8
SKALID	Factory calendar	SKALID		CHAR	2
SKALID2	Calendar ID 2 (valid in connection with calendar ID 1)	VVSKALID2	*	CHAR	2
SBEWART	Payoff Flow Type	TB_SBEWART	TZB0A	CHAR	4
SGTXT	Item Text	SGTXT		CHAR	50
BRPWR_FAELL	Remaining Capital on Due Date	TB_BRPWR_FAELL		CURR	15
DELFZ	Previous Term End Without Payoff (Calculated)	TB_DELFZ_WITHOUT_REPAY		DATS	8
DELFZ_REPAY	New Term End With Payoff	TB_DELFZ_WITH_REPAY		DATS	8
BAVWR	Available Disbursement Obligation on Due Date	TB_BAVVWR		CURR	15
BPARTREDUCTION	Reduction	TB_PARTREDUCTION		CURR	13
BNONSETTLEDREPAY	Repayment not Settled	TB_NONSETTLEDREPAY		CURR	13
JREPAY_SETTLEM	Repayment Settlement	TB_JREPAY_SETTLEMENT		CHAR	1
JREGPAYMENTS	Treatment of Regular Payments	TB_JREGPAYMENTS		CHAR	1
SKOART	Partial Payoff: Condition Type for Repayment ChangeC	TB_SKOART	TZK01	NUMC	4
DGUEL_KP	Repayment Change Effective From	TB_DGUEL_KP_REPAY		DATS	8
BBASIS	Base Amount for Repayment Change	TB_BBASIS_REPAY		CURR	13
PKOND	Repayment Rate for Repayment Change	TB_PKOND_REPAY		DEC	10
BKOND	Payment Installment for Repayment Change	TB_BKOND_REPAY		CURR	13
SCONDCOLL	Repayment Clash	TB_SCONDCOLL		CHAR	1
DDEFERRAL_FROM	Start of Deferral Period	TB_DEFERRAL_FROM		DATS	8
DGUEL_KK	Date Condition Effective from	DGUEL		DATS	8
SPAYSIM	Indicator: Full Clearing for Actual Principle 1	TB_SPAYSIM		CHAR	1
PSSDKURS	Exchange Rate For Net Posted Borrower's Notes	TB_PSSDKURS		DEC	10
BNWHR	Nominal Payoff Amount	TB_REPAY_BNWHR		CURR	13
JNOREGSETTLE	Available Capital Contains Regular Repayments	TB_NO_REG_SETTLEMENT		CHAR	1
DFAELL_ADJ	Due date adjustment indicator	TB_DFAELLR_ADJ_CMLCHN		CHAR	1
PARTNR	Payer of Payoff	TB_PARTNR_REPAY		CHAR	10
ZLSCH	Payment Method	DZLSCH	*	CHAR	1
BVTYP	Bank Details ID	TB_BVTYP		CHAR	4
SZART	Payment Transaction	TB_SZART		CHAR	1
JNODOIP	Blocked by Payoff: No Open Item Clearing for Loan	TB_JNODOIP		CHAR	1
XNODUNN	Exclude Loan from Dunning Run	XNODUNN		CHAR	1
KOSTL	Cost Center	KOSTL	*	CHAR	10
SBUST	Posting control key	VVSBUST	TZB09	NUMC	2
SZEGEN	Generate Incoming Payment Immediately	SZEGEN	TD21	NUMC	2
DANGAM	Creation Date for the Offer	TB_DANGAM_REPAY		DATS	8
DANGBIS	End of the Validity Period of the Offer	TB_DANGBIS_REPAY		DATS	8
DANNAHME	Acceptance Date of the Offer	TB_DANNAHME_REPAY		DATS	8
DKUENDDG	Date of Receipt of Notice	TB_DKUEND_REPAY		DATS	8
SKUEND	Reason for Notice	TB_SKUEND_REPAY	TD04	NUMC	3
RREJECT_REASON	Reason for Rejection	TB_REJECT_REASON	TDREPAY_REJECT	CHAR	3
RREPAY_REASON	Payoff Reason	TB_REPAY_REASON	TD04	NUMC	3
KUNNR	Customer Number	KUNNR		CHAR	10
ZAHLS	Block Key for Payment	DZAHLS		CHAR	1
XCONDPAYDATA	Keep Payment Data for Condition-Based Flows Acc to Cond.	XCONDPAYDATA		CHAR	1
MABER	Dunning Area	MABER	T047M	CHAR	2
MANSP	Dunning Block	MANSP	T040S	CHAR	1
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO		CHAR	140
MNDID	Unique Reference to Mandate for each Payee	SEPA_MNDID		CHAR	35
UZAWE	Payment method supplement	UZAWE	*	CHAR	2
XNODUNN_OLD	Exclude Loan from Dunning Run	XNODUNN		CHAR	1
JNODOIP_OLD	Blocked by Payoff: No Open Item Clearing for Loan	TB_JNODOIP		CHAR	1
DEFSZ_OLD	Date of fixed period end	VVDEFSZ		DATS	8
DFPOSPO	Date of Earliest Possible Payoff	TB_DFPOSPO		DATS	8
MREQUESTOR	Business Partner Requesting Payoff (BP Number)	TB_MREQUESTOR		CHAR	10
MSTOPCODE	Technical Key for Stop	TB_STOP		CHAR	3
MQUOTE	Business Operation Is Payoff Quote Or Payoff	TB_MQUOTE		CHAR	1
MCOM_STATUS	Communication Status	TB_MCOM_STATUS	TDREPAY_COMSTATU	NUMC	3
DCOM_STATUS	Last Change to Communication Status	TB_DCOM_STATUS		DATS	8
MREMITCODE	Remittance Code	TB_REMIT_CODE		CHAR	4
AACCRUED	Payments Accrued	TB_AACCRUED		CURR	13
APROJECTED	Projected Payments	TB_APROJECTED		CURR	13
AINS_DEBIT	Insurance Receivables (Debit)	TB_AINS_DEBIT		CURR	13
AINS_CREDIT	Insurance Credit Memos (Credit)	TB_AINS_CREDIT		CURR	13
AINTDIEM	Interest per Day	TB_AINTDIEM		CURR	13
MNOINS	No Insurance Calculation	TB_NOINS		CHAR	1
DELFZ_KOKO	End of Term	DELFZ		DATS	8
LIFE_REPAY	Current Total Term of the Loan in Months	TB_LIFE_REPAY		DEC	6
OVERDUE_ITEMS	Arrears of Contract Capital as a Percentage	TB_OVERDUE_ITEMS_REPAY		DEC	6
FIRST_POS_NOTICE	Earliest Possible Notice Date	TB_FIRST_POS_NOTICE		DATS	8
INTERIM_ACCOUNT	Receivables Interim Account	TB_INTERIM_ACCOUNT		CHAR	10
ENFORCM_PAYM	Collector	TB_ENFORCM_PAYM	*	CHAR	10
STATI_OLD	Contract Status Before Activation of Notice	TB_NOTICE_STATI_OLD	*	NUMC	2
DUNNING_DATE	Date of Last Dunning Notice	TB_DUNNING_DATE_REPAY		DATS	8
DUNNING_LEVEL	Last Dunning Level	TB_DUNNING_LEVEL_REPAY		NUMC	1
CLR_CATEGORY	Clearing Category	TB_REPAY_CLR_CATEGORY		NUMC	2
INST_NEW	New Figure for Payment Installments	TB_INST_NEW		CURR	13
EXIT_INST_NEW	Amount of the Final Installment Payment for the Contract	TB_EXIT_INST		CURR	13
EXIT_INST_OLD	Previous Amount of Clearing Installment	TB_EXIT_INST_OLD		CURR	13
AREIMBURSEMENT	Credit Life Insurance Reimbursement	TB_CLI_RECALC_CONTR		CURR	13
AINSURANCE_CONTR	Single Premium for Credit Life Insurance	TB_CLI_INSURANCE		CURR	13
ADIFFERENCE	Calculated Difference for Credit Life Insurance	TB_LOLIINBAL		CURR	13
ICONSIDER	Transfer CLI Difference	TB_ICONSIDER		CHAR	1
CALCULATION_DATE	CLI: Key Date for Calculation of Credit Life Insurance	TB_CLI_CALCULATION_DATE		DATS	8
UCLICURR	Position Currency (Currency of Position Amount)	SBWHR	*	CUKY	5
CLI_FLOW_SBEWART	Flow Type	SBEWART	*	CHAR	4
CLI_CHANGED	Checkbox	XFELD		CHAR	1

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 VDREPAYMENT

Table Name	Field	Cardinality	Check Table
VDREPAYMENT	MABER	:	T047M
VDREPAYMENT	MANDT	1: CN	T000
VDREPAYMENT	MANSP	:	T040S
VDREPAYMENT	MCOM_STATUS	1: CN	TDREPAY_COMSTATU
VDREPAYMENT	RREJECT_REASON	1: CN	TDREPAY_REJECT
VDREPAYMENT	RREPAY_REASON	1: CN	TD04
VDREPAYMENT	SBEWART	1: C	TZB0A
VDREPAYMENT	SBUST	:	TZB09
VDREPAYMENT	SKOART	:	TZK01
VDREPAYMENT	SKUEND	1: C	TD04
VDREPAYMENT	SZEGEN	:	TD21
VDREPAYMENT	ZAHLS	:	*

SAP VDREPAYMENT Payoff Master Data Table

Overview

Techincal Settings of VDREPAYMENT

List of VDREPAYMENT Fields

Foreign Key Relationships

Other References