VIRPS405 SAP (Building) Table details
Dictionary Type: Table
Description: Building
Description: Building
Table field list including key, data, relationships and ABAP select examples
VIRPS405 is a standard SAP Table which is used to store Building data and is available within R/3 SAP systems depending on the version and release level.
The VIRPS405 table consists of various fields, each holding specific information or linking keys about Building 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 VIRPS405 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 |
SGENR_04 | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
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 |
SGENR | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
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 | ||
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 | ||||
ANZGE | No. of buildings | VVAGE | 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 | ||||
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 | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ADRNR | Object number (virtual object) | SOBJNR | NUMC | 10 | Assigned to domain | SOBJNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
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 | ||||
DVERKAUF | Date: Sale | VVDVERKAU2 | DATS | 8 | DATUM | ||||
DVRKPLAN | Date: Planned sale | VVDVRKPLA2 | DATS | 8 | DATUM | ||||
XUNART | Main usage type | VVXUNART | CHAR | 35 | XTEXT35 | ||||
SUNUTZA | Main usage type | VVSUNART | CHAR | 8 | TIV36 | VVSUNART | |||
RGEBART | Type of building | RGEBART | NUMC | 2 | TIV5A | SOBJART | |||
XGEBART | Type of building | XGEBART | CHAR | 50 | XTEXT50 | ||||
JERBBAU | Heritable building right indicator | JERBBAU | CHAR | 1 | Assigned to domain | SOBJERBBAU | |||
RGEBZUST | General condition of building | RGEBZUST | NUMC | 2 | TIV83 | VVRZUSTAND | |||
XGEBZUST | Description of condition of building | XGEBZUST | CHAR | 50 | XTEXT50 | ||||
YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | DATUM | ||||
YMODERN | Year of modernization | VVYMODERN | DATS | 8 | DATUM | ||||
YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | DATUM | ||||
DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | DDAT | ||||
BBAUW13 | Building value | BBAUW13 | CURR | 11(2) | WRBTR | ||||
BBAUWAKT | Current building value | BBAUWAKT | CURR | 11(2) | WRBTR | ||||
BBETRIEB | Production equipment value | BBETRIEB | CURR | 11(2) | WRBTR | ||||
BAUSSEN | Grounds value | BAUSSEN | CURR | 11(2) | WRBTR | ||||
BSCHADEN | Structural damage value | BSCHADEN | CURR | 11(2) | WRBTR | ||||
BREPSTAU | Value of repair backlog | BREPSTAU | CURR | 11(2) | WRBTR | ||||
BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 11(2) | WRBTR | ||||
DBAUGENE | Building permit | DBAUGENE | DATS | 8 | DDAT | ||||
XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | XMBEZ | ||||
DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | DDAT | ||||
DFERTIG | Completion | DFERTIG | DATS | 8 | DDAT | ||||
DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | DDAT | ||||
FDACHFL | Attic space | FDACHFL | DEC | 8(2) | DEC6_2 | ||||
RDAZUST | Condition of roof | RDAZUST | NUMC | 2 | TIV83 | VVRZUSTAND | |||
XDAZUST | Condition of roof | XDAZUST | CHAR | 50 | XTEXT50 | ||||
RFAZUST | Condition of facade | RFAZUST | NUMC | 2 | TIV83 | VVRZUSTAND | |||
XFAZUST | Condition of facade | XFAZUST | CHAR | 50 | XTEXT50 | ||||
BUBRA | Cubic Volume | BUBRA | DEC | 11(3) | DEC8_3 | ||||
JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | JANE | ||||
AUGESCH | Number of basements | AUGESCH | DEC | 2 | DEC2 | ||||
DAKTBEST | Date active in portfolio | DAKTBEST | DATS | 8 | DATUM | ||||
DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | DDAT | ||||
DVORBES | Date of prior notice | DVORBES | DATS | 8 | DDAT | ||||
DANTBAU | Application for building permit | DANTBAU | DATS | 8 | DATUM | ||||
SGRUNDB | Land register number | SGRUNDB | NUMC | 8 | VIGBUCH | SGRUNDB | GBS | ||
XGBVON | Land register district | XGBVON | CHAR | 25 | XTEXT25 | SH_GEM | |||
XGETXT | Building text | XGETXT | CHAR | 60 | XLBEZ | ||||
BEINHEITW | Assessed value of building | BEINHEITW | CURR | 11(2) | WRBTR | ||||
NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | GJAHR | GJAHR | |||
BVERSWRT | Insurable value amount | BVERSWRT | CURR | 11(2) | WRBTR | ||||
RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | RVERSWRT | ||||
XVERSWRT | Type of insurance value | XVERSWRT | CHAR | 25 | TEXT25 | ||||
SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | TIV20 | SMIETSP | |||
XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | CHAR15 | ||||
SLAGK | Location class | SLAGK | NUMC | 2 | TIV22 | SLAGK | |||
XLAGK | Description of location class for rep.list of rents | XLAGK | CHAR | 30 | XMBEZ | ||||
RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | VVRFAKT | ||||
JNURJAHR | Indicator: Only regard construction date in terms of years | VVJNURJ | CHAR | 1 | JANE | ||||
DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | DATUM | ||||
PROFL | Settlement profile | APROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
DNUTZEND | End of usage | VVDNUTZEND | DATS | 8 | DATUM | ||||
DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | DATUM | ||||
DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | DATUM | ||||
NSTCKLFT | Number of highest floor reached by elevator | VVNSTCKLF2 | CHAR | 3 | CHAR3 | ||||
BANZGE | Number of floors | VVBANZGE | DEC | 4(1) | DEC3_1 | ||||
RPGENR | Building no. of hierarchical superior building part | VVRPGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | ||
XPGENR | Building text | XGETXT | CHAR | 60 | XLBEZ | ||||
SMERKMA | Fixtures and Fittings Characteristics | SMERKMA | NUMC | 3 | TIV71 | SMERKMA | |||
XMERKMA | Description of characteristic | XMERKMA | CHAR | 50 | XTEXT50 | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 |
Key field | Non-key field |
How do I retrieve data from SAP table VIRPS405 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIRPS405 to SELECT all data from the tableDATA: WA_VIRPS405 TYPE VIRPS405.
SELECT SINGLE *
FROM VIRPS405
INTO CORRESPONDING FIELDS OF WA_VIRPS405
WHERE...
How to access SAP table VIRPS405
Within an ECC or HANA version of SAP you can also view further information about VIRPS405 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