SAP ABAP Table VIMI16_ZUS (RE: Rent Adj - Adjustment Run Items and Additional Fields)

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	INTTAB	Structure
Structure	VIMI16_ZUS	Table Relationship Diagram
Short Description	RE: Rent Adj - Adjustment Run Items and Additional Fields

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	RE: Records of a Rent Adjustment Run
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
7	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
8	DGUELAB	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
9	DANPASS	☐	DANPASS	DATUM	DATS	8	0	Rental Adjustment Date Planned For
10	SANPNR	☐	SANPNR	SANPNR	NUMC	3	0	Rent Adjustment Method	TIV11
11	XIDENT	☐	XIDENT1	XBLNR1	CHAR	16	0	Identification of adjustment run
12	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
13	BKONDALT	☐	BKONDALT	WRTV7	CURR	13	2	Previous condition amount
14	BANPASS	☐	BANPASS	WRTV7	CURR	13	2	New condition amount (total)
15	BAUTANP	☐	BAUTANP	WRTV7	CURR	13	2	New Total Condition Amount (Original)
16	BGESZUL	☐	BGESZUL	WRTV7	CURR	13	2	New legally permitted amount per area unit
17	BVGLAVG	☐	BVGLAVG	WRTV7	CURR	13	2	Average rent per area unit
18	BINDPKT	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
19	BINDALT	☐	BINDALT	DEC5_3	DEC	8	3	Previous index marker (from VIMI06)
20	BMSPVON	☐	BBETRV	WRTV6	CURR	11	2	Lower limit for rent per area unit acc. to rep.list of rents
21	BMSPBIS	☐	BBETRB	WRTV6	CURR	11	2	Upper limit for rent per area unit acc. to rep.list rents
22	BMSPGRD	☐	BGRBTR	WRTV6	CURR	11	2	Mean value of rent per area unit acc. to rep.list of rents
23	BMSPZUA	☐	BMSPZUA	WRTV7	CURR	13	2	Rent adj.acc.to rep.rent list: Total surch./reduct./tot.pnts
24	JZUSCHLAG	☐	JZUSCHLAG	JANE	CHAR	1	0	Surcharge contained in new basic rent
25	JZUSTIM	☐	JZUSTIM	JANE	CHAR	1	0	Approval indicator
26	DZUSTIM	☐	DZUSTIM	DDAT	DATS	8	0	Approval date of rent adjustment
27	DZUBIS	☐	DZUBIS	DDAT	DATS	8	0	Date up to which approval has to be given
28	DSTORNO	☐	DSTORNO	DDAT	DATS	8	0	Reversal date of rent adjustment
29	DAKTIV	☐	VVDAKTIV	DDAT	DATS	8	0	Activation date of rental adjustment
30	DGUELBI	☐	VVDINDPKT	DATUM	DATS	8	0	Date when index markers are valid for this rent adjustment
31	BANPBM	☐	VVBANPBM	WRTV7	CURR	13	2	Total pro rata modernization costs for the rental unit
32	BMZUGBM	☐	VVBMZUGBM	WRTV7	CURR	13	2	Monthly surcharge planned in acc. with German tenancy law
33	RANTWF	☐	VVRANTWF	DEC6_2	DEC	8	2	Apportionment factor calculation units
34	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
35	PERHREL	☐	PERHREL	DECV3_2	DEC	5	2	Relative increase in amount (in percentage)
36	BERHABS	☐	BERHABS	WRTV7	CURR	13	2	Increase amount per area unit
37	BERHGES	☐	VVBERHGES	WRTV7	CURR	13	2	Increase amount in full (not referring to the area)
38	BNEUMIET	☐	VVBNEUGES	WRTV7	CURR	13	2	Total new amount (not relative to the area)
39	SFUTANP	☐	VVSFUTANP	VVSFUTANP	CHAR	1	0	Subsequent adjustment ? (No, initial adj., subsequent adj.)
40	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
41	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
42	BPKTSUM	☐	VVBPKTSUM	VVDECV5_2	DEC	7	2	Total number of points for feature class or object
43	PERHPROZ	☐	VVPERWEIT	DEC3_2	DEC	5	2	Percentage rate of calculated increase to be passed on
44	PERHHPZS	☐	VVPERHHPZS	DECV3_3	DEC	6	3	Percent.increase on the basis of a mortg.rate loan change
45	PERHUTBK	☐	VVPERHUTBK	DECV3_3	DEC	6	3	Percent.incr. on basis of maintenance/operating costs change
46	PERHTEUR	☐	VVPERHTEUR	DECV3_3	DEC	6	3	Percent.incr.on basis of change in standard of living index
47	PERHGES	☐	VVPERHGES	DECV3_3	DEC	6	3	Percent increase on basis of all relative/an absolute factor
48	SANPME	☐	VVSANPME	VVSANPME	CHAR	1	0	Specifies Adjustment Object (Only LO/Only RU/both)
49	DHPZS	☐	VVDHPZS	DATUM	DATS	8	0	CH rent adj.:Date of mortgage rate loan status for new rent
50	DUTBK	☐	VVDUTBK	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.csts index status for new rent
51	DTEUR	☐	VVDTEUR	DATUM	DATS	8	0	CH rent adj.:Date of standard of living status for new rent
52	DHPZSALT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
53	DUTBKALT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
54	DTEURALT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
55	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
56	SBSANPCH	☐	VVSBSANPCH	VVSBSANPCH	NUMC	2	0	CH rent adjustment: Adjustment basis
57	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
58	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
59	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
60	MFACH	☐	VVMFACH	CHAR10	CHAR	10	0	Rent table field
61	SANPSTAF	☐	VVSANPSTAF	VVSANPSTAF	CHAR	1	0	Scope of adjustment (conditions, sales grading, both)
62	SIHMA	☐	VVSIHMA	VVSIHMA	CHAR	20	0	Modernization Measure	*
63	JCHBASMOD	☐	VVCHBASMOD	XFELD	CHAR	1	0	CH rent adj: Adj. on basis overhaul/appr.surch. investment
64	JCHBASBMR	☐	VVCHBASBMR	XFELD	CHAR	1	0	Rent adj. CH: Adj. on basis reserves from modernizations
65	BCHBASMOD	☐	VVBGESBMI	WRTV7	CURR	13	2	Actual total costs of modernization
66	BMSPBAS	☐	VVBMSPBAS	WRTV6	CURR	11	2	Base rent per area unit acc. to rep.list of rents
67	BNEUABS	☐	VVBNEUFE	WRTV7	CURR	13	2	New amount per area unit
68	NDOCCNT	☐	VVNDOCCNT	NUMC3	NUMC	3	0	Number of printed letters for an adjustment
69	CURR_GS	☐	VVCURR_GS	WRTV7	CURR	13	2	Total amount as basis for adjustment without roundings
70	AREA_GS	☐	VVAREA_GS	VVBFLART	QUAN	14	4	Total area as base for adjustment without rounding errors
71	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
72	SBAUAKL	☐	SBAUALT	SBAUALT	NUMC	2	0	Building age category	TIV21
73	SLAGEKL	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
74	SGROEKL	☐	SGROEKL	SGROEKL	NUMC	3	0	Size class	TIV19
75	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
76	DBAUALT	☐	VVDBAUALT	DATE	DATS	8	0	Building age for rental unit relevant for rep.list of rents
77	JAREA	☐	VVJAREA	XFELD	CHAR	1	0	Rental on basis of area?
78	BKONDALTFE	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
79	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
80	SCOMMIT	☐	VVSRACOMMIT	NUMC02	NUMC	2	0	Reservation for approval for a rent adjustment	TIVM4
81	SREJECT	☐	VVSRAREJECT	NUM02	NUMC	2	0	Reason for rejecting a rent adjustment	TIVM5
82	DREJECT	☐	VVDRAREJECT	DDAT	DATS	8	0	Rejection date of a rent adjustment
83	NDUNLEV	☐	VVRADUNLEVEL	NUMC02	NUMC	2	0	Reminder level for reminders for rnt adjs not subj.to appr.
84	DLASTDC	☐	VVRADLASTDUN	DATUM	DATS	8	0	Date of last dunning due to missing tenant approval
85	DADJPRN	☐	VVDADJPRN	DATS	DATS	8	0	Letter date of adjustment correspondence
86	BANPASSFE	☐	VVBANPASSFE	WRTV7	CURR	13	2	New condition amount for each area unit (changeable)
87	BAUTANPFE	☐	VVBAUTANPFE	WRTV7	CURR	13	2	New condition amount for each area unit (original)
88	BVGLAVGGS	☐	VVBAVGGSMT	WRTV7	CURR	13	2	Average total rent
89	BGESZULGS	☐	VVBGESZULGS	WRTV7	CURR	13	2	Legally permitted total amount
90	SINDART_OLD	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
91	YBASISJ_OLD	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
92	BINDPKT_OLD	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
93	BINDPKT1_OLD	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
94	BPKTERH_OLD	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
95	PPKTERH_OLD	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
96	SINDART_NEW	☐	WBIND	WBIND	CHAR	5	0	Index series for replacement values	*
97	YBASISJ_NEW	☐	BASJHR	BASJHR	NUMC	4	0	Index series base year	*
98	BINDPKT_NEW	☐	BINDPKT	DEC5_3	DEC	8	3	Index marker status at last rent adjustment
99	BINDPKT1_NEW	☐	BINDPKT1	DEC5_3	DEC	8	3	Index status as base for first rental adjustment
100	BPKTERH_NEW	☐	VVBPKTERH	DEC4_2	DEC	6	2	Absolute change of index points for rent adjustment
101	PPKTERH_NEW	☐	PPKTERH	DEC03_2	DEC	5	2	Minimum change of index series change in percentage terms
102	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
103	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
104	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
105	JADJRHY	☐	JADJRHY	JANE	CHAR	1	0	Rent Adjustment Dependent on Condition Frequency
106	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
107	.INCLUDE	☐				0	0	Structure with additional fields for VIMI16
108	ERHBTR	☐	ERHBTR	WRTV7	CURR	13	2	Increase amount after rent adjustment
109	BERHBTRFE	☐	BERHBTRFE	WRTV7	CURR	13	2	Increase amount per area unit after rent adjustment
110	BINDDIFF	☐	BINDDIFF	DEC5_3	DEC	8	3	Index marker difference
111	XKOARTK	☐	XKOARTK	XKBEZ	CHAR	15	0	Name of condition type
112	XKOARTM	☐	XKOARTM	XBEZ20	CHAR	20	0	Condition type text
113	XKOARTL	☐	XKOARTL	XMBEZ	CHAR	30	0	Name of condition type
114	XMODK	☐	XMODK	XKBEZ	CHAR	15	0	Adjustment method short description
115	XMODM	☐	XMODM	XMBEZ	CHAR	30	0	Adjustment method description
116	XWAERSK	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
117	XWAERSL	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
118	XFEINSK	☐	XFEINSK	TEXT10	CHAR	10	0	Description of area unit
119	XFEINSL	☐	XFEINSL	TEXT30	CHAR	30	0	Description of area unit
120	XSTDORT	☐	VVXSTDORT	XTEXT35	CHAR	35	0	Regional location
121	INDTXT	☐	INDTXT	TEXT50	CHAR	50	0	Index series names
122	.INCLUDE	☐				0	0	Amounts from VIMI16 in second currency
123	SWHRKNDCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
124	BANPASSCUK	☐	BANPASSCUK	WRTV7	CURR	13	2	New amount after rent adjustment in second currency
125	BANPBMCUK	☐	VVBANPBCUK	WRTV7	CURR	13	2	Planned modernization costs in second currency
126	BAUTANPCUK	☐	BAUTANPCUK	WRTV7	CURR	13	2	Adjustment amount (automatic) in second currency
127	BCHBASMCUK	☐	VVBGSBMCUK	WRTV7	CURR	13	2	Actual total costs of modernization in second currency
128	BERHABSCUK	☐	BERHABSCUK	WRTV7	CURR	13	2	Increase amount per area unit in second currency
129	BERHGESCUK	☐	BERHGESCUK	WRTV7	CURR	13	2	Total increase amount in second currency
130	BGESZULCUK	☐	BGESZULCUK	WRTV7	CURR	13	2	New amount in second currency permitted by law
131	BKNDALTCUK	☐	BKNDALTCUK	WRTV7	CURR	13	2	Old condition amount in second currency
132	BMSPBASCUK	☐	BMSPBASCUK	WRTV6	CURR	11	2	Base rent per AU according to rep.list of rent in 2nd curr.
133	BMSPBISCUK	☐	BBETRBCUK	WRTV6	CURR	11	2	Rent upper limit per AU acc.to rent table in second currency
134	BMSPGRDCUK	☐	BGRBTRCUK	WRTV6	CURR	11	2	Mean value of rent per AU acc. to rent table in 2nd currency
135	BMSPVONCUK	☐	BBETRVCUK	WRTV6	CURR	11	2	Low rent limit per AU acc.to rent table in second currency
136	BMSPZUACUK	☐	BMSPZUACUK	WRTV7	CURR	13	2	Rent adj. rent table: Tot.surch/red./ tot.points in 2nd cur.
137	BMZUGBMCUK	☐	BMZUGBMCUK	WRTV7	CURR	13	2	Monthly surcharge planned acc. to §3 MHG (G.law) in 2nd cur.
138	BNEUABSCUK	☐	BNEUFECUK	WRTV7	CURR	13	2	New amount per area unit, in second currency
139	BNEUMIECUK	☐	BNEUGESCUK	WRTV7	CURR	13	2	Total new amount (not area-related) in 2nd currency
140	BVGLAVGCUK	☐	BVGLAVGCUK	WRTV7	CURR	13	2	Average rent of comparative group in 2nd currency
141	BERHBTRCUK	☐	BERHBTRCUK	WRTV7	CURR	13	2	Increase amount after rent adjustment in second currency
142	BKNDAFECUK	☐	BALTFECUK	WRTV7	CURR	13	2	Old condition amount per area unit in 2nd currency
143	BANPAFECUK	☐	BNEUFECUK	WRTV7	CURR	13	2	New amount per area unit, in second currency
144	BERHBFECUK	☐	BERHBFECUK	WRTV7	CURR	13	2	Increase amount per area unit, in second currency
145	.INCLUDE	☐				0	0	Structure with Additional Fields for VIMI16 (Switzerland)
146	IHPZS	☐	VVIHPZS	DEC5_3	DEC	8	3	New mortgage interest rate
147	IHPZSALT	☐	VVIHPZSALT	DEC5_3	DEC	8	3	Old mortgage interest rate
148	ITEUR	☐	VVITEUR	DEC5_3	DEC	8	3	Stand.liv.index
149	ITEURALT	☐	VVITEURALT	DEC5_3	DEC	8	3	Old standard of living index
150	BERHHPZS	☐	VVBERHHPZS	WRTV7	CURR	13	2	Adjustment amount based on change in mortgage interest rate
151	BERHUTBK	☐	VVBERHUTBK	WRTV7	CURR	13	2	Adj. amount based on change in maintenance/operating costs
152	BERHTEUR	☐	VVBERHTEUR	WRTV7	CURR	13	2	Adjustment amt based on change in standard of living index
153	BERHGSCH	☐	VVBERHGSCH	WRTV7	CURR	13	2	Adjustment amount based on relative/absolute factors

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in