SAP VIMI01 Rental unit - Master data Table data and field list

VIMI01 is a standard SAP Table which is used to store Rental unit - Master data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VIMI01 table consists of various fields, each holding specific information or linking keys about Rental unit - Master data data available in SAP. These include BUKRS (Company Code), SWENR (Site Number), SMENR (Number of Rental Unit), SGRNR (Property Number for BE)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VIMI01 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIMI01 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VIMI01 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8SMENRSMENRMEHMCME
SGRNRProperty Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
SGENRBuilding Number SGENRCHAR8VIOB03SGENRSGENRGEBMCGE
SGEBSWENRBE no.of rental unit to which the RU is linked SGEBSWENRCHAR8VIOB01SWENRSWENR
SGEBSMENRRU no. of rental unit to which the RU is linked SGEBSMENRCHAR8VIMI01SMENRSMENR
SHEIZNRReal Estate heating system number SHEIZNRNUMC4SHEIZNR
SNUNRRental unit external usage type SNUNRNUMC4TIV01SNUNR
DBEZUDate of initial usage DBEZUDATS8DDAT
DWTVERMDate: Subsequent rental DWTVERMDATS8DATUM
UMBRAUMCubic Volume BUBRADEC11(3) DEC8_3
AZIMMNumber of rooms AZIMMDEC3DEC3
AHALBZINumber of half rooms AHALBZIDEC2DEC2
STOCKDummy (previously storey, replaced by VVSSTOCKW) RGESCHCHAR2CHAR2
SBELARTOccupancy type indicator SBELANUMC1SBELA
SHEIZARTHeating type SHEIZCHAR1SHEIZ
DRESABDate: Reserved from DRESADATS8DDAT
DRESBISDate: Reserved upto DRESBDATS8DDAT
SGEBTPart of Building SGEBTCHAR2TIV12SGEBT
SBWNRApplication number SBWNRNUMC7VIMI11SBWNROWK
XAUSTKLFixtures and fittings category SAUSKLNUMC2TIV23SAUSKL
XLAGELocation class SLAGKNUMC2TIV22SLAGK
SMOEBLFurniture indicator SMOEBCHAR1SMOEB
STECHEMHeating expenses settlement company evaluation group STECHEMCHAR13STECHEM
SALTNRNumber of rental unit in existing real estate system SALTNRCHAR20SALTNR
DBEGEHDate of last RU inspection DBEGEHDATS8DDAT
XBEGEHInspected by XBEGEHCHAR15XKBEZ
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
PZUABSPSurcharge or reduction for representative list of rents PZUABSPDEC4(2) PZUABSP
PERHOEPercentage rate increase PERHOEDEC5(2) DEC3_2
RPROZGRDReason for variance in rate of percentage increase RPROZGRDCHAR2TIV43RPROZGRD
DBINDBISObligation period until DBINDBISDATS8DATUM
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
RBELBINDOccupancy obligation key RBELBINDCHAR4TIV31RBELBIND
RLIFTType of elevator installation RLIFTNUMC2TIV32RLIFT
RMEDIENMedia reception RMEDIENNUMC3TIV33RMEDIEN
RWASSERType of water mains connection RWASSERNUMC2TIV34RWASSER
RLGESCHLocation on Floor RLGESCHCHAR2TIV38ALPHARLGESCH
JVORSTEIGInput tax deduction for vacancy JVORSTEIGCHAR1OPTIERT
SADRMEObject number of rental unit for address purposes SADRMENUMC10SANO1SOBJNR
SNKSService Charge Collector Number SNKSCHAR22ONR00J_OBJNR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
ABNNRIdentification of lease-out at settlement company ABNNRCHAR20TEXT20
XSTANDNRNumber of garage / parking space VVXSTANDNRCHAR5ALPHAVVXSTANDNR
JEIGWOHNRental Unit in Separate Ownership (COA) VVJEIGWOHNCHAR1JANE
RFAKTConversion factor for fractional share of property VVRFAKTNUMC6VVRFAKT
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PROFLSettlement profile for costs VVAPROFCHAR6TKB1AALPHAAPROF
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
SSTOCKWFloor VVSSTOCKWNUMC3TIV37VVSSTOCKW
JKONDMVTransfer conditions to RU when lease-out expires? VVJKONDMVCHAR1XFELD
PKONDMVPercentage rate for transfer of terms from LO to RU VVPKONDMVDEC5(2) PRZ32
DFSTRBISDate up to when the rental unit cash flow is created VVDFSTRBISDATS8DATUM
SSTCKBISFor RUs with Multiple Floors: Top Floor of RU VVSSTCKBISNUMC3TIV37VVSSTOCKW
JRMSCHPRTenant service charge settlement? VVJRMSCHPRCHAR1XFELD
DHPZSAKTCH rent adj.:Date of mort.loan rate status for current rent VVDHPZSAKTDATS8DATUM
DUTBKAKTCH rnt adj.:Dte maint./oper.costs index status for new rent VVDUTBKAKTDATS8DATUM
DTEURAKTCH rnt adj.:Dte of living stndrd index status for curr.rent VVDTEURAKTDATS8DATUM
BRDBRTZZCH rent adj: Actual gross yield earned VVBRDBRTZZDEC10(7) DECV3_7
BRDBRTKDMarginal Gross Yield VVBRDBRTKDDEC10(7) DECV3_7
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
XMETXTText for rental unit VVXMETXT2CHAR30XMBEZ
SBASTEUSwiss rent adj.: Base year for standard of living index VVSBASTEUNUMC4Assigned to domainGJAHRBASJHR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
DRESTAURDate of reconstruction/extensive modernization VVDRESTAURDATS8DATUM
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
DFLOWFIXFlows fixed upto VVDFLOWFIXDATS8DATUM
KOEIGRAccount determination key for account determination VVWERTN_ADCHAR10TIVC6VVWERTN_AD
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
SPOSINMSPBase value for grouping RU in RLR group VVSPOSINMSPCHAR1VVSADJBASE
PPOSINMSPPercentage value for grouping RU in RLR category group VVPPOSINMSPDEC5(2) DECV3_2
DFRDVONPublic funding from VVDFRDVONDATS8DATUM
DFRDBISPublic funding to VVDFRDBISDATS8DATUM
SGRUNDBLand register number SGRUNDBNUMC8VIGBUCHSGRUNDBGBS
PAUSFWService charge stt. apport.loss risk percentage surcharge VVPAUSFWDEC5(2) DEC3_2
RESADXEYECATCHShort Description of Real Estate Object on Offer RESADXEYECATCHCHAR85RESADXEYECATCH
RESADJINTERNETIndicator Internet Release RESADJINTERNETCHAR1XFELD
REFANGReference offer VVREFANGCHAR13VIMI33ALPHARANLMIA
.INCLU--AP 0
REFNOExternal Reference Number HB_REFNOCHAR24HBS_REFNO
HOMTYPPossible Sales Unit Types HB_HOMTYPCHAR8CHBSHTPHBS_HOMTYP
MTLAURMarker for Low Income Housing HB_MTLAURCHAR1CHBSNCMHBS_MTLAUR
SPRMUMSales Phase Premium HB_SPRMUMCURR12(2) HBS_PRICE
LPRMUMLocation Premium HB_LPRMUMCURR12(2) HBS_PRICE
HB_MARKERSingle-Character Indicator CHAR1CHAR1CHAR1
PRMTXT1Text (80 Characters) TEXT80CHAR80TEXT80UEB
PRMTXT2Text (80 Characters) TEXT80CHAR80TEXT80UEB
PRMTXT3Text (80 Characters) TEXT80CHAR80TEXT80UEB
PRMTXT4Text (80 Characters) TEXT80CHAR80TEXT80UEB
PRMTXT5Text (80 Characters) TEXT80CHAR80TEXT80UEB
PRMTXT6Text (80 Characters) TEXT80CHAR80TEXT80UEB
PHASESales Phase HB_SPHSECHAR11HBSSPHHBS_PHASE
.INCLU--AP 0
ROTYPERental Object Type REBDROTYPECHAR2REBDROTYPEREBDROTYPE
ROTYPEEXOBSOLETE: Type of Rental Object (External) REBDROTYPEEXCHAR1REBDROTYPEEX
FLIDOBSOLETE: Alternative ID for Rental Object (from CRE) REBDALTROIDCHAR13REBDALTROID
CANBECOMMONCommon Usage Possible REBDCANBECOMMONCHAR1RECABOOL
FIRSTPOSTINGObsolete: Date of First Posting REBDFIRSTPOSTINGDATS8RECADATE
VALIDFROMDate: Object Valid From REBDOBJVALIDFROMDATS8RECADATEBEG
VALIDTODate: Object Valid To REBDOBJVALIDTODATS8REDATRECADATEEND
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12Assigned to domainXUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12Assigned to domainXUBNAMEUSER_COMP
CFARCHIVEDTODate Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTODATS8RECADATE
CFLOCKEDTODate Until Which the Cash Flow Is Locked RECDCFLOCKEDTODATS8RECADATE

