SAP VIMI18 Rent Adjustment History for Lease-Out Table

Overview

VIMI18 is a standard SAP S/4HANA table that stores Rent Adjustment History for Lease-Out data. There are total 15 fields in the VIMI18 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIMI18 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 VIMI18 to other SAP tables and standard CDS views available based on VIMI18 table in S/4HANA 2020.

Techincal Settings of VIMI18

Below are technical details of the table VIMI18

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VIMI18 Fields

The following table gives you an overview of the fields available in VIMI18

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
BUKRSCompany CodeBUKRS*CHAR4
SMIVELease-Out NumberSMIVECHAR13
SWENRBusiness Entity NumberSWENR*CHAR8
SMENRNumber of Rental UnitSMENR*CHAR8
DGUELABValid-from dateDGABDATS8
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOART*NUMC4
SWHRKONDCurrency of Condition ItemSWHRKOND*CUKY5
SANPNRRent Adjustment MethodSANPNRTIV11NUMC3
BNEUNew amount after rent adjustmentBNEUCURR13
BALTPrevious amountBALTCURR13
FQMFLARTArea of area typeVVBFLARTQUAN14
FEINHEITArea unitFEINHEITT006UNIT3
BANPBMTotal pro rata modernization costs for the rental unitVVBANPBMCURR13
BMZUGBMMonthly surcharge planned in acc. with German tenancy lawVVBMZUGBMCURR13

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 VIMI18

Table NameFieldCardinalityCheck Table
VIMI18FEINHEIT:T006
VIMI18SANPNR1: CNTIV11

Other References