SAP ABAP Table RFZUA_SORT_NO_DATE_VDREPAYMENT (Sort Fields for Automatic Postprocess. and VDREPAYMENT Entry)

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	RFZUA_SORT_NO_DATE_VDREPAYMENT	Table Relationship Diagram
Short Description	Sort Fields for Automatic Postprocess. and VDREPAYMENT Entry

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

History

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