VIMI16

RE: Records of a Rent Adjustment Run | #transactional | Component: Real Estate Management

🔑 Keys (10)
💰 Amounts (23)
∑ Quantities (2)
📅 Dates (17)
☰ Categorical (12)
Other (32)
🔗 Relations (16)

Column Name	Description
MANDT FK	Client
BUKRS FK	Company Code
SMIVE	Lease-Out Number
SWENR FK	Business Entity Number
SMENR FK	Number of Rental Unit
SKOART FK	Condition Type (Smallest Subdivision of Condition Records)
DGUELAB	Date when the rent adjustment becomes valid
DANPASS	Rental Adjustment Date Planned For
SANPNR FK	Rent Adjustment Method
XIDENT	Identification of adjustment run

Column Name	Description
💲 Currency of Condition Item (SWHRKOND):
BKONDALT	Previous condition amount
BANPASS	New condition amount (total)
BAUTANP	New Total Condition Amount (Original)
BGESZUL	New legally permitted amount per area unit
BVGLAVG	Average rent per area unit
BMSPVON	Lower limit for rent per area unit acc. to rep.list of rents
BMSPBIS	Upper limit for rent per area unit acc. to rep.list rents
BMSPGRD	Mean value of rent per area unit acc. to rep.list of rents
BMSPZUA	Rent adj.acc.to rep.rent list: Total surch./reduct./tot.pnts
BANPBM	Total pro rata modernization costs for the rental unit
BMZUGBM	Monthly surcharge planned in acc. with German tenancy law
BERHABS	Increase amount per area unit
BERHGES	Increase amount in full (not referring to the area)
BNEUMIET	Total new amount (not relative to the area)
BCHBASMOD	Actual total costs of modernization
BMSPBAS	Base rent per area unit acc. to rep.list of rents
BNEUABS	New amount per area unit
CURR_GS	Total amount as basis for adjustment without roundings
BKONDALTFE	Currency amount per area unit
BANPASSFE	New condition amount for each area unit (changeable)
BAUTANPFE	New condition amount for each area unit (original)
BVGLAVGGS	Average total rent
BGESZULGS	Legally permitted total amount

Column Name	Description
📏 Area Unit (FEINS):
FQMFLART	Area of area type
AREA_GS	Total area as base for adjustment without rounding errors

Column Name	Description
DGUELAB	Date when the rent adjustment becomes valid
DANPASS	Rental Adjustment Date Planned For
DZUSTIM	Approval date of rent adjustment
DZUBIS	Date up to which approval has to be given
DSTORNO	Reversal date of rent adjustment
DAKTIV	Activation date of rental adjustment
DGUELBI	Date when index markers are valid for this rent adjustment
DHPZS	CH rent adj.:Date of mortgage rate loan status for new rent
DUTBK	CH rnt adj.:Dte maint./oper.csts index status for new rent
DTEUR	CH rent adj.:Date of standard of living status for new rent
DHPZSALT	CH rent adj.:Date of mort.loan rate status for current rent
DUTBKALT	CH rnt adj.:Dte maint./oper.costs index status for new rent
DTEURALT	CH rnt adj.:Dte of living stndrd index status for curr.rent
DBAUALT	Building age for rental unit relevant for rep.list of rents
DREJECT	Rejection date of a rent adjustment
DLASTDC	Date of last dunning due to missing tenant approval
DADJPRN	Letter date of adjustment correspondence

Column Name	Description
JZUSCHLAG	Surcharge contained in new basic rent	Show values
JZUSTIM	Approval indicator	Show values
SFUTANP	Subsequent adjustment ? (No, initial adj., subsequent adj.)	Show values
SANPME	Specifies Adjustment Object (Only LO/Only RU/both)	Show values
SBSANPCH	CH rent adjustment: Adjustment basis	Show values
SANPSTAF	Scope of adjustment (conditions, sales grading, both)	Show values
JCHBASMOD	CH rent adj: Adj. on basis overhaul/appr.surch. investment	Show values
JCHBASBMR	Rent adj. CH: Adj. on basis reserves from modernizations	Show values
JAREA	Rental on basis of area?	Show values
JBMONAT	Indicator for calculating amount per month	Show values
JADJRHY	Rent Adjustment Dependent on Condition Frequency	Show values
JNULLKON	Condition Form	Show values

