SAP ABAP Table VDREPAYMENT (Payoff Master Data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_REP (Package) Payoff

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDREPAYMENT	Table Relationship Diagram
Short Description	Payoff Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	VDARL Key Structure
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	SARCHIV	☑	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
5	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
6	RBO	☑	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
7	.INCLUDE	☐				0	0	Header Data for Payoff
8	SBO_STATUS	☐	SBO_STATUS	SBO_STATUS	CHAR	1	0	Loans: Business operation status
9	SFGKZ	☐	TB_SFGKZA	T_SFGKZ	CHAR	1	0	Release Workflow Indicator for the Business Operation
10	SRELSTAT	☐	TB_SRELSTAT	T_SRELSTAT	CHAR	1	0	Internal Release Status in the Business Operations
11	SNOTIZ	☐	SNOTIZ	JANEI	CHAR	1	0	Indicator for stored memo
12	.INCLUDE	☐				0	0	Basic Data for Payoff
13	DFAELL	☐	TB_DFAELLR	DATUM	DATS	8	0	Due Date of Business Operation
14	BRVWR	☐	TB_BRVWR	WERTV8_TR	CURR	15	2	Available Capital on Due Date
15	DEFSZ	☐	TB_REPAY_DEFSZ	DATUM	DATS	8	0	Date of End of Fixed-Rate Period
16	BRPWR	☐	TB_BRPWR	WERTV8_TR	CURR	15	2	Remaining Capital at the End of the Fixed Period
17	SBOTERM	☐	TB_SBOTERM	T_SBO_TERM	CHAR	1	0	Repayment Change During Partial Payoff
18	XTEXT	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
19	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
20	SBRUTTO	☐	TB_SBRUTTO	JFLAGG	CHAR	1	0	Gross procedure
21	SNETTO	☐	TB_SNETTO	JFLAGG	CHAR	1	0	Net procedure
22	BBBWHR	☐	TB_BBBWHR	WERTV7	CURR	13	2	Gross Payoff Amount
23	BCWHR	☐	TB_BBNWHR	WERTV7	CURR	13	2	Net Payoff Amount
24	BADDFLOWS	☐	TB_ADDFLOWS	WERTV7	CURR	13	2	Other Flows
25	BOVERDUE_ITEMS	☐	TB_OVERDUE_ITEMS	WERTV7	CURR	13	2	Overdue Items
26	BCREDITS	☐	TB_CREDITS	WERTV7	CURR	13	2	Credit Balance
27	BPROPPAYMENTS	☐	TB_PROPPAYMENTS	WERTV7	CURR	13	2	Proportional Payments
28	BDEFPAYMENTS	☐	TB_DEFPAYMENTS	WERTV7	CURR	13	2	Deferred Payments
29	BREGPAYMENTS	☐	TB_REGPAYMENTS	WERTV7	CURR	13	2	Regular Payments
30	BFELD1	☐	TB_FELD1	WERTV7	CURR	13	2	Amount Field 1
31	BFELD2	☐	TB_FELD2	WERTV7	CURR	13	2	Amount Field 2
32	BFELD3	☐	TB_FELD3	WERTV7	CURR	13	2	Amount Field 3
33	BFELD4	☐	TB_FELD4	WERTV7	CURR	13	2	Amount Field 4
34	BOUTSTANDING	☐	TB_OUTSTANDING	WERTV7	CURR	13	2	Payments Outstanding Until Payoff Due Date
35	IOA_AMOUNT	☐	TB_IOA_CALCULATION_RESULT	WERTV7	CURR	13	2	Interest on Arrears Calculated
36	.INCLUDE	☐				0	0	Detail Data for Payoff
37	BHWHR	☐	TB_BHNWHR	WERTV7	CURR	13	2	Payoff Amount in Local Currency
38	KURS1	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
39	SINCL	☐	TB_SINCL	XFELD	CHAR	1	0	Inclusive Indicator for Due Date
40	SINCLINT	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
41	SVULT	☐	TB_SVULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
42	DDISPO	☐	TB_PAYDATE	DATUM	DATS	8	0	Payment Date
43	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	*
44	SKALID2	☐	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)	*
45	SBEWART	☐	TB_SBEWART	SBEWART	CHAR	4	0	Payoff Flow Type	TZB0A
46	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
47	BRPWR_FAELL	☐	TB_BRPWR_FAELL	WERTV8_TR	CURR	15	2	Remaining Capital on Due Date
48	DELFZ	☐	TB_DELFZ_WITHOUT_REPAY	DATUM	DATS	8	0	Previous Term End Without Payoff (Calculated)
49	DELFZ_REPAY	☐	TB_DELFZ_WITH_REPAY	DATUM	DATS	8	0	New Term End With Payoff
50	BAVWR	☐	TB_BAVVWR	WERTV8_TR	CURR	15	2	Available Disbursement Obligation on Due Date
51	BPARTREDUCTION	☐	TB_PARTREDUCTION	WERTV7	CURR	13	2	Reduction
52	BNONSETTLEDREPAY	☐	TB_NONSETTLEDREPAY	WERTV7	CURR	13	2	Repayment not Settled
53	JREPAY_SETTLEM	☐	TB_JREPAY_SETTLEMENT	JFLAGG	CHAR	1	0	Repayment Settlement
54	JREGPAYMENTS	☐	TB_JREGPAYMENTS	JFLAGG	CHAR	1	0	Treatment of Regular Payments
55	SKOART	☐	TB_SKOART	SKOART	NUMC	4	0	Partial Payoff: Condition Type for Repayment ChangeC	TZK01
56	DGUEL_KP	☐	TB_DGUEL_KP_REPAY	DATUM	DATS	8	0	Repayment Change Effective From
57	BBASIS	☐	TB_BBASIS_REPAY	WERTV7	CURR	13	2	Base Amount for Repayment Change
58	PKOND	☐	TB_PKOND_REPAY	DECV3_7	DEC	10	7	Repayment Rate for Repayment Change
59	BKOND	☐	TB_BKOND_REPAY	WERTV7	CURR	13	2	Payment Installment for Repayment Change
60	SCONDCOLL	☐	TB_SCONDCOLL	TB_SCONDCOLL	CHAR	1	0	Repayment Clash
61	DDEFERRAL_FROM	☐	TB_DEFERRAL_FROM	DATUM	DATS	8	0	Start of Deferral Period
62	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
63	SPAYSIM	☐	TB_SPAYSIM	JFLAGG	CHAR	1	0	Indicator: Full Clearing for Actual Principle 1
64	PSSDKURS	☐	TB_PSSDKURS	PWKURS	DEC	10	7	Exchange Rate For Net Posted Borrower's Notes
65	BNWHR	☐	TB_REPAY_BNWHR	WERTV7	CURR	13	2	Nominal Payoff Amount
66	JNOREGSETTLE	☐	TB_NO_REG_SETTLEMENT	JFLAGG	CHAR	1	0	Available Capital Contains Regular Repayments
67	.INCLUDE	☐				0	0	Administration Data for Payoff
68	PARTNR	☐	TB_PARTNR_REPAY	BU_PARTNER	CHAR	10	0	Payer of Payoff	*
69	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
70	BVTYP	☐	TB_BVTYP	BVTYP	CHAR	4	0	Bank Details ID
71	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
72	JNODOIP	☐	TB_JNODOIP	XFELD	CHAR	1	0	Blocked by Payoff: No Open Item Clearing for Loan
73	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
74	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
75	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
76	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	TD21
77	DANGAM	☐	TB_DANGAM_REPAY	DATUM	DATS	8	0	Creation Date for the Offer
78	DANGBIS	☐	TB_DANGBIS_REPAY	DATUM	DATS	8	0	End of the Validity Period of the Offer
79	DANNAHME	☐	TB_DANNAHME_REPAY	DATUM	DATS	8	0	Acceptance Date of the Offer
80	DKUENDDG	☐	TB_DKUEND_REPAY	DATUM	DATS	8	0	Date of Receipt of Notice
81	SKUEND	☐	TB_SKUEND_REPAY	SKUEART	NUMC	3	0	Reason for Notice	TD04
82	RREJECT_REASON	☐	TB_REJECT_REASON	T_REASON	CHAR	3	0	Reason for Rejection	TDREPAY_REJECT
83	RREPAY_REASON	☐	TB_REPAY_REASON	SKUEART	NUMC	3	0	Payoff Reason	TD04
84	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
85	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
86	XCONDPAYDATA	☐	XCONDPAYDATA	XFELD	CHAR	1	0	Keep Payment Data for Condition-Based Flows Acc to Cond.
87	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
88	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
89	.INCLUDE	☐				0	0	SEPA Remittance Information
90	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
91	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
92	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
93	.INCLUDE	☐				0	0	Internal Data for Payoff
94	XNODUNN_OLD	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
95	JNODOIP_OLD	☐	TB_JNODOIP	XFELD	CHAR	1	0	Blocked by Payoff: No Open Item Clearing for Loan
96	DEFSZ_OLD	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
97	.INCLUDE	☐				0	0	Customer Data for Payoff
98	CHANGED	☐			CHAR	1	0
99	.INCLUDE	☐				0	0	Installment Loan-Specific Data for the Payoff
100	DFPOSPO	☐	TB_DFPOSPO	T_DFPOSPO	DATS	8	0	Date of Earliest Possible Payoff
101	MREQUESTOR	☐	TB_MREQUESTOR	T_MREQUESTOR	CHAR	10	0	Business Partner Requesting Payoff (BP Number)
102	MSTOPCODE	☐	TB_STOP	T_STOP	CHAR	3	0	Technical Key for Stop
103	MQUOTE	☐	TB_MQUOTE	T_MQUOTE	CHAR	1	0	Business Operation Is Payoff Quote Or Payoff
104	MCOM_STATUS	☐	TB_MCOM_STATUS	T_MCOM_STATUS	NUMC	3	0	Communication Status	TDREPAY_COMSTATU
105	DCOM_STATUS	☐	TB_DCOM_STATUS	T_DCOM_STATUS	DATS	8	0	Last Change to Communication Status
106	MREMITCODE	☐	TB_REMIT_CODE	CHAR4	CHAR	4	0	Remittance Code
107	AACCRUED	☐	TB_AACCRUED	T_AAMOUNT	CURR	13	2	Payments Accrued
108	APROJECTED	☐	TB_APROJECTED	T_AAMOUNT	CURR	13	2	Projected Payments
109	AINS_DEBIT	☐	TB_AINS_DEBIT	T_AAMOUNT	CURR	13	2	Insurance Receivables (Debit)
110	AINS_CREDIT	☐	TB_AINS_CREDIT	T_AAMOUNT	CURR	13	2	Insurance Credit Memos (Credit)
111	AINTDIEM	☐	TB_AINTDIEM	T_AAMOUNT	CURR	13	2	Interest per Day
112	MNOINS	☐	TB_NOINS	XFELD	CHAR	1	0	No Insurance Calculation
113	.INCLU--AP	☐				0	0	Fields for the Consumer Loan and for the Business Op. Notice
114	.INCLUDE	☐				0	0	Payoff Data in the Consumer Loan
115	LIFE_REPAY	☐	TB_LIFE_REPAY	DEC6	DEC	6	0	Current Total Term of the Loan in Months
116	OVERDUE_ITEMS	☐	TB_OVERDUE_ITEMS_REPAY	DEC6	DEC	6	0	Arrears of Contract Capital as a Percentage
117	FIRST_POS_NOTICE	☐	TB_FIRST_POS_NOTICE	DATE	DATS	8	0	Earliest Possible Notice Date
118	INTERIM_ACCOUNT	☐	TB_INTERIM_ACCOUNT	T_INTERIM_ACCOUNT	CHAR	10	0	Receivables Interim Account
119	ENFORCM_PAYM	☐	TB_ENFORCM_PAYM	BU_PARTNER	CHAR	10	0	Collector	*
120	STATI_OLD	☐	TB_NOTICE_STATI_OLD	STATI	NUMC	2	0	Contract Status Before Activation of Notice	*
121	DUNNING_DATE	☐	TB_DUNNING_DATE_REPAY	DATE	DATS	8	0	Date of Last Dunning Notice
122	DUNNING_LEVEL	☐	TB_DUNNING_LEVEL_REPAY	MAHNS	NUMC	1	0	Last Dunning Level
123	NO_INST_OLD	☐	TB_NO_INST_OLD		NUMC	3	0	Previous Total of Loan Installments
124	.INCLU--AP	☐				0	0	Credit Life Insurance Data
125	.INCLUDE	☐				0	0	Results for Recalculation of Credit Life Insurance
126	AREIMBURSEMENT	☐	TB_CLI_RECALC_CONTR	WERTV7	CURR	13	2	Credit Life Insurance Reimbursement
127	AINSURANCE_CONTR	☐	TB_CLI_INSURANCE	WERTV7	CURR	13	2	Single Premium for Credit Life Insurance
128	ADIFFERENCE	☐	TB_LOLIINBAL	WERTV7	CURR	13	2	Calculated Difference for Credit Life Insurance
129	ICONSIDER	☐	TB_ICONSIDER	XFELD	CHAR	1	0	Transfer CLI Difference
130	CALCULATION_DATE	☐	TB_CLI_CALCULATION_DATE	DATUM	DATS	8	0	CLI: Key Date for Calculation of Credit Life Insurance
131	UCLICURR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
132	CLI_FLOW_SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
133	CLI_CHANGED	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDREPAYMENT	MABER	T047M	MABER
2	VDREPAYMENT	MANDT	T000	MANDT	KEY	1	CN
3	VDREPAYMENT	MANSP	T040S	MANSP
4	VDREPAYMENT	MCOM_STATUS	TDREPAY_COMSTATU	MCOM_STATUS	KEY	1	CN
5	VDREPAYMENT	RREJECT_REASON	TDREPAY_REJECT	RREJECT_REASON	KEY	1	CN
6	VDREPAYMENT	RREPAY_REASON	TD04	SKUEND	KEY	1	CN
7	VDREPAYMENT	SBEWART	TZB0A	SBEWART	KEY	1	C
8	VDREPAYMENT	SBUST	TZB09	SBUST	KEY
9	VDREPAYMENT	SKOART	TZK01	SKOART
10	VDREPAYMENT	SKUEND	TD04	SKUEND	KEY	1	C
11	VDREPAYMENT	SZEGEN	TD21	SZEGEN	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in