SAP VIMI01 Rental unit - Master data Table
Overview
VIMI01 is a standard SAP S/4HANA table that stores Rental unit - Master data data. There are total 100 fields in the VIMI01 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI01 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 VIMI01 to other SAP tables and standard CDS views available based on VIMI01 table in S/4HANA 2020.
Techincal Settings of VIMI01
Below are technical details of the table VIMI01
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI01 Fields
The following table gives you an overview of the fields available in VIMI01
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | CHAR | 8 | |
| SGRNR | Land Number for BE | SGRNR | VIOB02 | CHAR | 8 |
| SGENR | Building Number | SGENR | VIOB03 | CHAR | 8 |
| SGEBSWENR | BE no.of rental unit to which the RU is linked | SGEBSWENR | VIOB01 | CHAR | 8 |
| SGEBSMENR | RU no. of rental unit to which the RU is linked | SGEBSMENR | VIMI01 | CHAR | 8 |
| SHEIZNR | Real Estate heating system number | SHEIZNR | NUMC | 4 | |
| SNUNR | Rental unit external usage type | SNUNR | TIV01 | NUMC | 4 |
| DBEZU | Date of initial usage | DBEZU | DATS | 8 | |
| DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | |
| UMBRAUM | Cubic Volume | BUBRA | DEC | 11 | |
| AZIMM | Number of rooms | AZIMM | DEC | 3 | |
| AHALBZI | Number of half rooms | AHALBZI | DEC | 2 | |
| STOCK | Dummy (previously storey replaced by VVSSTOCKW) | RGESCH | CHAR | 2 | |
| SBELART | Occupancy type indicator | SBELA | NUMC | 1 | |
| SHEIZART | Heating type | SHEIZ | CHAR | 1 | |
| DRESAB | Date: Reserved from | DRESA | DATS | 8 | |
| DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | |
| SGEBT | Part of Building | SGEBT | TIV12 | CHAR | 2 |
| SBWNR | Application number | SBWNR | VIMI11 | NUMC | 7 |
| XAUSTKL | Fixtures and fittings category | SAUSKL | TIV23 | NUMC | 2 |
| XLAGE | Location class | SLAGK | TIV22 | NUMC | 2 |
| SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | |
| STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | |
| SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | |
| DBEGEH | Date of last RU inspection | DBEGEH | DATS | 8 | |
| XBEGEH | Inspected by | XBEGEH | CHAR | 15 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| PZUABSP | Surcharge or reduction for representative list of rents | PZUABSP | DEC | 4 | |
| PERHOE | Percentage rate increase | PERHOE | DEC | 5 | |
| RPROZGRD | Reason for variance in rate of percentage increase | RPROZGRD | TIV43 | CHAR | 2 |
| DBINDBIS | Obligation period until | DBINDBIS | DATS | 8 | |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| RBELBIND | Occupancy obligation key | RBELBIND | TIV31 | CHAR | 4 |
| RLIFT | Type of elevator installation | RLIFT | TIV32 | NUMC | 2 |
| RMEDIEN | Media reception | RMEDIEN | TIV33 | NUMC | 3 |
| RWASSER | Type of water mains connection | RWASSER | TIV34 | NUMC | 2 |
| RLGESCH | Location on Floor | RLGESCH | TIV38 | CHAR | 2 |
| JVORSTEIG | Input tax deduction for vacancy | JVORSTEIG | CHAR | 1 | |
| SADRME | Object number of rental unit for address purposes | SADRME | SANO1 | NUMC | 10 |
| SNKS | Service Charge Collector Number | SNKS | ONR00 | CHAR | 22 |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | |
| XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | |
| JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | |
| RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| PROFL | Settlement profile for costs | VVAPROF | TKB1A | CHAR | 6 |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| SSTOCKW | Floor | VVSSTOCKW | TIV37 | NUMC | 3 |
| JKONDMV | Transfer conditions to RU when lease-out expires? | VVJKONDMV | CHAR | 1 | |
| PKONDMV | Percentage rate for transfer of terms from LO to RU | VVPKONDMV | DEC | 5 | |
| DFSTRBIS | Date up to when the rental unit cash flow is created | VVDFSTRBIS | DATS | 8 | |
| SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | TIV37 | NUMC | 3 |
| JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | |
| DHPZSAKT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAKT | DATS | 8 | |
| DUTBKAKT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAKT | DATS | 8 | |
| DTEURAKT | 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 | |
| BRDBRTKD | Marginal Gross Yield | VVBRDBRTKD | DEC | 10 | |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| XMETXT | Text for rental unit | VVXMETXT2 | CHAR | 30 | |
| SBASTEU | Swiss rent adj.: Base year for standard of living index | VVSBASTEU | NUMC | 4 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| DRESTAUR | Date of reconstruction/extensive modernization | VVDRESTAUR | DATS | 8 | |
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | |
| DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | |
| KOEIGR | Account determination key for account determination | VVWERTN_AD | TIVC6 | CHAR | 10 |
| BERGRP | Authorization group | VVBERGRP | CHAR | 40 | |
| SPOSINMSP | Base value for grouping RU in RLR group | VVSPOSINMSP | CHAR | 1 | |
| PPOSINMSP | Percentage value for grouping RU in RLR category group | VVPPOSINMSP | DEC | 5 | |
| DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | |
| DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | |
| SGRUNDB | Land register number | SGRUNDB | VIGBUCH | NUMC | 8 |
| PAUSFW | Service charge stt. apport.loss risk percentage surcharge | VVPAUSFW | DEC | 5 | |
| RESADXEYECATCH | Short Description of Real Estate Object on Offer | RESADXEYECATCH | CHAR | 85 | |
| RESADJINTERNET | Indicator Internet Release | RESADJINTERNET | CHAR | 1 | |
| REFANG | Reference offer | VVREFANG | VIMI33 | CHAR | 13 |
| ROTYPE | Rental Object Type | REBDROTYPE | CHAR | 2 | |
| ROTYPEEX | OBSOLETE: Type of Rental Object (External) | REBDROTYPEEX | CHAR | 1 | |
| FLID | OBSOLETE: Alternative ID for Rental Object (from CRE) | REBDALTROID | CHAR | 13 | |
| CANBECOMMON | Common Usage Possible | REBDCANBECOMMON | CHAR | 1 | |
| FIRSTPOSTING | Obsolete: Date of First Posting | REBDFIRSTPOSTING | DATS | 8 | |
| VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | |
| VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | |
| CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | |
| CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 |
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 VIMI01
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI01 | BUKRS | 1: CN | T001 |
| VIMI01 | GSBER | 1: CN | TGSB |
| VIMI01 | KOEIGR | : | TIVC6 |
| VIMI01 | KOKRS | C: CN | TKA01 |
| VIMI01 | PRCTR | : | CEPC |
| VIMI01 | PROFL | C: CN | TKB1A |
| VIMI01 | RBELBIND | 1: CN | TIV31 |
| VIMI01 | REFANG | 1: 1 | VIMI33 |
| VIMI01 | RLGESCH | 1: CN | TIV38 |
| VIMI01 | RLIFT | 1: CN | TIV32 |
| VIMI01 | RMEDIEN | 1: CN | TIV33 |
| VIMI01 | RPROZGRD | 1: CN | TIV43 |
| VIMI01 | RWASSER | 1: CN | TIV34 |
| VIMI01 | SADRME | 1: C | SANO1 |
| VIMI01 | SBWNR | 1: CN | VIMI11 |
| VIMI01 | SGEBSMENR | 1: CN | VIMI01 |
| VIMI01 | SGEBSWENR | 1: CN | VIOB01 |
| VIMI01 | SGEBT | 1: CN | TIV12 |
| VIMI01 | SGENR | 1: CN | VIOB03 |
| VIMI01 | SGRNR | 1: CN | VIOB02 |
| VIMI01 | SGRUNDB | 1: CN | VIGBUCH |
| VIMI01 | SNKS | 1: CN | ONR00 |
| VIMI01 | SNUNR | 1: CN | TIV01 |
| VIMI01 | SSTCKBIS | 1: C | TIV37 |
| VIMI01 | SSTOCKW | 1: C | TIV37 |
| VIMI01 | SWENR | 1: CN | VIOB01 |
| VIMI01 | XAUSTKL | 1: CN | TIV23 |
| VIMI01 | XLAGE | 1: CN | TIV22 |