VIMI01 SAP (Rental unit - Master data) Table details
Dictionary Type: Table
Description: Rental unit - Master data
Description: Rental unit - Master data
Table field list including key, data, relationships and ABAP select examples
VIMI01 is a standard SAP Table which is used to store Rental unit - Master data data and is available within R/3 SAP systems 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. .
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
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | SMENR | SMENR | MEH | MCME | |
SGRNR | Property Number for BE | SGRNR | CHAR | 8 | VIOB02 | SGRNR | SGRNR | GRS | MCGR |
SGENR | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
SGEBSWENR | BE no.of rental unit to which the RU is linked | SGEBSWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | ||
SGEBSMENR | RU no. of rental unit to which the RU is linked | SGEBSMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | ||
SHEIZNR | Real Estate heating system number | SHEIZNR | NUMC | 4 | SHEIZNR | ||||
SNUNR | Rental unit external usage type | SNUNR | NUMC | 4 | TIV01 | SNUNR | |||
DBEZU | Date of initial usage | DBEZU | DATS | 8 | DDAT | ||||
DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | DATUM | ||||
UMBRAUM | Cubic Volume | BUBRA | DEC | 11(3) | DEC8_3 | ||||
AZIMM | Number of rooms | AZIMM | DEC | 3 | DEC3 | ||||
AHALBZI | Number of half rooms | AHALBZI | DEC | 2 | DEC2 | ||||
STOCK | Dummy (previously storey, replaced by VVSSTOCKW) | RGESCH | CHAR | 2 | CHAR2 | ||||
SBELART | Occupancy type indicator | SBELA | NUMC | 1 | SBELA | ||||
SHEIZART | Heating type | SHEIZ | CHAR | 1 | SHEIZ | ||||
DRESAB | Date: Reserved from | DRESA | DATS | 8 | DDAT | ||||
DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | DDAT | ||||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | SGEBT | |||
SBWNR | Application number | SBWNR | NUMC | 7 | VIMI11 | SBWNR | OWK | ||
XAUSTKL | Fixtures and fittings category | SAUSKL | NUMC | 2 | TIV23 | SAUSKL | |||
XLAGE | Location class | SLAGK | NUMC | 2 | TIV22 | SLAGK | |||
SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | SMOEB | ||||
STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | STECHEM | ||||
SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | SALTNR | ||||
DBEGEH | Date of last RU inspection | DBEGEH | DATS | 8 | DDAT | ||||
XBEGEH | Inspected by | XBEGEH | CHAR | 15 | XKBEZ | ||||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | JLOESCH | ||||
PZUABSP | Surcharge or reduction for representative list of rents | PZUABSP | DEC | 4(2) | PZUABSP | ||||
PERHOE | Percentage rate increase | PERHOE | DEC | 5(2) | DEC3_2 | ||||
RPROZGRD | Reason for variance in rate of percentage increase | RPROZGRD | CHAR | 2 | TIV43 | RPROZGRD | |||
DBINDBIS | Obligation period until | DBINDBIS | DATS | 8 | DATUM | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
RBELBIND | Occupancy obligation key | RBELBIND | CHAR | 4 | TIV31 | RBELBIND | |||
RLIFT | Type of elevator installation | RLIFT | NUMC | 2 | TIV32 | RLIFT | |||
RMEDIEN | Media reception | RMEDIEN | NUMC | 3 | TIV33 | RMEDIEN | |||
RWASSER | Type of water mains connection | RWASSER | NUMC | 2 | TIV34 | RWASSER | |||
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | ALPHA | RLGESCH | ||
JVORSTEIG | Input tax deduction for vacancy | JVORSTEIG | CHAR | 1 | OPTIERT | ||||
SADRME | Object number of rental unit for address purposes | SADRME | NUMC | 10 | SANO1 | SOBJNR | |||
SNKS | Service Charge Collector Number | SNKS | CHAR | 22 | ONR00 | J_OBJNR | |||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | TEXT20 | ||||
XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | ALPHA | VVXSTANDNR | |||
JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | JANE | ||||
RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | VVRFAKT | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | VVSSTOCKW | |||
JKONDMV | Transfer conditions to RU when lease-out expires? | VVJKONDMV | CHAR | 1 | XFELD | ||||
PKONDMV | Percentage rate for transfer of terms from LO to RU | VVPKONDMV | DEC | 5(2) | PRZ32 | ||||
DFSTRBIS | Date up to when the rental unit cash flow is created | VVDFSTRBIS | DATS | 8 | DATUM | ||||
SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | NUMC | 3 | TIV37 | VVSSTOCKW | |||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
DHPZSAKT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAKT | DATS | 8 | DATUM | ||||
DUTBKAKT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAKT | DATS | 8 | DATUM | ||||
DTEURAKT | CH rnt adj.:Dte of living stndrd index status for curr.rent | VVDTEURAKT | DATS | 8 | DATUM | ||||
BRDBRTZZ | CH rent adj: Actual gross yield earned | VVBRDBRTZZ | DEC | 10(7) | DECV3_7 | ||||
BRDBRTKD | Marginal Gross Yield | VVBRDBRTKD | DEC | 10(7) | DECV3_7 | ||||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
XMETXT | Text for rental unit | VVXMETXT2 | CHAR | 30 | XMBEZ | ||||
SBASTEU | Swiss rent adj.: Base year for standard of living index | VVSBASTEU | NUMC | 4 | Assigned to domain | GJAHR | BASJHR | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
DRESTAUR | Date of reconstruction/extensive modernization | VVDRESTAUR | DATS | 8 | DATUM | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | DATUM | ||||
KOEIGR | Account determination key for account determination | VVWERTN_AD | CHAR | 10 | TIVC6 | VVWERTN_AD | |||
BERGRP | Authorization group | VVBERGRP | CHAR | 40 | VVBERGRP | ||||
SPOSINMSP | Base value for grouping RU in RLR group | VVSPOSINMSP | CHAR | 1 | VVSADJBASE | ||||
PPOSINMSP | Percentage value for grouping RU in RLR category group | VVPPOSINMSP | DEC | 5(2) | DECV3_2 | ||||
DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | DATUM | ||||
DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | DATUM | ||||
SGRUNDB | Land register number | SGRUNDB | NUMC | 8 | VIGBUCH | SGRUNDB | GBS | ||
PAUSFW | Service charge stt. apport.loss risk percentage surcharge | VVPAUSFW | DEC | 5(2) | DEC3_2 | ||||
RESADXEYECATCH | Short Description of Real Estate Object on Offer | RESADXEYECATCH | CHAR | 85 | RESADXEYECATCH | ||||
RESADJINTERNET | Indicator Internet Release | RESADJINTERNET | CHAR | 1 | XFELD | ||||
REFANG | Reference offer | VVREFANG | CHAR | 13 | VIMI33 | ALPHA | RANL | MIA | |
.INCLU--AP | 0 | ||||||||
REFNO | External Reference Number | HB_REFNO | CHAR | 24 | HBS_REFNO | ||||
HOMTYP | Possible Sales Unit Types | HB_HOMTYP | CHAR | 8 | CHBSHTP | HBS_HOMTYP | |||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | CHBSNCM | HBS_MTLAUR | |||
SPRMUM | Sales Phase Premium | HB_SPRMUM | CURR | 12(2) | HBS_PRICE | ||||
LPRMUM | Location Premium | HB_LPRMUM | CURR | 12(2) | HBS_PRICE | ||||
HB_MARKER | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PRMTXT1 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PRMTXT2 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PRMTXT3 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PRMTXT4 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PRMTXT5 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PRMTXT6 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBSSPH | HBS_PHASE | |||
.INCLU--AP | 0 | ||||||||
ROTYPE | Rental Object Type | REBDROTYPE | CHAR | 2 | REBDROTYPE | REBDROTYPE | |||
ROTYPEEX | OBSOLETE: Type of Rental Object (External) | REBDROTYPEEX | CHAR | 1 | REBDROTYPEEX | ||||
FLID | OBSOLETE: Alternative ID for Rental Object (from CRE) | REBDALTROID | CHAR | 13 | REBDALTROID | ||||
CANBECOMMON | Common Usage Possible | REBDCANBECOMMON | CHAR | 1 | RECABOOL | ||||
FIRSTPOSTING | Obsolete: Date of First Posting | REBDFIRSTPOSTING | DATS | 8 | RECADATE | ||||
VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | RECADATEBEG | ||||
VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | REDAT | RECADATEEND | |||
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | RECACREATIONTYPE | ||||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | Assigned to domain | XUBNAME | USER_COMP | ||
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | Assigned to domain | XUBNAME | USER_COMP | ||
CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | RECADATE | ||||
CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 | RECADATE |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects