SAP table VIMI01 (Rental unit - Master data)

SAP table VIMI01 has 4 primary key fields being MANDT,BUKRS,SWENR,SMENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VIMI01 foreign key relationships

Table Field Check Table Check Field
0 VIMI01 BUKRS T001 Company Codes BUKRS
1 VIMI01 GSBER TGSB Business Areas MANDT
1 VIMI01 GSBER TGSB Business Areas GSBER
0 VIMI01 KOEIGR TIVC6 Account Determination Key 4 for Lease-Out Accnt Determ. KOEIGR
1 VIMI01 KOKRS TKA01 Controlling Areas MANDT
0 VIMI01 PRCTR CEPC Profit Center Master Data Table PRCTR
0 VIMI01 PRCTR CEPC Profit Center Master Data Table DATBI
0 VIMI01 PRCTR CEPC Profit Center Master Data Table KOKRS
1 VIMI01 PROFL TKB1A Settlement Profile MANDT
1 VIMI01 PROFL TKB1A Settlement Profile APROF
0 VIMI01 REFANG VIMI33 Offers for a rental unit (-> VIMIMV) MANDT
0 VIMI01 REFANG VIMI33 Offers for a rental unit (-> VIMIMV) BUKRS
0 VIMI01 REFANG VIMI33 Offers for a rental unit (-> VIMIMV) SMENR
1 VIMI01 RLGESCH TIV38 Location on Floor RLGESCH
0 VIMI01 RLIFT TIV32 Elevator installation types for rental units-no longer used RLIFT
1 VIMI01 RMEDIEN TIV33 Type of media reception MANDT
0 VIMI01 RPROZGRD TIV43 Reasons for reduced percentage rate increase RPROZGRD
1 VIMI01 RWASSER TIV34 Water mains connection types RWASSER
0 VIMI01 SADRME SANO1 Address-object relationship MANDT
0 VIMI01 SADRME SANO1 Address-object relationship ADRNR
0 VIMI01 SADRME SANO1 Address-object relationship OBTYP
1 VIMI01 SBWNR VIMI11 Applications - Real Estate Management MANDT
0 VIMI01 SGEBSMENR VIMI01 Rental unit - Master data MANDT
0 VIMI01 SGEBSMENR VIMI01 Rental unit - Master data BUKRS
0 VIMI01 SGEBSMENR VIMI01 Rental unit - Master data SMENR
1 VIMI01 SGEBSWENR VIOB01 Business entities MANDT
1 VIMI01 SGEBSWENR VIOB01 Business entities BUKRS
0 VIMI01 SGEBT TIV12 Parts of building SGEBT
1 VIMI01 SGENR VIOB03 Real estate building master MANDT
1 VIMI01 SGENR VIOB03 Real estate building master BUKRS
1 VIMI01 SGENR VIOB03 Real estate building master SGENR
0 VIMI01 SGRNR VIOB02 Property master data MANDT
0 VIMI01 SGRNR VIOB02 Property master data BUKRS
0 VIMI01 SGRNR VIOB02 Property master data SGRNR
1 VIMI01 SGRUNDB VIGBUCH Land register MANDT
0 VIMI01 SNKS ONR00 General Object Number MANDT
1 VIMI01 SNUNR TIV01 External usage types of rental unit MANDT
0 VIMI01 SWENR VIOB01 Business entities MANDT
0 VIMI01 SWENR VIOB01 Business entities BUKRS
1 VIMI01 XAUSTKL TIV23 Fixtures/Fittings Categories SMKLASS
0 VIMI01 XLAGE TIV22 Representative list of rents location classes MANDT
0 VIMI01 XLAGE TIV22 Representative list of rents location classes SLAGK