SAP ABAP Table RFVI_UM_INFO4AGREEMENT (All Important Fields For A Rental Lease-Out)

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_INFO4AGREEMENT	Table Relationship Diagram
Short Description	All Important Fields For A Rental Lease-Out

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	AGREEMENT	☐	CL_RE_UM_AGREEMENT		REF	0	0
2	S_VIOB01	☐	VIOB01		STRU	0	0
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number
6	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
7	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district
8	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity
9	XWETEXT	☐	XWETEXT	XMBEZ	CHAR	30	0	Business entity identification
10	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number
11	RKZBEST	☐	RKZBEST	RKZBEST	CHAR	1	0	Object status
12	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object
13	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment
14	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
15	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
16	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit
17	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume
18	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
19	NUMKIGR	☐	NUMKIGR	NUMKIGR	NUMC	8	0	Internal number range for property
20	NUMKIGE	☐	NUMKIGE	NUMKIGE	NUMC	8	0	Building internal number range
21	NUMKIME	☐	NUMKIME	SMENR	CHAR	8	0	Internal number range for rental unit
22	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
23	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
24	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
25	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
26	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
27	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
28	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
29	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
30	SMIETR	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law
31	VORBK	☐	VORBK	ABRVAR	CHAR	4	0	Predefined operating costs settlement variant
32	VORHK	☐	VORHK	ABRVAR	CHAR	4	0	Predefined heating expenses settlement variant
33	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
34	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number
35	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
36	VVLEN	☐	VVLEN	MEINS	UNIT	3	0	Unit of length
37	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
38	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
39	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
40	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
41	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)
42	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location
43	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs
44	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area
45	PROFIL	☐	VVPROFIL	VVPROFIL	CHAR	7	0	Planning profile for Real Estate objects
46	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
47	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
48	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
49	XNOTPL	☐	VVXNOTPL	XFELD	CHAR	1	0	No automatic creation of functional location allowed
50	.INCLUDE	☐				0	0
51	.INCLU--AP	☐				0	0	WEG-Verwaltung: Steuerungskennzeichen
52	HOCONTR	☐	REHOCONTR	XFELD	CHAR	1	0	WEG-Verwaltung: Wirtschaftseinheit ist WEG verwaltet
53	.INCLU--AP	☐				0	0	OBSOLETE: Business Entity: Append Fields
54	.INCLUDE	☐				0	0	OBSOLETE: Business Entity: Append Fields
55	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
56	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
57	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
58	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
59	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible
60	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization
61	S_VIMI01	☐	VIMI01		STRU	0	0
62	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
63	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
64	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number
65	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit
66	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE
67	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number
68	SGEBSWENR	☐	SGEBSWENR	SWENR	CHAR	8	0	BE no.of rental unit to which the RU is linked
69	SGEBSMENR	☐	SGEBSMENR	SMENR	CHAR	8	0	RU no. of rental unit to which the RU is linked
70	SHEIZNR	☐	SHEIZNR	SHEIZNR	NUMC	4	0	Real Estate heating system number
71	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type
72	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
73	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
74	UMBRAUM	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
75	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
76	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
77	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
78	SBELART	☐	SBELA	SBELA	NUMC	1	0	Occupancy type indicator
79	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
80	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
81	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
82	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building
83	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number
84	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category
85	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class
86	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
87	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
88	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
89	DBEGEH	☐	DBEGEH	DDAT	DATS	8	0	Date of last RU inspection
90	XBEGEH	☐	XBEGEH	XKBEZ	CHAR	15	0	Inspected by
91	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
92	PZUABSP	☐	PZUABSP	PZUABSP	DEC	4	2	Surcharge or reduction for representative list of rents
93	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
94	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase
95	DBINDBIS	☐	DBINDBIS	DATUM	DATS	8	0	Obligation period until
96	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
97	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key
98	RLIFT	☐	RLIFT	RLIFT	NUMC	2	0	Type of elevator installation
99	RMEDIEN	☐	RMEDIEN	RMEDIEN	NUMC	3	0	Media reception
100	RWASSER	☐	RWASSER	RWASSER	NUMC	2	0	Type of water mains connection
101	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor
102	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
103	SADRME	☐	SADRME	SOBJNR	NUMC	10	0	Object number of rental unit for address purposes
104	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number
105	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
106	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
107	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
108	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
109	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
110	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
111	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
112	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
113	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
114	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
115	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
116	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
117	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
118	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
119	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs
120	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area
121	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor
122	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
123	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
124	DFSTRBIS	☐	VVDFSTRBIS	DATUM	DATS	8	0	Date up to when the rental unit cash flow is created
125	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU
126	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
127	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
128	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
129	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
130	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
131	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
132	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
133	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit
134	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index
135	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
136	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
137	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
138	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
139	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination
140	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
141	SPOSINMSP	☐	VVSPOSINMSP	VVSADJBASE	CHAR	1	0	Base value for grouping RU in RLR group
142	PPOSINMSP	☐	VVPPOSINMSP	DECV3_2	DEC	5	2	Percentage value for grouping RU in RLR category group
143	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
144	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
145	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number
146	PAUSFW	☐	VVPAUSFW	DEC3_2	DEC	5	2	Service charge stt. apport.loss risk percentage surcharge
147	RESADXEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
148	RESADJINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
149	REFANG	☐	VVREFANG	RANL	CHAR	13	0	Reference offer
150	.INCLUDE	☐				0	0
151	.INCLU--AP	☐				0	0	OBSOLETE: Rental Object Append Fields
152	.INCLUDE	☐				0	0	OBSOLETE: Rental Object Append Fields
153	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
154	ROTYPEEX	☐	REBDROTYPEEX	REBDROTYPEEX	CHAR	1	0	OBSOLETE: Type of Rental Object (External)
155	FLID	☐	REBDALTROID	REBDALTROID	CHAR	13	0	OBSOLETE: Alternative ID for Rental Object (from CRE)
156	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
157	FIRSTPOSTING	☐	REBDFIRSTPOSTING	RECADATE	DATS	8	0	Obsolete: Date of First Posting
158	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
159	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
160	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
161	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
162	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible
163	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization
164	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
165	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
166	S_SKOART	☐	RFVI_UM_SKOART		STRU	0	0
167	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)
168	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
169	S_VIMIUH	☐	VIMIUH		STRU	0	0
170	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
171	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
172	SKOART	☐	VVSKOART	SKOART	NUMC	4	0	Condition: Type
173	DGUELTIG	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
174	BUMSPROJ	☐	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
175	BMINUMS	☐	VVMINMIET	WRTV7	CURR	13	2	Minimum rent for sales-based rental agrmnts
176	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
177	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
178	NETTO_KZ	☐	NETTO_KZ	JFLAGG	CHAR	1	0	Sales figures are net amounts
179	MMINUMS	☐	MMINUMS	WRTV7	CURR	13	2	Minimum sales in reporting interval
180	GESUMSATZ	☐	VVGESUMS	JFLAGG	CHAR	1	0	Sales amounts refer to contract validity period
181	ABRVAR	☐	ABRVAR	ABRVAR	CHAR	4	0	Settlement variant
182	UEINHEIT	☐	VVUMSEINH	MEINS	UNIT	3	0	Unit of measurement of sales reporting values
183	UMINUMS	☐	VVUMINUMS	VVBGESWERT	QUAN	15	3	Minimum sales in reporting interval in units
184	UPLANUMS	☐	VVUPLANUMS	VVBGESWERT	QUAN	15	3	Planned sales in units
185	SUMSABGRVERF	☐	VVSUMSABGRVERF	VVSUMSABGRVERF	CHAR	1	0	Procedure used to accrue/defer sales-based rent agreement
186	PPROZ2	☐	PPROZ2	DEC3_2	DEC	5	2	Maximum percentage rate
187	BMAXUMS	☐	VVMAXMIET	WRTV7	CURR	13	2	Maximum rent for sales-based lease-outs
188	JEXACT_DAY	☐	REJEXACT_DAY	XFELD	CHAR	1	0	Basis of minimum rent distribution in days or months
189	BMELD_MIN	☐	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
190	BMELD_MAX	☐	BUMSATZ2	WRTV7	CURR	13	2	Maximum sales in the settlement period
191	UBMELD_MIN	☐	REMINUE	VVBGESWERT	QUAN	15	3	Minimum Sales (in Units) in Settlement Period
192	UBMELD_MAX	☐	REMAXUE	VVBGESWERT	QUAN	15	3	Maximum Sales (in Units) in Settlement Period
193	S_RESTRICTION	☐	RESRESTRIC	VVSZEITMV	NUMC	1	0	Partial Settlement Indicator
194	DMELDV	☐	SYDATUM	SYDATS	DATS	8	0	System Date
195	DMELDB	☐	SYDATUM	SYDATS	DATS	8	0	System Date
196	LINES_OF_TABLE	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
197	ERR	☐	XFELD	XFELD	CHAR	1	0	Checkbox

History

Last changed by/on	SAP	20130529
SAP Release Created in