SAP ABAP Table VIMI16 (RE: Records of a Rent Adjustment Run)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIMI16	Table Relationship Diagram
Short Description	RE: Records of a Rent Adjustment Run

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in