SAP ABAP Table RFVIMAFCITEM (RE: Rent Adj. - Structure for ALV List for Rent Forecast)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ FVVICNZ (Package) Applic.Dev. R/3 Real Estate - Gen.Contract - Enhancements

Basic Data

Table Category	INTTAB	Structure
Structure	RFVIMAFCITEM	Table Relationship Diagram
Short Description	RE: Rent Adj. - Structure for ALV List for Rent Forecast

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	SBUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	SRECNNR	☑	REMAFCXRECNNR	REMAFCXRECNNR	CHAR	50	0	Display Field for Contract ID and Description Text
3	SSKOART	☑	REMAFCXSKOART	REMAFCXSKOART	CHAR	30	0	Display Field for Condition ID and Description Text
4	SDANPASS	☑	DANPASS	DATUM	DATS	8	0	Rental Adjustment Date Planned For
5	SDGUELAB	☑	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
6	.INCLUDE	☐				0	0	RE: Records of a Rent Adjustment Run
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
10	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
12	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
13	DGUELAB	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
14	DANPASS	☐	DANPASS	DATUM	DATS	8	0	Rental Adjustment Date Planned For
15	SANPNR	☐	SANPNR	SANPNR	NUMC	3	0	Rent Adjustment Method	TIV11
16	XIDENT	☐	XIDENT1	XBLNR1	CHAR	16	0	Identification of adjustment run
17	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
18	BKONDALT	☐	BKONDALT	WRTV7	CURR	13	2	Previous condition amount
19	BANPASS	☐	BANPASS	WRTV7	CURR	13	2	New condition amount (total)
20	BAUTANP	☐	BAUTANP	WRTV7	CURR	13	2	New Total Condition Amount (Original)
21	BGESZUL	☐	BGESZUL	WRTV7	CURR	13	2	New legally permitted amount per area unit
22	BVGLAVG	☐	BVGLAVG	WRTV7	CURR	13	2	Average rent per area unit
23	BINDPKT	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
24	BINDALT	☐	BINDALT	DEC5_3	DEC	8	3	Previous index marker (from VIMI06)
25	BMSPVON	☐	BBETRV	WRTV6	CURR	11	2	Lower limit for rent per area unit acc. to rep.list of rents
26	BMSPBIS	☐	BBETRB	WRTV6	CURR	11	2	Upper limit for rent per area unit acc. to rep.list rents
27	BMSPGRD	☐	BGRBTR	WRTV6	CURR	11	2	Mean value of rent per area unit acc. to rep.list of rents
28	BMSPZUA	☐	BMSPZUA	WRTV7	CURR	13	2	Rent adj.acc.to rep.rent list: Total surch./reduct./tot.pnts
29	JZUSCHLAG	☐	JZUSCHLAG	JANE	CHAR	1	0	Surcharge contained in new basic rent
30	JZUSTIM	☐	JZUSTIM	JANE	CHAR	1	0	Approval indicator
31	DZUSTIM	☐	DZUSTIM	DDAT	DATS	8	0	Approval date of rent adjustment
32	DZUBIS	☐	DZUBIS	DDAT	DATS	8	0	Date up to which approval has to be given
33	DSTORNO	☐	DSTORNO	DDAT	DATS	8	0	Reversal date of rent adjustment
34	DAKTIV	☐	VVDAKTIV	DDAT	DATS	8	0	Activation date of rental adjustment
35	DGUELBI	☐	VVDINDPKT	DATUM	DATS	8	0	Date when index markers are valid for this rent adjustment
36	BANPBM	☐	VVBANPBM	WRTV7	CURR	13	2	Total pro rata modernization costs for the rental unit
37	BMZUGBM	☐	VVBMZUGBM	WRTV7	CURR	13	2	Monthly surcharge planned in acc. with German tenancy law
38	RANTWF	☐	VVRANTWF	DEC6_2	DEC	8	2	Apportionment factor calculation units
39	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
40	PERHREL	☐	PERHREL	DECV3_2	DEC	5	2	Relative increase in amount (in percentage)
41	BERHABS	☐	BERHABS	WRTV7	CURR	13	2	Increase amount per area unit
42	BERHGES	☐	VVBERHGES	WRTV7	CURR	13	2	Increase amount in full (not referring to the area)
43	BNEUMIET	☐	VVBNEUGES	WRTV7	CURR	13	2	Total new amount (not relative to the area)
44	SFUTANP	☐	VVSFUTANP	VVSFUTANP	CHAR	1	0	Subsequent adjustment ? (No, initial adj., subsequent adj.)
45	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
46	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
47	BPKTSUM	☐	VVBPKTSUM	VVDECV5_2	DEC	7	2	Total number of points for feature class or object
48	PERHPROZ	☐	VVPERWEIT	DEC3_2	DEC	5	2	Percentage rate of calculated increase to be passed on
49	PERHHPZS	☐	VVPERHHPZS	DECV3_3	DEC	6	3	Percent.increase on the basis of a mortg.rate loan change
50	PERHUTBK	☐	VVPERHUTBK	DECV3_3	DEC	6	3	Percent.incr. on basis of maintenance/operating costs change
51	PERHTEUR	☐	VVPERHTEUR	DECV3_3	DEC	6	3	Percent.incr.on basis of change in standard of living index
52	PERHGES	☐	VVPERHGES	DECV3_3	DEC	6	3	Percent increase on basis of all relative/an absolute factor
53	SANPME	☐	VVSANPME	VVSANPME	CHAR	1	0	Specifies Adjustment Object (Only LO/Only RU/both)
54	DHPZS	☐	VVDHPZS	DATUM	DATS	8	0	CH rent adj.:Date of mortgage rate loan status for new rent
55	DUTBK	☐	VVDUTBK	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.csts index status for new rent
56	DTEUR	☐	VVDTEUR	DATUM	DATS	8	0	CH rent adj.:Date of standard of living status for new rent
57	DHPZSALT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
58	DUTBKALT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
59	DTEURALT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
60	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
61	SBSANPCH	☐	VVSBSANPCH	VVSBSANPCH	NUMC	2	0	CH rent adjustment: Adjustment basis
62	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
63	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
64	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
65	MFACH	☐	VVMFACH	CHAR10	CHAR	10	0	Rent table field
66	SANPSTAF	☐	VVSANPSTAF	VVSANPSTAF	CHAR	1	0	Scope of adjustment (conditions, sales grading, both)
67	SIHMA	☐	VVSIHMA	VVSIHMA	CHAR	20	0	Modernization Measure	*
68	JCHBASMOD	☐	VVCHBASMOD	XFELD	CHAR	1	0	CH rent adj: Adj. on basis overhaul/appr.surch. investment
69	JCHBASBMR	☐	VVCHBASBMR	XFELD	CHAR	1	0	Rent adj. CH: Adj. on basis reserves from modernizations
70	BCHBASMOD	☐	VVBGESBMI	WRTV7	CURR	13	2	Actual total costs of modernization
71	BMSPBAS	☐	VVBMSPBAS	WRTV6	CURR	11	2	Base rent per area unit acc. to rep.list of rents
72	BNEUABS	☐	VVBNEUFE	WRTV7	CURR	13	2	New amount per area unit
73	NDOCCNT	☐	VVNDOCCNT	NUMC3	NUMC	3	0	Number of printed letters for an adjustment
74	CURR_GS	☐	VVCURR_GS	WRTV7	CURR	13	2	Total amount as basis for adjustment without roundings
75	AREA_GS	☐	VVAREA_GS	VVBFLART	QUAN	14	4	Total area as base for adjustment without rounding errors
76	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
77	SBAUAKL	☐	SBAUALT	SBAUALT	NUMC	2	0	Building age category	TIV21
78	SLAGEKL	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
79	SGROEKL	☐	SGROEKL	SGROEKL	NUMC	3	0	Size class	TIV19
80	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
81	DBAUALT	☐	VVDBAUALT	DATE	DATS	8	0	Building age for rental unit relevant for rep.list of rents
82	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
83	BKONDALTFE	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
84	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
85	SCOMMIT	☐	VVSRACOMMIT	NUMC02	NUMC	2	0	Reservation for approval for a rent adjustment	TIVM4
86	SREJECT	☐	VVSRAREJECT	NUM02	NUMC	2	0	Reason for rejecting a rent adjustment	TIVM5
87	DREJECT	☐	VVDRAREJECT	DDAT	DATS	8	0	Rejection date of a rent adjustment
88	NDUNLEV	☐	VVRADUNLEVEL	NUMC02	NUMC	2	0	Reminder level for reminders for rnt adjs not subj.to appr.
89	DLASTDC	☐	VVRADLASTDUN	DATUM	DATS	8	0	Date of last dunning due to missing tenant approval
90	DADJPRN	☐	VVDADJPRN	DATS	DATS	8	0	Letter date of adjustment correspondence
91	BANPASSFE	☐	VVBANPASSFE	WRTV7	CURR	13	2	New condition amount for each area unit (changeable)
92	BAUTANPFE	☐	VVBAUTANPFE	WRTV7	CURR	13	2	New condition amount for each area unit (original)
93	BVGLAVGGS	☐	VVBAVGGSMT	WRTV7	CURR	13	2	Average total rent
94	BGESZULGS	☐	VVBGESZULGS	WRTV7	CURR	13	2	Legally permitted total amount
95	SINDART_OLD	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
96	YBASISJ_OLD	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
97	BINDPKT_OLD	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
98	BINDPKT1_OLD	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
99	BPKTERH_OLD	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
100	PPKTERH_OLD	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
101	SINDART_NEW	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
102	YBASISJ_NEW	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
103	BINDPKT_NEW	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
104	BINDPKT1_NEW	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
105	BPKTERH_NEW	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
106	PPKTERH_NEW	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
107	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
108	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
109	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
110	JADJRHY	☐	JADJRHY	JANE	CHAR	1	0	Rent Adjustment Dependent on Condition Frequency
111	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
112	JMODIF	☐	REMAFCJMODIF	FLAG	CHAR	1	0	Amount Calculated By System Was Manually Changed
113	DGUELAB2	☐	REMAFCDGUELAB2	DATE	DATS	8	0	Date That Adjustment Comes Into Force (Manually Changeable)
114	PDELTAREL	☐	REMAFCDELTAREL	REMAFCDELTAREL	DEC	16	8	Relative Index Change in Percent (High Level of Accuracy)
115	SIXSERIES	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
116	YIXBSYEAR	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
117	DGABANRT	☐	VVDGABANRT	DATUM	DATS	8	0	Date as from when the adjustment type is valid
118	JBACKWARD	☐	RECNADJTRUECK	XFELD	CHAR	1	0	Retroactive adjustment possible

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFVIMAFCITEM	BUKRS	T001	BUKRS	KEY	1	CN
2	RFVIMAFCITEM	FEINS	T006	MSEHI
3	RFVIMAFCITEM	MANDT	T000	MANDT	KEY	1	CN
4	RFVIMAFCITEM	SANPNR	TIV11	SANPNR	KEY	1	CN
5	RFVIMAFCITEM	SAUSTKL	TIV23	SMKLASS	KEY	1	CN
6	RFVIMAFCITEM	SBAUAKL	TIV21	SBAUALT	KEY	1	CN
7	RFVIMAFCITEM	SCOMMIT	TIVM4	SCOMMIT	KEY	1	CN
8	RFVIMAFCITEM	SGROEKL	TIV19	SGROEKL	KEY	1	CN
9	RFVIMAFCITEM	SKOART	TZK01	SKOART	KEY	1	CN
10	RFVIMAFCITEM	SKOPO	TZK07	SKOPO	KEY	1	CN
11	RFVIMAFCITEM	SLAGEKL	TIV22	SLAGK	KEY	1	CN
12	RFVIMAFCITEM	SMENR	VIMI01	SMENR	KEY	1	CN
13	RFVIMAFCITEM	SMIETSP	TIV20	SMIETSP	KEY	1	CN
14	RFVIMAFCITEM	SREJECT	TIVM5	SREJECT	KEY	1	CN
15	RFVIMAFCITEM	SSTDORT	TIV35	SSTDORT	KEY	1	CN
16	RFVIMAFCITEM	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in