SAP ABAP Table RFVI_UM_PERIODS (Structure For Managing Settlement Periods)

Hierarchy

☛

SAP_FIN (Software Component) SAP_FIN
⤷

RE-RT-SR (Application Component) Sales-Based Settlement
⤷

RESR (Package) RE: Sales-Based Rental Agreements And Settlements

Basic Data

Table Category	INTTAB	Structure
Structure	RFVI_UM_PERIODS	Table Relationship Diagram
Short Description	Structure For Managing Settlement Periods

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AGREEMENT	CL_RE_UM_AGREEMENT		REF	0	0
2	GRATING_FROM	REGRATINGFROM	DDAT	DATS	8	0	Grading/Tax Valid From
3	GRATING_TO	REGRATINGTO	DDAT	DATS	8	0	Grading/Tax Valid To
4	DAB_MISS_REP	REMISSINGDAB	DDAT	DATS	8	0	When Did Sales Reports Stop?
5	DVONPER	DVONPER	DATUM	DATS	8	0	Period start date
6	DBISPER	DBISPER	DATUM	DATS	8	0	Date of settlement period end
7	DATE_FACTOR	ANZ_MONATE	FLTP	FLTP	16	16	Number of months
8	SUM_BMELD	BMELD01	WRTV7	CURR	13	2	Reported sales
9	SUM_MENG_MELD	VVUBMELD	VVBGESWERT	QUAN	15	3	Reported Sales in Units
10	SUM_BMELD_REL	BMELD02	WRTV7	CURR	13	2	Relevant sales for settlement
11	SUM_UBMELD_REL	VVUBMELD02	VVBGESWERT	QUAN	15	3	Relevant sales in units for sales settlement
12	UMIETE	VVBUMVR	WRTV7	CURR	13	2	Sales settlement amount
13	UMIETETAX	VVBUMVRT	WRTV7	CURR	13	2	Sales Settlement Amount Including Tax
14	UMIETE_UMIN	RESRRSMIN	WRTV7	CURR	13	2	Sales-Based Rent Based On Minimum Sales
15	UMIETETAX_UMIN	RESRRSMINT	WRTV7	CURR	13	2	Sales-Based Rent With Tax Based On Minimum Sales
16	UMIETE_UMAX	RESRRSMAX	WRTV7	CURR	13	2	Sales-Based Rent Based On Maximum Sales
17	UMIETETAX_UMAX	RESRRSMAXT	WRTV7	CURR	13	2	Sales-Based Rent With Tax Based On Maximum Sales
18	UMIETE_CMP	RESRRSCMP	WRTV7	CURR	13	2	Resulting Sales-Based Rent
19	UMIETETAX_CMP	RESRRSCMPT	WRTV7	CURR	13	2	Resulting Sales-Based Rent Including Tax
20	SBEWART	VVSBEWART1	SBEWART	CHAR	4	0	Flow Type 1 (Debit/Credit)	*
21	S_VZZKOPO	VZZKOPO		STRU	0	0
22	MANDT	MANDT	MANDT	CLNT	3	0	Client
23	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code
24	SANLF	SANLF	VVSANLF	NUMC	3	0	Product Category
25	RKEY1	RKEY1	RKEY1	CHAR	13	0	Key part 1
26	RKEY2	RKEY2	RKEY2	CHAR	8	0	Key part 2
27	RKEY3	RKEY3	RKEY3	CHAR	8	0	Key part 3
28	DGUEL_KK	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
29	NLFD_ANG	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
30	SKOART	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)
31	DGUEL_KP	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
32	NSTUFE	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
33	SSTATI	SSTATI	STATI	NUMC	2	0	Status of data record
34	PKOND	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
35	BKOND	BKOND	WERTV7	CURR	13	2	Condition item currency amount
36	SWHRKOND	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item
37	SBASIS	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference
38	SZSREF	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate
39	SZSREFVZ	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
40	PFLUCT	TFM_PFLUCT	DECV3_7	DEC	10	7	Fluctuation margin
41	AMMRHY	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
42	ATTRHY	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
43	SZAWS	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
44	RDIVNR	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
45	JNULLKON	JNULLKON	SKONDF	CHAR	1	0	Condition Form
46	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
47	JBMONAT	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
48	DVALUT	DVALUT	DATUM	DATS	8	0	Calculation Date
49	DFAELL	DFAELL	DATUM	DATS	8	0	Due date
50	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number
51	ZLSCH	DZLSCH	ZLSCH	CHAR	1	0	Payment method
52	BVTYP	BVTYP	BVTYP	CHAR	4	0	Partner bank type
53	MABER	MABER	MABER	CHAR	2	0	Dunning Area
54	SPARTNR	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number
55	RKONT	RKONT	RKONT	NUMC	6	0	Quota number
56	SVULT	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
57	SFULT	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
58	SVKALRI	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
59	SFKALRI	VVSFKALRI	XFELD	CHAR	1	0	Calculation of periods with flexible valid-to date?
60	AVGSTAGE	AVGSTAGE	NUMC2	NUMC	2	0	Number of working days for value date
61	AFGSTAGE	AFGSTAGE	NUMC2	NUMC	2	0	Number of working days to due date
62	SVKALZUS	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
63	SFKALZUS	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
64	SKALID	SKALID	WFCID	CHAR	2	0	Factory calendar
65	SZBMETH	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
66	JSOFVERR	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
67	DALLGEM	DALLGEM	DATUM	DATS	8	0	General date
68	SZEGEN	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately
69	SBUST	VVSBUST	VVSBUST	NUMC	2	0	Posting control key
70	SKOPO	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items
71	SALTKOND	VVSALTKOND	SKONDGRP	NUMC	4	0	Bracket condition for alternative conditions
72	SZINSANP	VVSZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
73	SINCL	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
74	SFORMREF	VVSFORMREF	T_FORMBE	CHAR	4	0	Formula reference for the cash flow calculator
75	SVARNAME	VVSVARNAME	T_XFELD04	CHAR	4	0	Description of variables in cash flow calculator
76	SVWERK	VVSVWERK	T_SWERK	NUMC	1	0	Shift calculation date to working day
77	SVMETH	VVSVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
78	SFWERK	VVSFWERK	T_SWERK	NUMC	1	0	Shift due date to working day
79	SFMETH	VVSFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
80	DPKOND	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
81	AZGSTAGE	AZGSTAGE	NUMC2	NUMC	2	0	Number of working days for interest fixing
82	SZKALRI	SZKALRI	SKALRI	CHAR	1	0	Calendar direction for interest rate fixing
83	DZSREF	VVDZSREF	DATUM	DATS	8	0	Date fixing for benchmark interest rate in cash flow
84	SKALID2	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)
85	JGESUCHT	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
86	KURS1	KURSF	KURSF	DEC	9	5	Exchange rate
87	BBASIS	BBASIS	WERTV7	CURR	13	2	Calculation base amount
88	SZWERK	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
89	SFINCL	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
90	SRUNDVORF	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
91	SZWKEY	VVSZWKEY	VVSZWKEY	CHAR	2	0	Payment form with adjustment days
92	SFVMETH	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
93	SDWERK	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
94	SBERECH	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
95	JPROZR	TB_JPROZR	XFELD	CHAR	1	0	Percentage Calculation
96	SZEITANT	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
97	SFANT	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
98	SFRANZ	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
99	KBKOND	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
100	SBASFIX	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
101	MANSP	MANSP	MANSP	CHAR	1	0	Dunning block
102	ZAHLS	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key
103	BKONDQM	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
104	JAREA	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
105	SFLART	SFLART	SFLART	NUMC	4	0	Area type
106	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
107	AVGSTAGEVZ	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
108	AFGSTAGEVZ	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
109	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
110	JEXPOZINS	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
111	KOSTL	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract
112	GFZLSCH	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos
113	ZLSPR	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key
114	SROUND	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
115	SKALIDWT	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar
116	BMWST	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
117	XCROSS	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
118	PPAYMENT	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
119	AMMRHYZV	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
120	PKOND2	PKOND2	DECV5_10	DEC	15	10	Percentage Rate for Condition Items
121	.INCLU--AP				0	0	APPEND FOR MANDATE FIELD
122	MNDID	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
123	.INCLU--AP				0	0	Append VZZKOPO for Loans
124	RBO	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
125	STECH_COND	TB_STECH_COND		CHAR	1	0	Indicator for Technical Program Condition
126	SEXCLGUEL	TFMSEXCLKP	VVSEXCLVON	NUMC	1	0	Exclusive indicator for start date of condition position
127	SULTGUEL	TFMSULT_KP	VVSULT	CHAR	1	0	Month-end indicator for start date of condition position
128	A_AMTMIN	TB_FICO_AAMTMIN	T_CML_AMOUNT_STANDARD	CURR	13	2	Minimum Amount
129	A_AMTMAX	TB_FICO_AAMTMAX	T_CML_AMOUNT_STANDARD	CURR	13	2	Maximum Amount
130	SSCHMETH	TB_SSCHMETH	T_SSCHMETH	CHAR	1	0	Calculation Method for Auto Debit Amount
131	BAUDAMNT	TB_BAUDAMNT	WERTV7	CURR	13	2	Amount
132	.INCLU--AP				0	0	APPEND for Consumer Loan
133	A_PAYDAY	TB_MODEL_PAYDAY	T_VIEW_DAY_OF_PAYMENT	NUMC	2	0	Model Calculation: Day of Installment Payment (1-31)
134	RCO	TB_MODEL_RCO	RBO	CHAR	15	0	Bus. Operation No. (Installment Plan Change: Consumer Loan)
135	.INCLU--AP				0	0	Append for Localization
136	BROUNDUNIT	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
137	BBASISUNIT	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
138	S_VIMIUH	VIMIUH		STRU	0	0
139	MANDT	MANDT	MANDT	CLNT	3	0	Client
140	INTRENO	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
141	SKOART	VVSKOART	SKOART	NUMC	4	0	Condition: Type
142	DGUELTIG	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
143	BUMSPROJ	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
144	BMINUMS	VVMINMIET	WRTV7	CURR	13	2	Minimum rent for sales-based rental agrmnts
145	AMELDIN	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
146	PPROZ0	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
147	NETTO_KZ	NETTO_KZ	JFLAGG	CHAR	1	0	Sales figures are net amounts
148	MMINUMS	MMINUMS	WRTV7	CURR	13	2	Minimum sales in reporting interval
149	GESUMSATZ	VVGESUMS	JFLAGG	CHAR	1	0	Sales amounts refer to contract validity period
150	ABRVAR	ABRVAR	ABRVAR	CHAR	4	0	Settlement variant
151	UEINHEIT	VVUMSEINH	MEINS	UNIT	3	0	Unit of measurement of sales reporting values
152	UMINUMS	VVUMINUMS	VVBGESWERT	QUAN	15	3	Minimum sales in reporting interval in units
153	UPLANUMS	VVUPLANUMS	VVBGESWERT	QUAN	15	3	Planned sales in units
154	SUMSABGRVERF	VVSUMSABGRVERF	VVSUMSABGRVERF	CHAR	1	0	Procedure used to accrue/defer sales-based rent agreement
155	PPROZ2	PPROZ2	DEC3_2	DEC	5	2	Maximum percentage rate
156	BMAXUMS	VVMAXMIET	WRTV7	CURR	13	2	Maximum rent for sales-based lease-outs
157	JEXACT_DAY	REJEXACT_DAY	XFELD	CHAR	1	0	Basis of minimum rent distribution in days or months
158	BMELD_MIN	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
159	BMELD_MAX	BUMSATZ2	WRTV7	CURR	13	2	Maximum sales in the settlement period
160	UBMELD_MIN	REMINUE	VVBGESWERT	QUAN	15	3	Minimum Sales (in Units) in Settlement Period
161	UBMELD_MAX	REMAXUE	VVBGESWERT	QUAN	15	3	Maximum Sales (in Units) in Settlement Period
162	S_RESTRICTION	RESRESTRIC	VVSZEITMV	NUMC	1	0	Partial Settlement Indicator
163	S_XVIMIUH	RFVI_UM_XVIMIUH		STRU	0	0
164	S_VIMIUH	VIMIUH		STRU	0	0
165	MANDT	MANDT	MANDT	CLNT	3	0	Client
166	INTRENO	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
167	SKOART	VVSKOART	SKOART	NUMC	4	0	Condition: Type
168	DGUELTIG	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
169	BUMSPROJ	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
170	BMINUMS	VVMINMIET	WRTV7	CURR	13	2	Minimum rent for sales-based rental agrmnts
171	AMELDIN	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
172	PPROZ0	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
173	NETTO_KZ	NETTO_KZ	JFLAGG	CHAR	1	0	Sales figures are net amounts
174	MMINUMS	MMINUMS	WRTV7	CURR	13	2	Minimum sales in reporting interval
175	GESUMSATZ	VVGESUMS	JFLAGG	CHAR	1	0	Sales amounts refer to contract validity period
176	ABRVAR	ABRVAR	ABRVAR	CHAR	4	0	Settlement variant
177	UEINHEIT	VVUMSEINH	MEINS	UNIT	3	0	Unit of measurement of sales reporting values
178	UMINUMS	VVUMINUMS	VVBGESWERT	QUAN	15	3	Minimum sales in reporting interval in units
179	UPLANUMS	VVUPLANUMS	VVBGESWERT	QUAN	15	3	Planned sales in units
180	SUMSABGRVERF	VVSUMSABGRVERF	VVSUMSABGRVERF	CHAR	1	0	Procedure used to accrue/defer sales-based rent agreement
181	PPROZ2	PPROZ2	DEC3_2	DEC	5	2	Maximum percentage rate
182	BMAXUMS	VVMAXMIET	WRTV7	CURR	13	2	Maximum rent for sales-based lease-outs
183	JEXACT_DAY	REJEXACT_DAY	XFELD	CHAR	1	0	Basis of minimum rent distribution in days or months
184	BMELD_MIN	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
185	BMELD_MAX	BUMSATZ2	WRTV7	CURR	13	2	Maximum sales in the settlement period
186	UBMELD_MIN	REMINUE	VVBGESWERT	QUAN	15	3	Minimum Sales (in Units) in Settlement Period
187	UBMELD_MAX	REMAXUE	VVBGESWERT	QUAN	15	3	Maximum Sales (in Units) in Settlement Period
188	S_RESTRICTION	RESRESTRIC	VVSZEITMV	NUMC	1	0	Partial Settlement Indicator
189	BIS	SYDATUM	SYDATS	DATS	8	0	System Date
190	JCHG_NEW_VIMIUH	REJCHGNEWVIMIUH	XFELD	CHAR	1	0	New Sales Grading In Period
191	FLG_FROM_DB	XFELD	XFELD	CHAR	1	0	Checkbox
192	ORG_DGUELTIG	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
193	FLG_LAST	XFELD	XFELD	CHAR	1	0	Checkbox
194	FLG_FIRST	XFELD	XFELD	CHAR	1	0	Checkbox
195	FLG_NEW_INTERVAL	XFELD	XFELD	CHAR	1	0	Checkbox
196	OLD_INTERVAL_FROM	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
197	FLG_NEW_SETTLVAR	XFELD	XFELD	CHAR	1	0	Checkbox
198	OLD_SETTLVAR_FROM	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
199	S_SKOART	RFVI_UM_SKOART		STRU	0	0
200	SKOART	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)
201	XKOARTM	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
202	SALDO_BETR	VVUVSALDO	WRTV7	CURR	13	2	Sales settlement balance
203	MWSAL_BETR	VVUVMWSAL	WRTV7	CURR	13	2	Sales settlement balance incl. tax
204	DMBTR	VVGELVZ	WERT7	CURR	13	2	Amount of advance payments made for SCS
205	MWSTS	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
206	JCHG_NEW_TAX	REJCHGNEWTAX	XFELD	CHAR	1	0	New Sales Tax in Period
207	JCHG_NEW_VIMIUH	REJCHGNEWVIMIUH	XFELD	CHAR	1	0	New Sales Grading In Period
208	JCHG_SETTLED	REJSETTLED	XFELD	CHAR	1	0	The Period Is Already Settled
209	ERROR	REUMERR	XFELD	CHAR	1	0	Error In Sales-Based Rent Calculation
210	INFO4CALC	CHAR15	CHAR15	CHAR	15	0	Char 15
211	FLG_RESTRICTION	XFELD	XFELD	CHAR	1	0	Checkbox