VIRPS406 SAP (Rental units) Table details
Dictionary Type: Table
Description: Rental units
Description: Rental units
Table field list including key, data, relationships and ABAP select examples
VIRPS406 is a standard SAP Table which is used to store Rental units data and is available within R/3 SAP systems depending on the version and release level.
The VIRPS406 table consists of various fields, each holding specific information or linking keys about Rental units data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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: Not classified
SAP VIRPS406 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 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
BUKRS_01 | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER_02 | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SWENR_03 | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SGRNR_04 | Property Number for BE | SGRNR | CHAR | 8 | VIOB02 | SGRNR | SGRNR | GRS | MCGR |
SGENR_05 | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
SMENR_06 | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SGRNR | Property Number for BE | SGRNR | CHAR | 8 | VIOB02 | SGRNR | SGRNR | GRS | MCGR |
SGENR | Building: number | VVSGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | |
SMENR | Rental unit: number | VVSMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
USRUNIT1 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USRUNIT2 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USRCUKY1 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USRCUKY2 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
FEINS | Area unit | FEINS | UNIT | 3 | T006 | CUNIT | MEINS | FEH | |
REINS | Unit for cubic volume | REINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
XORT | Address: City | VVXORT | CHAR | 35 | TEXT35 | ||||
XPLZ | Address: Postal code | VVXPLZ | CHAR | 10 | PSTLZ | ||||
XSTRASSE | Address: Street/house number | VVXSTRASSE | CHAR | 35 | TEXT35 | ||||
ANZME | Number of rental units | VVAME | DEC | 6 | DEC6 | ||||
USR02 | User-defined field 1 for 10 characters | USRCHAR101 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User-defined field 2 for 10 characters | USRCHAR102 | CHAR | 10 | USRCHAR10 | ||||
USR00 | User-defined field 1 for 20 characters | USRCHAR201 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field 2 for 20 characters | USRCHAR202 | CHAR | 20 | USRCHAR20 | ||||
USR08 | User field 1 for date | USRDATE1 | DATS | 8 | USRDATE | ||||
USR09 | User field 2 for date | USRDATE2 | DATS | 8 | USRDATE | ||||
USR10 | User field 1 indicator for evaluations | USRFLAG1 | CHAR | 1 | FLAG | ||||
USR11 | User field 2 indicator for evaluations | USRFLAG2 | CHAR | 1 | FLAG | ||||
USR04 | User field 1 for set (length 10,3) | USRQUAN131 | QUAN | 13(3) | USRQUAN13 | ||||
USR05 | User field 2 for set (length 10.3) | USRQUAN132 | QUAN | 13(3) | USRQUAN13 | ||||
USR06 | User field 1 for values (length 10.3) | USRCURR131 | CURR | 13(3) | USRCURR13 | ||||
USR07 | User field 2 for values (length 10.3) | USRCURR132 | CURR | 13(3) | USRCURR13 | ||||
FBEZUG | Reference area for calculation of amounts per area unit | VVFBEZUG | QUAN | 15(2) | VVFBEZUG | ||||
FQMFLART | Area of area type | VVBFLART | QUAN | 14(4) | VVBFLART | ||||
DSFLART | Area: effective from | VVDSFLART | DATS | 8 | DATS | ||||
SFLART | Area type | SFLART | NUMC | 4 | TIV08 | SFLART | |||
KOSTL | Cost center: name | VVXKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
DATAB | Cost center: effective from_ | VVDKOSTL | DATS | 8 | DATUM | ||||
ADRNR | Object number (virtual object) | SOBJNR | NUMC | 10 | Assigned to domain | SOBJNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
STTXT_EXT | Status: Set by user | VVXSTXTEXT | CHAR | 40 | CHAR40 | ||||
STTXT_INT | Status: Set by system | VVXSTTXTIN | CHAR | 40 | CHAR40 | ||||
XMETXT | Text for rental unit | VVXMETXT | CHAR | 30 | XMBEZ | ||||
SKOART | Condition: Type | VVSKOART | NUMC | 4 | TZK01 | SKOART | UMK | ||
BKOND | Condition: amount | VVBKOND | CURR | 13(2) | WRTV7 | ||||
DGULTAB | Condition: effective from | VVDKOND | DATS | 8 | DDAT | ||||
SNUNR | Rental unit external usage type | SNUNR | NUMC | 4 | TIV01 | SNUNR | |||
XNUNR | Rental unit usage type (text) | VVXNUNR | CHAR | 30 | CHAR30 | ||||
SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | SALTNR | ||||
SRAART | Room type | SRAART | NUMC | 2 | TIV09 | SRAART | |||
BRAART | Number of rooms per room type | BRAART | DEC | 3 | DEC3 | ||||
SMERKMA | Fixtures and Fittings Characteristics | SMERKMA | NUMC | 3 | TIV71 | SMERKMA | |||
XMERKMA | Characteristic | VVXMERKMA | CHAR | 30 | XTEXT30 | ||||
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | VVSSTOCKW | |||
XSTOCKW | Floor (text) | VVXSTOCKW | CHAR | 15 | CHAR15 | ||||
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | ALPHA | RLGESCH | ||
XLGESCH | Location in floor (text) | VVXLGESCH | CHAR | 15 | CHAR15 | ||||
DBEZU | Date: First usage | VVDBEZU | DATS | 8 | DDAT | ||||
SABRG | Apportionment unit: type | VVSABRG2 | NUMC | 4 | TIV07 | SABRG | ARG | ||
DGAB | Apportionment unit: effective from | VVDGAB2 | DATS | 8 | DDAT | ||||
BABRE | Apportionment units | VVBUMLEINH | QUAN | 6(2) | VVBUMLEINH | ||||
TXT04 | Occupancy type: short text | VVXJ_TXT04 | CHAR | 4 | CHAR04 | ||||
TXT30 | Occupancy type (text) | VVXJ_TXT30 | CHAR | 30 | CHAR30 | ||||
BELEAB | Occupancy type: effet.from | VVDBELEAB | DATS | 8 | DATUM | ||||
BELEBIS | Occupancy type: eff. to | VVDBELEBIS | DATS | 8 | DATUM | ||||
DBEGEH | Last access: date | VVDBEGEH | DATS | 8 | DDAT | ||||
XBEGEH | Last inspection: by | VVXBEGEH | CHAR | 15 | XKBEZ | ||||
PERHOE | Increase: percentage | VVPERHOE2 | DEC | 10(2) | DEC8_2 | ||||
RPROZGRD | Increase: Reason for difference | VVRPROZGRD | CHAR | 2 | TIV43 | RPROZGRD | |||
XPROZGRD | Increase: Reason for difference | VVXPROZGRD | CHAR | 15 | CHAR15 | ||||
SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | SMOEB | ||||
AZIMM | Number of rooms | VVAZIMM | DEC | 6 | DEC6 | ||||
AHALBZI | Number of half rooms | VVAHALBZI | DEC | 6 | DEC6 | ||||
XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | ALPHA | VVXSTANDNR | |||
JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | JANE | ||||
ABNNR | Settlement firm: number | VVABNNR | CHAR | 20 | TEXT20 | ||||
STECHEM | Settlement firm: Evaluation group | VVSTECHEM | CHAR | 13 | STECHEM | ||||
SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | NUMC | 3 | TIV37 | VVSSTOCKW | |||
JVORSTEIG | Input tax deduction for vacancy | JVORSTEIG | CHAR | 1 | OPTIERT | ||||
RFAKT | Conversion factor for fractional share of property | VVXFAKT | CHAR | 6 | CHAR6 | ||||
JKONDMV | Cond.transfer RA: indicator | VVJKONDMV2 | CHAR | 1 | XFELD | ||||
PKONDMV | Cond.transfer LO: percent | VVPKONDMV2 | DEC | 5(2) | PRZ32 | ||||
DFSTRBIS | Date: Cash flow until | VVDFSTRBI2 | DATS | 8 | DATUM | ||||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
DHPZSAKT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAK2 | DATS | 8 | DATUM | ||||
DUTBKAKT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAK2 | DATS | 8 | DATUM | ||||
DTEURAKT | CH rnt adj.:Dte of living stndrd index status for curr.rent | VVDTEURAK2 | DATS | 8 | DATUM | ||||
SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | TIV20 | SMIETSP | |||
XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | CHAR15 | ||||
PZUABSP | Representative list of rents: surcharge/reduction | VVPZUABSP2 | DEC | 10(2) | DEC8_2 | ||||
SLAGK | Location class | SLAGK | NUMC | 2 | TIV22 | SLAGK | |||
XLAGK | Representative list of rents: locat.class | VVXLAGK | CHAR | 30 | XMBEZ | ||||
SAUSTKL | Fixtures and fittings category | SAUSKL | NUMC | 2 | TIV23 | SAUSKL | |||
XAUSTKL | Represent. list of rents: Fixture/fitting category | VVXXAUSTKL | CHAR | 15 | CHAR15 | ||||
DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | DATUM | ||||
RBELBIND | Occupancy obligation key | RBELBIND | CHAR | 4 | TIV31 | RBELBIND | |||
XBELBIND | Occupancy obligation: to | VVXBELBIND | CHAR | 15 | CHAR15 | ||||
DBINDBIS | Occupancy obligation: until | VVDBINDBIS | DATS | 8 | DATUM | ||||
SBWNR | Reservation application number of a rental unit | VVXBWNR | CHAR | 7 | VVXBWNR | OWK | |||
SPARTNR | Partner number | SPARTNR | CHAR | 10 | SPRT1 | SPARTNR | PNN | ||
XPARTNR | Name of applicant for a rental unit | VVXPARTNRB | CHAR | 35 | CHAR35 | ||||
XNNPART | Last name of applicant | VVNNPART | CHAR | 20 | TEXT20 | ||||
DRESAB | Date: Reserved from | DRESA | DATS | 8 | DDAT | ||||
DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | DDAT | ||||
UMBRAUM | Cubic Volume | VVBUBRA | QUAN | 11(3) | VVBUBRA | ||||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | SGEBT | |||
XGEBT | Building: part | VVXGEBT | CHAR | 15 | CHAR15 |
Key field | Non-key field |
How do I retrieve data from SAP table VIRPS406 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIRPS406 to SELECT all data from the tableDATA: WA_VIRPS406 TYPE VIRPS406.
SELECT SINGLE *
FROM VIRPS406
INTO CORRESPONDING FIELDS OF WA_VIRPS406
WHERE...
How to access SAP table VIRPS406
Within an ECC or HANA version of SAP you can also view further information about VIRPS406 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