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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
BUKRSCompany CodeBUKRST001CHAR4
SMIVELease-Out NumberSMIVECHAR13
SWENRBusiness Entity NumberSWENRVIOB01CHAR8
SMENRNumber of Rental UnitSMENRVIMI01CHAR8
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOARTTZK01NUMC4
DGUELABDate when the rent adjustment becomes validDGUELABDATS8
DANPASSRental Adjustment Date Planned ForDANPASSDATS8
SANPNRRent Adjustment MethodSANPNRTIV11NUMC3
XIDENTIdentification of adjustment runXIDENT1CHAR16
SWHRKONDCurrency of Condition ItemSWHRKOND*CUKY5
BKONDALTPrevious condition amountBKONDALTCURR13
BANPASSNew condition amount (total)BANPASSCURR13
BAUTANPNew Total Condition Amount (Original)BAUTANPCURR13
BGESZULNew legally permitted amount per area unitBGESZULCURR13
BVGLAVGAverage rent per area unitBVGLAVGCURR13
BINDPKTIndex marker status at last rent adjustmentBINDPKTDEC8
BINDALTPrevious index marker (from VIMI06)BINDALTDEC8
BMSPVONLower limit for rent per area unit acc. to rep.list of rentsBBETRVCURR11
BMSPBISUpper limit for rent per area unit acc. to rep.list rentsBBETRBCURR11
BMSPGRDMean value of rent per area unit acc. to rep.list of rentsBGRBTRCURR11
BMSPZUARent adj.acc.to rep.rent list: Total surch./reduct./tot.pntsBMSPZUACURR13
JZUSCHLAGSurcharge contained in new basic rentJZUSCHLAGCHAR1
JZUSTIMApproval indicatorJZUSTIMCHAR1
DZUSTIMApproval date of rent adjustmentDZUSTIMDATS8
DZUBISDate up to which approval has to be givenDZUBISDATS8
DSTORNOReversal date of rent adjustmentDSTORNODATS8
DAKTIVActivation date of rental adjustmentVVDAKTIVDATS8
DGUELBIDate when index markers are valid for this rent adjustmentVVDINDPKTDATS8
BANPBMTotal pro rata modernization costs for the rental unitVVBANPBMCURR13
BMZUGBMMonthly surcharge planned in acc. with German tenancy lawVVBMZUGBMCURR13
RANTWFApportionment factor calculation unitsVVRANTWFDEC8
IMKEYInternal Key for Real Estate ObjectIMKEYCHAR8
PERHRELRelative increase in amount (in percentage)PERHRELDEC5
BERHABSIncrease amount per area unitBERHABSCURR13
BERHGESIncrease amount in full (not referring to the area)VVBERHGESCURR13
BNEUMIETTotal new amount (not relative to the area)VVBNEUGESCURR13
SFUTANPSubsequent adjustment ? (No initial adj. subsequent adj.)VVSFUTANPCHAR1
FQMFLARTArea of area typeVVBFLARTQUAN14
FEINSArea UnitFEINST006UNIT3
BPKTSUMTotal number of points for feature class or objectVVBPKTSUMDEC7
PERHPROZPercentage rate of calculated increase to be passed onVVPERWEITDEC5
PERHHPZSPercent.increase on the basis of a mortg.rate loan changeVVPERHHPZSDEC6
PERHUTBKPercent.incr. on basis of maintenance/operating costs changeVVPERHUTBKDEC6
PERHTEURPercent.incr.on basis of change in standard of living indexVVPERHTEURDEC6
PERHGESPercent increase on basis of all relative/an absolute factorVVPERHGESDEC6
SANPMESpecifies Adjustment Object (Only LO/Only RU/both)VVSANPMECHAR1
DHPZSCH rent adj.:Date of mortgage rate loan status for new rentVVDHPZSDATS8
DUTBKCH rnt adj.:Dte maint./oper.csts index status for new rentVVDUTBKDATS8
DTEURCH rent adj.:Date of standard of living status for new rentVVDTEURDATS8
DHPZSALTCH rent adj.:Date of mort.loan rate status for current rentVVDHPZSAKTDATS8
DUTBKALTCH rnt adj.:Dte maint./oper.costs index status for new rentVVDUTBKAKTDATS8
DTEURALTCH rnt adj.:Dte of living stndrd index status for curr.rentVVDTEURAKTDATS8
BRDBRTZZCH rent adj: Actual gross yield earnedVVBRDBRTZZDEC10
SBSANPCHCH rent adjustment: Adjustment basisVVSBSANPCHNUMC2
BRDBRTKDMarginal Gross YieldVVBRDBRTKDDEC10
SSTDORTRegional locationVVSSTDORTTIV35CHAR10
INTRENOInternal Real Estate Master Data CodeVVINTRENOCHAR13
MFACHRent table fieldVVMFACHCHAR10
SANPSTAFScope of adjustment (conditions sales grading both)VVSANPSTAFCHAR1
SIHMAModernization MeasureVVSIHMA*CHAR20
JCHBASMODCH rent adj: Adj. on basis overhaul/appr.surch. investmentVVCHBASMODCHAR1
JCHBASBMRRent adj. CH: Adj. on basis reserves from modernizationsVVCHBASBMRCHAR1
BCHBASMODActual total costs of modernizationVVBGESBMICURR13
BMSPBASBase rent per area unit acc. to rep.list of rentsVVBMSPBASCURR11
BNEUABSNew amount per area unitVVBNEUFECURR13
NDOCCNTNumber of printed letters for an adjustmentVVNDOCCNTNUMC3
CURR_GSTotal amount as basis for adjustment without roundingsVVCURR_GSCURR13
AREA_GSTotal area as base for adjustment without rounding errorsVVAREA_GSQUAN14
SMIETSPRepresentative list of rents assignmentSMIETSPTIV20CHAR6
SBAUAKLBuilding age categorySBAUALTTIV21NUMC2
SLAGEKLLocation classSLAGKTIV22NUMC2
SGROEKLSize classSGROEKLTIV19NUMC3
SAUSTKLFixtures and fittings categorySAUSKLTIV23NUMC2
DBAUALTBuilding age for rental unit relevant for rep.list of rentsVVDBAUALTDATS8
JAREARental on basis of area?VVJAREACHAR1
BKONDALTFECurrency amount per area unitBKONDQMCURR13
SKOPODetailed identification for condition itemsVVSKOPOTZK07NUMC2
SCOMMITReservation for approval for a rent adjustmentVVSRACOMMITTIVM4NUMC2
SREJECTReason for rejecting a rent adjustmentVVSRAREJECTTIVM5NUMC2
DREJECTRejection date of a rent adjustmentVVDRAREJECTDATS8
NDUNLEVReminder level for reminders for rnt adjs not subj.to appr.VVRADUNLEVELNUMC2
DLASTDCDate of last dunning due to missing tenant approvalVVRADLASTDUNDATS8
DADJPRNLetter date of adjustment correspondenceVVDADJPRNDATS8
BANPASSFENew condition amount for each area unit (changeable)VVBANPASSFECURR13
BAUTANPFENew condition amount for each area unit (original)VVBAUTANPFECURR13
BVGLAVGGSAverage total rentVVBAVGGSMTCURR13
BGESZULGSLegally permitted total amountVVBGESZULGSCURR13
SINDART_OLDIndex series for replacement valuesWBIND*CHAR5
YBASISJ_OLDIndex Series Base YearBASJHR*NUMC4
BINDPKT_OLDIndex marker status at last rent adjustmentBINDPKTDEC8
BINDPKT1_OLDIndex status as base for first rental adjustmentBINDPKT1DEC8
BPKTERH_OLDAbsolute change of index points for rent adjustmentVVBPKTERHDEC6
PPKTERH_OLDMinimum change of index series change in percentage termsPPKTERHDEC5
SINDART_NEWIndex series for replacement valuesWBIND*CHAR5
YBASISJ_NEWIndex Series Base YearBASJHR*NUMC4
BINDPKT_NEWIndex marker status at last rent adjustmentBINDPKTDEC8
BINDPKT1_NEWIndex status as base for first rental adjustmentBINDPKT1DEC8
BPKTERH_NEWAbsolute change of index points for rent adjustmentVVBPKTERHDEC6
PPKTERH_NEWMinimum change of index series change in percentage termsPPKTERHDEC5
AMMRHYFrequency in monthsAMMRHYNUMC3
ATTRHYFrequency in DaysATTRHYNUMC3
JBMONATIndicator for calculating amount per monthJBMONATCHAR1
JADJRHYRent Adjustment Dependent on Condition FrequencyJADJRHYCHAR1
JNULLKONCondition FormJNULLKONCHAR1

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 NameFieldCardinalityCheck Table
VIMI16BUKRS1: CNT001
VIMI16FEINS:T006
VIMI16MANDT1: CNT000
VIMI16SANPNR1: CNTIV11
VIMI16SAUSTKL1: CNTIV23
VIMI16SBAUAKL1: CNTIV21
VIMI16SCOMMIT1: CNTIVM4
VIMI16SGROEKL1: CNTIV19
VIMI16SKOART1: CNTZK01
VIMI16SKOPO1: CNTZK07
VIMI16SLAGEKL1: CNTIV22
VIMI16SMENR1: CNVIMI01
VIMI16SMIETSP1: CNTIV20
VIMI16SREJECT1: CNTIVM5
VIMI16SSTDORT1: CNTIV35
VIMI16SWENR1: CNVIOB01

Other References