SAP ABAP Table RSORT_AND_VDREPAYMENT (Sort Fields and Payoffs)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-AC-RPM (Application Component) Receivables/Payment Management
     ⤷ FVVCL_PAYMENT (Package) Payment Transactions for Consumer Loans

Basic Data

Table Category	INTTAB	Structure
Structure	RSORT_AND_VDREPAYMENT	Table Relationship Diagram
Short Description	Sort Fields and Payoffs

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	600