Key field Non-key field



How do I retrieve data from SAP table VIMI01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIMI01 to SELECT all data from the table
DATA: WA_VIMI01 TYPE VIMI01.

SELECT SINGLE *
FROM VIMI01
INTO CORRESPONDING FIELDS OF WA_VIMI01
WHERE...

How to access SAP table VIMI01

Within an ECC or HANA version of SAP you can also view further information about VIMI01 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VIMI01

    VZBAVV1 - Auxiliary table with end of validity
        VIOB01 - Business entities
            VIOB02 - Property master data
                VIGBA1 - Section 1 of land register
                VIGBA2 - Section 2 of land register
                VIGBA3 - Section 3 of land register
                VIGBUCH - Land Register
                    VISPRT1 - Partner data for properties
                    VIEIGE - Owners of real estate objects
                VIWEGR - Relation table between property and assets
                    VIANLGR - BAV Table - Properties from AM
        VWPBUKR - Company code position
            VISANS1 - Address data for objects (SANS1)
    V_VWPANLA - Generated table for viewl V_VWPANLA
        VWPAKTI - Stocks, subscription rights, investment certs.
        VWSPRT1 - Partner data WP (debtor-issuer) (SPRT1/SANS1
        VWPDEP1 - Securities account position (VWPDEPO) +add. fields
            VWZZBEPP - View of collectors VWBEPP, VWBEKI, VWBEPI
            VZZKOKO - Table condition header
                VZZKOPO - Table condition items
        V_VDARL - Generated table for view V_VDARL
            VDSPRT1 - Partner data DA (debtor) SPRT1/SANS1/PARZJ
            VDSDV4 - Loan collateral in acc. with BAV/PRF4
            VIMI01 - Rental unit - real estate
            VDSDV5 - Collateral in securities in acc. with BAV/PRF5
            VDSDV2 - Collateral in accordance with BAV/PRF2
            VDZZBEPP - View of collectors VDBEPP, VDBEKI, VDBEPI
            VDZZKOKO - Condition header for loans
                VDZZKOPO - Condition items for loan
        V_VTBFHA - Generated table for view V_VTBFHA
            VTBFHAPO - Financial transaction flow
            VTBFINKO - Financial transaction condition
    VIMIMV - Lease-Out
        VIZZKOKO - Real Estate condition header for BAV
            VIZZKOPO - Real Estate condition items for BAV
            VIOB03 - Real estate building master
                VIWEGB - Relation table between buildings and assets
                    VIANLGB - BAV table buildings from AM

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
                    VIGBSTD - Real Estate Register of Land Register
                        VIGBFLS - Parcels of Land for Property
                        VIGBZAB - Appreciation/Depreciation in Real Estate Register
                    VIGBA1 - Section 1 of Land Register
                    VIGBA2 - Section 2 of Land Register
                        VIGB2A - Changes in Section 2 of Land Register
                    VIGBA3 - Section 3 of Land Register
                        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-Dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Settl.: Assign RUs to part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship between Real Estate objs and SAP-PM
        VZSORT - Sort Values for Object

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (Plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
                    VIGBSTD - Real Estate Register of Land Register
                        VIGBFLS - Parcels of Land for Property
                        VIGBZAB - Appreciation/Depreciation in Real Estate Register
                    VIGBA1 - Section 1 of Land Register
                    VIGBA2 - Section 2 of Land Register
                        VIGB2A - Changes in Section 2 of Land Register
                    VIGBA3 - Section 3 of Land Register
                        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Stt. Assign RUs to No. of Part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship Between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship Between Real Estate Objs and SAP-PM
        VZSORT - Sort Values for Object

    RECONTRACT_KEY - Root Node: Key Fields of LDB RECONTRACT
        VICN01 - Real Estate Contract: Contract Data
            VICN03 - Real Estate Contract: Posting Distribution
            VIKOKO - Real Estate Condition Header
                VZZKOPO - Condition Items Table
            VIMIUH - Sales-Based Rental Agreement: Contracted Sales
                VIMIUI - Sales-Based Grading Lease-Out Items
            VIMI54 - Real Estate: Time-dependent Adjustment Data
            VIMI55 - Index Data for Lease-Out (Time-Dependent)
            RFVILSP - Dummy Node: Time Dependence
            VZGPO - Partner/Role Object Relationship
            VIOB01 - Business Entities
                VIOB02 - Property Master Data
                VIOB03 - Real Estate Building Master
                VIMI01 - Rental Unit - Master Data
                    VIMIMV - Lease-Out
            VIOBOV - Assignment Table for RE to Standard Objects