SAP VIRPS406 Rental units Table
Overview
VIRPS406 is a standard SAP S/4HANA table that stores Rental units data. There are total 122 fields in the VIRPS406 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRPS406 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 VIRPS406 to other SAP tables and standard CDS views available based on VIRPS406 table in S/4HANA 2020.
Techincal Settings of VIRPS406
Below are technical details of the table VIRPS406
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRPS406 Fields
The following table gives you an overview of the fields available in VIRPS406
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | Version number in the information structure | VRSIO | * | CHAR | 3 |
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| BUKRS_01 | Company Code | BUKRS | T001 | CHAR | 4 |
| GSBER_02 | Business Area | GSBER | TGSB | CHAR | 4 |
| SWENR_03 | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SGRNR_04 | Land Number for BE | SGRNR | VIOB02 | CHAR | 8 |
| SGENR_05 | Building Number | SGENR | VIOB03 | CHAR | 8 |
| SMENR_06 | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SGRNR | Land Number for BE | SGRNR | VIOB02 | CHAR | 8 |
| SGENR | Building: number | VVSGENR | VIOB03 | CHAR | 8 |
| SMENR | Rental unit: number | VVSMENR | VIMI01 | CHAR | 8 |
| PERIV | Fiscal Year Variant | PERIV | T009 | CHAR | 2 |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | |
| USRUNIT1 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USRUNIT2 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USRCUKY1 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USRCUKY2 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| REINS | Unit for cubic volume | REINS | T006 | UNIT | 3 |
| XORT | Address: City | VVXORT | CHAR | 35 | |
| XPLZ | Address: Postal code | VVXPLZ | CHAR | 10 | |
| XSTRASSE | Address: Street/house number | VVXSTRASSE | CHAR | 35 | |
| ANZME | Number of rental units | VVAME | DEC | 6 | |
| USR02 | User-defined field 1 for 10 characters | USRCHAR101 | CHAR | 10 | |
| USR03 | User-defined field 2 for 10 characters | USRCHAR102 | CHAR | 10 | |
| USR00 | User-defined field 1 for 20 characters | USRCHAR201 | CHAR | 20 | |
| USR01 | User field 2 for 20 characters | USRCHAR202 | CHAR | 20 | |
| USR08 | User field 1 for date | USRDATE1 | DATS | 8 | |
| USR09 | User field 2 for date | USRDATE2 | DATS | 8 | |
| USR10 | User field 1 indicator for evaluations | USRFLAG1 | CHAR | 1 | |
| USR11 | User field 2 indicator for evaluations | USRFLAG2 | CHAR | 1 | |
| USR04 | User field 1 for set (length 103) | USRQUAN131 | QUAN | 13 | |
| USR05 | User field 2 for set (length 10.3) | USRQUAN132 | QUAN | 13 | |
| USR06 | User field 1 for values (length 10.3) | USRCURR131 | CURR | 13 | |
| USR07 | User field 2 for values (length 10.3) | USRCURR132 | CURR | 13 | |
| FBEZUG | Reference area for calculation of amounts per area unit | VVFBEZUG | QUAN | 15 | |
| FQMFLART | Area of area type | VVBFLART | QUAN | 14 | |
| DSFLART | Area: effective from | VVDSFLART | DATS | 8 | |
| SFLART | Area type | SFLART | TIV08 | NUMC | 4 |
| KOSTL | Cost center: name | VVXKOSTL | * | CHAR | 10 |
| DATAB | Cost center: effective from_ | VVDKOSTL | DATS | 8 | |
| ADRNR | Object number (virtual object) | SOBJNR | * | NUMC | 10 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| PRCTR | Profit Center | PRCTR | * | CHAR | 10 |
| STTXT_EXT | Status: Set by user | VVXSTXTEXT | CHAR | 40 | |
| STTXT_INT | Status: Set by system | VVXSTTXTIN | CHAR | 40 | |
| XMETXT | Text for rental unit | VVXMETXT | CHAR | 30 | |
| SKOART | Condition: Type | VVSKOART | TZK01 | NUMC | 4 |
| BKOND | Condition: amount | VVBKOND | CURR | 13 | |
| DGULTAB | Condition: effective from | VVDKOND | DATS | 8 | |
| SNUNR | Rental unit external usage type | SNUNR | TIV01 | NUMC | 4 |
| XNUNR | Rental unit usage type (text) | VVXNUNR | CHAR | 30 | |
| SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | |
| SRAART | Room type | SRAART | TIV09 | NUMC | 2 |
| BRAART | Number of rooms per room type | BRAART | DEC | 3 | |
| SMERKMA | Fixtures and Fittings Characteristics | SMERKMA | TIV71 | NUMC | 3 |
| XMERKMA | Characteristic | VVXMERKMA | CHAR | 30 | |
| SSTOCKW | Floor | VVSSTOCKW | TIV37 | NUMC | 3 |
| XSTOCKW | Floor (text) | VVXSTOCKW | CHAR | 15 | |
| RLGESCH | Location on Floor | RLGESCH | TIV38 | CHAR | 2 |
| XLGESCH | Location in floor (text) | VVXLGESCH | CHAR | 15 | |
| DBEZU | Date: First usage | VVDBEZU | DATS | 8 | |
| SABRG | Apportionment unit: type | VVSABRG2 | TIV07 | NUMC | 4 |
| DGAB | Apportionment unit: effective from | VVDGAB2 | DATS | 8 | |
| BABRE | Apportionment units | VVBUMLEINH | QUAN | 6 | |
| TXT04 | Occupancy type: short text | VVXJ_TXT04 | CHAR | 4 | |
| TXT30 | Occupancy type (text) | VVXJ_TXT30 | CHAR | 30 | |
| BELEAB | Occupancy type: effet.from | VVDBELEAB | DATS | 8 | |
| BELEBIS | Occupancy type: eff. to | VVDBELEBIS | DATS | 8 | |
| DBEGEH | Last access: date | VVDBEGEH | DATS | 8 | |
| XBEGEH | Last inspection: by | VVXBEGEH | CHAR | 15 | |
| PERHOE | Increase: percentage | VVPERHOE2 | DEC | 10 | |
| RPROZGRD | Increase: Reason for difference | VVRPROZGRD | TIV43 | CHAR | 2 |
| XPROZGRD | Increase: Reason for difference | VVXPROZGRD | CHAR | 15 | |
| SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | |
| AZIMM | Number of rooms | VVAZIMM | DEC | 6 | |
| AHALBZI | Number of half rooms | VVAHALBZI | DEC | 6 | |
| XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | |
| JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | |
| ABNNR | Settlement firm: number | VVABNNR | CHAR | 20 | |
| STECHEM | Settlement firm: Evaluation group | VVSTECHEM | CHAR | 13 | |
| SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | TIV37 | NUMC | 3 |
| JVORSTEIG | Input tax deduction for vacancy | JVORSTEIG | CHAR | 1 | |
| RFAKT | Conversion factor for fractional share of property | VVXFAKT | CHAR | 6 | |
| JKONDMV | Cond.transfer RA: indicator | VVJKONDMV2 | CHAR | 1 | |
| PKONDMV | Cond.transfer LO: percent | VVPKONDMV2 | DEC | 5 | |
| DFSTRBIS | Date: Cash flow until | VVDFSTRBI2 | DATS | 8 | |
| JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | |
| DHPZSAKT | CH rent adj.:Date of mort.loan rate status for current rent | VVDHPZSAK2 | DATS | 8 | |
| DUTBKAKT | CH rnt adj.:Dte maint./oper.costs index status for new rent | VVDUTBKAK2 | DATS | 8 | |
| DTEURAKT | CH rnt adj.:Dte of living stndrd index status for curr.rent | VVDTEURAK2 | DATS | 8 | |
| SMIETSP | Representative list of rents assignment | SMIETSP | TIV20 | CHAR | 6 |
| XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | |
| PZUABSP | Representative list of rents: surcharge/reduction | VVPZUABSP2 | DEC | 10 | |
| SLAGK | Location class | SLAGK | TIV22 | NUMC | 2 |
| XLAGK | Representative list of rents: locat.class | VVXLAGK | CHAR | 30 | |
| SAUSTKL | Fixtures and fittings category | SAUSKL | TIV23 | NUMC | 2 |
| XAUSTKL | Represent. list of rents: Fixture/fitting category | VVXXAUSTKL | CHAR | 15 | |
| DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | |
| RBELBIND | Occupancy obligation key | RBELBIND | TIV31 | CHAR | 4 |
| XBELBIND | Occupancy obligation: to | VVXBELBIND | CHAR | 15 | |
| DBINDBIS | Occupancy obligation: until | VVDBINDBIS | DATS | 8 | |
| SBWNR | Reservation application number of a rental unit | VVXBWNR | CHAR | 7 | |
| SPARTNR | Partner number | SPARTNR | SPRT1 | CHAR | 10 |
| XPARTNR | Name of applicant for a rental unit | VVXPARTNRB | CHAR | 35 | |
| XNNPART | Last name of applicant | VVNNPART | CHAR | 20 | |
| DRESAB | Date: Reserved from | DRESA | DATS | 8 | |
| DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | |
| UMBRAUM | Cubic Volume | VVBUBRA | QUAN | 11 | |
| SGEBT | Part of Building | SGEBT | TIV12 | CHAR | 2 |
| XGEBT | Building: part | VVXGEBT | CHAR | 15 |
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 VIRPS406
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRPS406 | BUKRS | : | T001 |
| VIRPS406 | BUKRS_01 | : | T001 |
| VIRPS406 | FEINS | : | T006 |
| VIRPS406 | GSBER | : | TGSB |
| VIRPS406 | GSBER_02 | : | TGSB |
| VIRPS406 | MANDT | : | T000 |
| VIRPS406 | MEINS | : | T006 |
| VIRPS406 | OBJNR | : | ONR00 |
| VIRPS406 | PERIV | : | T009 |
| VIRPS406 | RBELBIND | : | TIV31 |
| VIRPS406 | REINS | : | T006 |
| VIRPS406 | RLGESCH | : | TIV38 |
| VIRPS406 | RPROZGRD | : | TIV43 |
| VIRPS406 | SABRG | : | TIV07 |
| VIRPS406 | SAUSTKL | : | TIV23 |
| VIRPS406 | SFLART | : | TIV08 |
| VIRPS406 | SGEBT | : | TIV12 |
| VIRPS406 | SGENR | : | VIOB03 |
| VIRPS406 | SGENR_05 | : | VIOB03 |
| VIRPS406 | SGRNR | : | VIOB02 |
| VIRPS406 | SGRNR_04 | : | VIOB02 |
| VIRPS406 | SKOART | : | TZK01 |
| VIRPS406 | SLAGK | : | TIV22 |
| VIRPS406 | SMENR | : | VIMI01 |
| VIRPS406 | SMENR_06 | : | VIMI01 |
| VIRPS406 | SMERKMA | : | TIV71 |
| VIRPS406 | SMIETSP | : | TIV20 |
| VIRPS406 | SNUNR | : | TIV01 |
| VIRPS406 | SPARTNR | : | SPRT1 |
| VIRPS406 | SRAART | : | TIV09 |
| VIRPS406 | SSTCKBIS | : | TIV37 |
| VIRPS406 | SSTOCKW | : | TIV37 |
| VIRPS406 | SWENR | : | VIOB01 |
| VIRPS406 | SWENR_03 | : | VIOB01 |
| VIRPS406 | USRCUKY1 | : | TCURC |
| VIRPS406 | USRCUKY2 | : | TCURC |
| VIRPS406 | USRUNIT1 | : | T006 |
| VIRPS406 | USRUNIT2 | : | T006 |
| VIRPS406 | WAERS | : | TCURC |