SAP VIMI16 RE: Records of a Rent Adjustment Run Table
Overview
VIMI16 is a standard SAP S/4HANA table that stores RE: Records of a Rent Adjustment Run data. There are total 105 fields in the VIMI16 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI16 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIMI16 to other SAP tables and standard CDS views available based on VIMI16 table in S/4HANA 2020.
Techincal Settings of VIMI16
Below are technical details of the table VIMI16
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI16 Fields
The following table gives you an overview of the fields available in VIMI16
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| DGUELAB | Date when the rent adjustment becomes valid | DGUELAB | DATS | 8 | |
| DANPASS | Rental Adjustment Date Planned For | DANPASS | DATS | 8 | |
| SANPNR | Rent Adjustment Method | SANPNR | TIV11 | NUMC | 3 |
| XIDENT | Identification of adjustment run | XIDENT1 | CHAR | 16 | |
| SWHRKOND | Currency of Condition Item | SWHRKOND | * | CUKY | 5 |
| BKONDALT | Previous condition amount | BKONDALT | CURR | 13 | |
| BANPASS | New condition amount (total) | BANPASS | CURR | 13 | |
| BAUTANP | New Total Condition Amount (Original) | BAUTANP | CURR | 13 | |
| BGESZUL | New legally permitted amount per area unit | BGESZUL | CURR | 13 | |
| BVGLAVG | Average rent per area unit | BVGLAVG | CURR | 13 | |
| BINDPKT | Index marker status at last rent adjustment | BINDPKT | DEC | 8 | |
| BINDALT | Previous index marker (from VIMI06) | BINDALT | DEC | 8 | |
| BMSPVON | Lower limit for rent per area unit acc. to rep.list of rents | BBETRV | CURR | 11 | |
| BMSPBIS | Upper limit for rent per area unit acc. to rep.list rents | BBETRB | CURR | 11 | |
| BMSPGRD | Mean value of rent per area unit acc. to rep.list of rents | BGRBTR | CURR | 11 | |
| BMSPZUA | Rent adj.acc.to rep.rent list: Total surch./reduct./tot.pnts | BMSPZUA | CURR | 13 | |
| JZUSCHLAG | Surcharge contained in new basic rent | JZUSCHLAG | CHAR | 1 | |
| JZUSTIM | Approval indicator | JZUSTIM | CHAR | 1 | |
| DZUSTIM | Approval date of rent adjustment | DZUSTIM | DATS | 8 | |
| DZUBIS | Date up to which approval has to be given | DZUBIS | DATS | 8 | |
| DSTORNO | Reversal date of rent adjustment | DSTORNO | DATS | 8 | |
| DAKTIV | Activation date of rental adjustment | VVDAKTIV | DATS | 8 | |
| DGUELBI | Date when index markers are valid for this rent adjustment | VVDINDPKT | DATS | 8 | |
| BANPBM | Total pro rata modernization costs for the rental unit | VVBANPBM | CURR | 13 | |
| BMZUGBM | Monthly surcharge planned in acc. with German tenancy law | VVBMZUGBM | CURR | 13 | |
| RANTWF | Apportionment factor calculation units | VVRANTWF | DEC | 8 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| PERHREL | Relative increase in amount (in percentage) | PERHREL | DEC | 5 | |
| BERHABS | Increase amount per area unit | BERHABS | CURR | 13 | |
| BERHGES | Increase amount in full (not referring to the area) | VVBERHGES | CURR | 13 | |
| BNEUMIET | Total new amount (not relative to the area) | VVBNEUGES | CURR | 13 | |
| SFUTANP | Subsequent adjustment ? (No initial adj. subsequent adj.) | VVSFUTANP | CHAR | 1 | |
| FQMFLART | Area of area type | VVBFLART | QUAN | 14 | |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| BPKTSUM | Total number of points for feature class or object | VVBPKTSUM | DEC | 7 | |
| PERHPROZ | Percentage rate of calculated increase to be passed on | VVPERWEIT | DEC | 5 | |
| PERHHPZS | Percent.increase on the basis of a mortg.rate loan change | VVPERHHPZS | DEC | 6 | |
| PERHUTBK | Percent.incr. on basis of maintenance/operating costs change | VVPERHUTBK | DEC | 6 | |
| PERHTEUR | Percent.incr.on basis of change in standard of living index | VVPERHTEUR | DEC | 6 | |
| PERHGES | Percent increase on basis of all relative/an absolute factor | VVPERHGES | DEC | 6 | |
| SANPME | Specifies Adjustment Object (Only LO/Only RU/both) | VVSANPME | CHAR | 1 | |
| DHPZS | CH rent adj.:Date of mortgage rate loan status for new rent | VVDHPZS | DATS | 8 | |
| DUTBK | CH rnt adj.:Dte maint./oper.csts index status for new rent | VVDUTBK | DATS | 8 | |
| DTEUR | CH rent adj.:Date of standard of living status for new rent | VVDTEUR | DATS | 8 | |
| DHPZSALT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAKT | DATS | 8 | |
| DUTBKALT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAKT | DATS | 8 | |
| DTEURALT | CH rnt adj.:Dte of living stndrd index status for curr.rent | VVDTEURAKT | DATS | 8 | |
| BRDBRTZZ | CH rent adj: Actual gross yield earned | VVBRDBRTZZ | DEC | 10 | |
| SBSANPCH | CH rent adjustment: Adjustment basis | VVSBSANPCH | NUMC | 2 | |
| BRDBRTKD | Marginal Gross Yield | VVBRDBRTKD | DEC | 10 | |
| SSTDORT | Regional location | VVSSTDORT | TIV35 | CHAR | 10 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| MFACH | Rent table field | VVMFACH | CHAR | 10 | |
| SANPSTAF | Scope of adjustment (conditions sales grading both) | VVSANPSTAF | CHAR | 1 | |
| SIHMA | Modernization Measure | VVSIHMA | * | CHAR | 20 |
| JCHBASMOD | CH rent adj: Adj. on basis overhaul/appr.surch. investment | VVCHBASMOD | CHAR | 1 | |
| JCHBASBMR | Rent adj. CH: Adj. on basis reserves from modernizations | VVCHBASBMR | CHAR | 1 | |
| BCHBASMOD | Actual total costs of modernization | VVBGESBMI | CURR | 13 | |
| BMSPBAS | Base rent per area unit acc. to rep.list of rents | VVBMSPBAS | CURR | 11 | |
| BNEUABS | New amount per area unit | VVBNEUFE | CURR | 13 | |
| NDOCCNT | Number of printed letters for an adjustment | VVNDOCCNT | NUMC | 3 | |
| CURR_GS | Total amount as basis for adjustment without roundings | VVCURR_GS | CURR | 13 | |
| AREA_GS | Total area as base for adjustment without rounding errors | VVAREA_GS | QUAN | 14 | |
| SMIETSP | Representative list of rents assignment | SMIETSP | TIV20 | CHAR | 6 |
| SBAUAKL | Building age category | SBAUALT | TIV21 | NUMC | 2 |
| SLAGEKL | Location class | SLAGK | TIV22 | NUMC | 2 |
| SGROEKL | Size class | SGROEKL | TIV19 | NUMC | 3 |
| SAUSTKL | Fixtures and fittings category | SAUSKL | TIV23 | NUMC | 2 |
| DBAUALT | Building age for rental unit relevant for rep.list of rents | VVDBAUALT | DATS | 8 | |
| JAREA | Rental on basis of area? | VVJAREA | CHAR | 1 | |
| BKONDALTFE | Currency amount per area unit | BKONDQM | CURR | 13 | |
| SKOPO | Detailed identification for condition items | VVSKOPO | TZK07 | NUMC | 2 |
| SCOMMIT | Reservation for approval for a rent adjustment | VVSRACOMMIT | TIVM4 | NUMC | 2 |
| SREJECT | Reason for rejecting a rent adjustment | VVSRAREJECT | TIVM5 | NUMC | 2 |
| DREJECT | Rejection date of a rent adjustment | VVDRAREJECT | DATS | 8 | |
| NDUNLEV | Reminder level for reminders for rnt adjs not subj.to appr. | VVRADUNLEVEL | NUMC | 2 | |
| DLASTDC | Date of last dunning due to missing tenant approval | VVRADLASTDUN | DATS | 8 | |
| DADJPRN | Letter date of adjustment correspondence | VVDADJPRN | DATS | 8 | |
| BANPASSFE | New condition amount for each area unit (changeable) | VVBANPASSFE | CURR | 13 | |
| BAUTANPFE | New condition amount for each area unit (original) | VVBAUTANPFE | CURR | 13 | |
| BVGLAVGGS | Average total rent | VVBAVGGSMT | CURR | 13 | |
| BGESZULGS | Legally permitted total amount | VVBGESZULGS | CURR | 13 | |
| SINDART_OLD | Index series for replacement values | WBIND | * | CHAR | 5 |
| YBASISJ_OLD | Index Series Base Year | BASJHR | * | NUMC | 4 |
| BINDPKT_OLD | Index marker status at last rent adjustment | BINDPKT | DEC | 8 | |
| BINDPKT1_OLD | Index status as base for first rental adjustment | BINDPKT1 | DEC | 8 | |
| BPKTERH_OLD | Absolute change of index points for rent adjustment | VVBPKTERH | DEC | 6 | |
| PPKTERH_OLD | Minimum change of index series change in percentage terms | PPKTERH | DEC | 5 | |
| SINDART_NEW | Index series for replacement values | WBIND | * | CHAR | 5 |
| YBASISJ_NEW | Index Series Base Year | BASJHR | * | NUMC | 4 |
| BINDPKT_NEW | Index marker status at last rent adjustment | BINDPKT | DEC | 8 | |
| BINDPKT1_NEW | Index status as base for first rental adjustment | BINDPKT1 | DEC | 8 | |
| BPKTERH_NEW | Absolute change of index points for rent adjustment | VVBPKTERH | DEC | 6 | |
| PPKTERH_NEW | Minimum change of index series change in percentage terms | PPKTERH | DEC | 5 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | |
| JBMONAT | Indicator for calculating amount per month | JBMONAT | CHAR | 1 | |
| JADJRHY | Rent Adjustment Dependent on Condition Frequency | JADJRHY | CHAR | 1 | |
| JNULLKON | Condition Form | JNULLKON | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIMI16
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI16 | BUKRS | 1: CN | T001 |
| VIMI16 | FEINS | : | T006 |
| VIMI16 | MANDT | 1: CN | T000 |
| VIMI16 | SANPNR | 1: CN | TIV11 |
| VIMI16 | SAUSTKL | 1: CN | TIV23 |
| VIMI16 | SBAUAKL | 1: CN | TIV21 |
| VIMI16 | SCOMMIT | 1: CN | TIVM4 |
| VIMI16 | SGROEKL | 1: CN | TIV19 |
| VIMI16 | SKOART | 1: CN | TZK01 |
| VIMI16 | SKOPO | 1: CN | TZK07 |
| VIMI16 | SLAGEKL | 1: CN | TIV22 |
| VIMI16 | SMENR | 1: CN | VIMI01 |
| VIMI16 | SMIETSP | 1: CN | TIV20 |
| VIMI16 | SREJECT | 1: CN | TIVM5 |
| VIMI16 | SSTDORT | 1: CN | TIV35 |
| VIMI16 | SWENR | 1: CN | VIOB01 |