Column Name	Description	Domain name
BINDPKT	Index marker status at last rent adjustment	DEC5_3
BINDALT	Previous index marker (from VIMI06)	DEC5_3
RANTWF	Apportionment factor calculation units	DEC6_2
IMKEY	Internal Key for Real Estate Object	IMKEY
PERHREL	Relative increase in amount (in percentage)	DECV3_2
BPKTSUM	Total number of points for feature class or object	VVDECV5_2
PERHPROZ	Percentage rate of calculated increase to be passed on	DEC3_2
PERHHPZS	Percent.increase on the basis of a mortg.rate loan change	DECV3_3
PERHUTBK	Percent.incr. on basis of maintenance/operating costs change	DECV3_3
PERHTEUR	Percent.incr.on basis of change in standard of living index	DECV3_3
PERHGES	Percent increase on basis of all relative/an absolute factor	DECV3_3
BRDBRTZZ	CH rent adj: Actual gross yield earned	DECV3_7
BRDBRTKD	Marginal Gross Yield	DECV3_7
INTRENO	Internal Real Estate Master Data Code	VVINTRENO
MFACH	Rent table field	CHAR10
SIHMA	Modernization Measure	VVSIHMA
NDOCCNT	Number of printed letters for an adjustment	NUMC3
NDUNLEV	Reminder level for reminders for rnt adjs not subj.to appr.	NUMC02
SINDART_OLD	Index series for replacement values	WBIND
YBASISJ_OLD	Index Series Base Year	BASJHR
BINDPKT_OLD	Index marker status at last rent adjustment	DEC5_3
BINDPKT1_OLD	Index status as base for first rental adjustment	DEC5_3
BPKTERH_OLD	Absolute change of index points for rent adjustment	DEC4_2
PPKTERH_OLD	Minimum change of index series change in percentage terms	DEC03_2
SINDART_NEW	Index series for replacement values	WBIND
YBASISJ_NEW	Index Series Base Year	BASJHR
BINDPKT_NEW	Index marker status at last rent adjustment	DEC5_3
BINDPKT1_NEW	Index status as base for first rental adjustment	DEC5_3
BPKTERH_NEW	Absolute change of index points for rent adjustment	DEC4_2
PPKTERH_NEW	Minimum change of index series change in percentage terms	DEC03_2
AMMRHY	Frequency in months	NUMC03
ATTRHY	Frequency in Days	NUMC03

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`VIMI16.MANDT == T001.MANDT` `VIMI16.BUKRS == T001.BUKRS`
Area Unit	`VIMI16.MANDT == T006.MANDT` `VIMI16.FEINS == T006.MSEHI`
Client	`VIMI16.MANDT == T000.MANDT`
Rent Adjustment Method	`VIMI16.MANDT == TIV11.MANDT` `VIMI16.SANPNR == TIV11.SANPNR`
Fixtures and fittings category Fixtures and fittings category Client Representative list of rents assignment	`VIMI16.SAUSTKL == TIV23.SMKLASS` `VIMI16.MANDT == TIV23.MANDT` `VIMI16.SMIETSP == TIV23.SMIETSP`
Reservation for approval for a rent adjustment Reservation for approval for a rent adjustment Client	`VIMI16.SCOMMIT == TIVM4.SCOMMIT` `VIMI16.MANDT == TIVM4.MANDT`
Condition Type (Smallest Subdivision of Condition Records) Condition Type (Smallest Subdivision of Condition Records) ?	`VIMI16.MANDT == TZK01.MANDT` `VIMI16.SKOART == TZK01.SKOART` `VIMI16.[column in domain "RANTYP"] == TZK01.RANTYP`
Detailed identification for condition items Condition Type (Smallest Subdivision of Condition Records) Detailed identification for condition items ? Client	`VIMI16.SKOART == TZK07.SKOART` `VIMI16.SKOPO == TZK07.SKOPO` `VIMI16.[column in domain "RANTYP"] == TZK07.RANTYP` `VIMI16.MANDT == TZK07.MANDT`
Location class Representative list of rents assignment Client Location class	`VIMI16.SMIETSP == TIV22.SMIETSP` `VIMI16.MANDT == TIV22.MANDT` `VIMI16.SLAGEKL == TIV22.SLAGK`
Number of Rental Unit Company Code Business Entity Number Number of Rental Unit	`VIMI16.MANDT == VIMI01.MANDT` `VIMI16.BUKRS == VIMI01.BUKRS` `VIMI16.SWENR == VIMI01.SWENR` `VIMI16.SMENR == VIMI01.SMENR`
Representative list of rents assignment	`VIMI16.MANDT == TIV20.MANDT` `VIMI16.SMIETSP == TIV20.SMIETSP`
Reason for rejecting a rent adjustment	`VIMI16.MANDT == TIVM5.MANDT` `VIMI16.SREJECT == TIVM5.SREJECT`
Business Entity Number Company Code Business Entity Number	`VIMI16.MANDT == VIOB01.MANDT` `VIMI16.BUKRS == VIOB01.BUKRS` `VIMI16.SWENR == VIOB01.SWENR`

Other Relations \| to Master Data Relations ↑	Join Conditions
Building age category Building age category Client Representative list of rents assignment	`VIMI16.SBAUAKL == TIV21.SBAUALT` `VIMI16.MANDT == TIV21.MANDT` `VIMI16.SMIETSP == TIV21.SMIETSP`
Size class Representative list of rents assignment Size class Client	`VIMI16.SMIETSP == TIV19.SMIETSP` `VIMI16.SGROEKL == TIV19.SGROEKL` `VIMI16.MANDT == TIV19.MANDT`
Location of BU	`VIMI16.MANDT == TIV35.MANDT` `VIMI16.SSTDORT == TIV35.SSTDORT`