SAP VIRPS405 Building Table
Overview
VIRPS405 is a standard SAP S/4HANA table that stores Building data. There are total 113 fields in the VIRPS405 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRPS405 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 VIRPS405 to other SAP tables and standard CDS views available based on VIRPS405 table in S/4HANA 2020.
Techincal Settings of VIRPS405
Below are technical details of the table VIRPS405
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRPS405 Fields
The following table gives you an overview of the fields available in VIRPS405
| 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 |
| SGENR_04 | Building Number | SGENR | VIOB03 | CHAR | 8 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SGENR | Building Number | SGENR | VIOB03 | 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 |
| 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 | |
| ANZGE | No. of buildings | VVAGE | 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 | |
| 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 | KOSTL | * | CHAR | 10 |
| ADRNR | Object number (virtual object) | SOBJNR | * | NUMC | 10 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| PRCTR | Profit Center | PRCTR | * | CHAR | 10 |
| STTXT_EXT | Status: Set by user | VVXSTXTEXT | CHAR | 40 | |
| STTXT_INT | Status: Set by system | VVXSTTXTIN | CHAR | 40 | |
| DVERKAUF | Date: Sale | VVDVERKAU2 | DATS | 8 | |
| DVRKPLAN | Date: Planned sale | VVDVRKPLA2 | DATS | 8 | |
| XUNART | Main usage type | VVXUNART | CHAR | 35 | |
| SUNUTZA | Main usage type | VVSUNART | TIV36 | CHAR | 8 |
| RGEBART | Type of building | RGEBART | TIV5A | NUMC | 2 |
| XGEBART | Type of building | XGEBART | CHAR | 50 | |
| JERBBAU | Heritable building right indicator | JERBBAU | * | CHAR | 1 |
| RGEBZUST | General condition of building | RGEBZUST | TIV83 | NUMC | 2 |
| XGEBZUST | Description of condition of building | XGEBZUST | CHAR | 50 | |
| YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | |
| YMODERN | Year of modernization | VVYMODERN | DATS | 8 | |
| YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | |
| DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | |
| BBAUW13 | Building value | BBAUW13 | CURR | 11 | |
| BBAUWAKT | Current building value | BBAUWAKT | CURR | 11 | |
| BBETRIEB | Production equipment value | BBETRIEB | CURR | 11 | |
| BAUSSEN | Grounds value | BAUSSEN | CURR | 11 | |
| BSCHADEN | Structural damage value | BSCHADEN | CURR | 11 | |
| BREPSTAU | Value of repair backlog | BREPSTAU | CURR | 11 | |
| BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 11 | |
| DBAUGENE | Building permit | DBAUGENE | DATS | 8 | |
| XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | |
| DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | |
| DFERTIG | Completion | DFERTIG | DATS | 8 | |
| DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | |
| FDACHFL | Attic space | FDACHFL | DEC | 8 | |
| RDAZUST | Condition of roof | RDAZUST | TIV83 | NUMC | 2 |
| XDAZUST | Condition of roof | XDAZUST | CHAR | 50 | |
| RFAZUST | Condition of facade | RFAZUST | TIV83 | NUMC | 2 |
| XFAZUST | Condition of facade | XFAZUST | CHAR | 50 | |
| BUBRA | Cubic Volume | BUBRA | DEC | 11 | |
| JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | |
| AUGESCH | Number of basements | AUGESCH | DEC | 2 | |
| DAKTBEST | Date active in portfolio | DAKTBEST | DATS | 8 | |
| DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | |
| DVORBES | Date of prior notice | DVORBES | DATS | 8 | |
| DANTBAU | Application for building permit | DANTBAU | DATS | 8 | |
| SGRUNDB | Land register number | SGRUNDB | VIGBUCH | NUMC | 8 |
| XGBVON | Land register district | XGBVON | CHAR | 25 | |
| XGETXT | Building text | XGETXT | CHAR | 60 | |
| BEINHEITW | Assessed value of building | BEINHEITW | CURR | 11 | |
| NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | |
| BVERSWRT | Insurable value amount | BVERSWRT | CURR | 11 | |
| RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | |
| XVERSWRT | Type of insurance value | XVERSWRT | CHAR | 25 | |
| SMIETSP | Representative list of rents assignment | SMIETSP | TIV20 | CHAR | 6 |
| XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | |
| SLAGK | Location class | SLAGK | TIV22 | NUMC | 2 |
| XLAGK | Description of location class for rep.list of rents | XLAGK | CHAR | 30 | |
| RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | |
| JNURJAHR | Indicator: Only regard construction date in terms of years | VVJNURJ | CHAR | 1 | |
| DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | |
| PROFL | Settlement Profile | APROF | TKB1A | CHAR | 6 |
| DNUTZEND | End of usage | VVDNUTZEND | DATS | 8 | |
| DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | |
| DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | |
| NSTCKLFT | Number of highest floor reached by elevator | VVNSTCKLF2 | CHAR | 3 | |
| BANZGE | Number of floors | VVBANZGE | DEC | 4 | |
| RPGENR | Building no. of hierarchical superior building part | VVRPGENR | VIOB03 | CHAR | 8 |
| XPGENR | Building text | XGETXT | CHAR | 60 | |
| SMERKMA | Fixtures and Fittings Characteristics | SMERKMA | TIV71 | NUMC | 3 |
| XMERKMA | Description of characteristic | XMERKMA | CHAR | 50 | |
| ANLN1 | Main Asset Number | ANLN1 | ANLH | CHAR | 12 |
| ANLN2 | Asset Subnumber | ANLN2 | ANLA | CHAR | 4 |
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 VIRPS405
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRPS405 | ANLN1 | : | ANLH |
| VIRPS405 | ANLN2 | : | ANLA |
| VIRPS405 | BUKRS | : | T001 |
| VIRPS405 | BUKRS_01 | : | T001 |
| VIRPS405 | FEINS | : | T006 |
| VIRPS405 | GSBER | : | TGSB |
| VIRPS405 | GSBER_02 | : | TGSB |
| VIRPS405 | MANDT | : | T000 |
| VIRPS405 | OBJNR | : | ONR00 |
| VIRPS405 | PERIV | : | T009 |
| VIRPS405 | PROFL | : | TKB1A |
| VIRPS405 | RDAZUST | : | TIV83 |
| VIRPS405 | REINS | : | T006 |
| VIRPS405 | RFAZUST | : | TIV83 |
| VIRPS405 | RGEBART | : | TIV5A |
| VIRPS405 | RGEBZUST | : | TIV83 |
| VIRPS405 | RPGENR | : | VIOB03 |
| VIRPS405 | SFLART | : | TIV08 |
| VIRPS405 | SGENR | : | VIOB03 |
| VIRPS405 | SGENR_04 | : | VIOB03 |
| VIRPS405 | SGRUNDB | : | VIGBUCH |
| VIRPS405 | SLAGK | : | TIV22 |
| VIRPS405 | SMERKMA | : | TIV71 |
| VIRPS405 | SMIETSP | : | TIV20 |
| VIRPS405 | SUNUTZA | : | TIV36 |
| VIRPS405 | SWENR | : | VIOB01 |
| VIRPS405 | SWENR_03 | : | VIOB01 |
| VIRPS405 | USRCUKY1 | : | TCURC |
| VIRPS405 | USRCUKY2 | : | TCURC |
| VIRPS405 | USRUNIT1 | : | T006 |
| VIRPS405 | USRUNIT2 | : | T006 |
| VIRPS405 | WAERS | : | TCURC |