VIRPS405 - Building
Building information is stored in SAP table VIRPS405.
It is part of development package FVVI in software component RE. This development package consists of objects that can be grouped under "R/3 appl.dev. for Financial Assets Management: Real estate".
It is part of development package FVVI in software component RE. This development package consists of objects that can be grouped under "R/3 appl.dev. for Financial Assets Management: Real estate".
Fields for table VIRPS405
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 3 | T000 |
SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
BUKRS_01 | Company Code | X | BUKRS | CHAR | 4 | T001 |
GSBER_02 | Business Area | X | GSBER | CHAR | 4 | TGSB |
SWENR_03 | Business Entity Number | X | SWENR | CHAR | 8 | VIOB01 |
SGENR_04 | Building Number | X | SGENR | CHAR | 8 | VIOB03 |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | |
SWENR | Business Entity Number | SWENR | CHAR | 8 | VIOB01 | |
SGENR | Building Number | SGENR | CHAR | 8 | VIOB03 | |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | |
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
USRUNIT1 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | |
USRUNIT2 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | |
USRCUKY1 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | |
USRCUKY2 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | |
FEINS | Area Unit | FEINS | UNIT | 3 | T006 | |
REINS | Unit for cubic volume | REINS | UNIT | 3 | T006 | |
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 | 4 | ||
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 10,3) | USRQUAN131 | QUAN | 7 | ||
USR05 | User field 2 for set (length 10.3) | USRQUAN132 | QUAN | 7 | ||
USR06 | User field 1 for values (length 10.3) | USRCURR131 | CURR | 7 | ||
USR07 | User field 2 for values (length 10.3) | USRCURR132 | CURR | 7 | ||
FQMFLART | Area of area type | VVBFLART | QUAN | 8 | ||
DSFLART | Area: effective from | VVDSFLART | DATS | 8 | ||
SFLART | Area type | SFLART | NUMC | 4 | TIV08 | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | * | |
ADRNR | Object number (virtual object) | SOBJNR | NUMC | 10 | * | |
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | |
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 | CHAR | 8 | TIV36 | |
RGEBART | Type of building | RGEBART | NUMC | 2 | TIV5A | |
XGEBART | Type of building | XGEBART | CHAR | 50 | ||
JERBBAU | Heritable building right indicator | JERBBAU | CHAR | 1 | * | |
RGEBZUST | General condition of building | RGEBZUST | NUMC | 2 | TIV83 | |
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 | 6 | ||
BBAUWAKT | Current building value | BBAUWAKT | CURR | 6 | ||
BBETRIEB | Production equipment value | BBETRIEB | CURR | 6 | ||
BAUSSEN | Grounds value | BAUSSEN | CURR | 6 | ||
BSCHADEN | Structural damage value | BSCHADEN | CURR | 6 | ||
BREPSTAU | Value of repair backlog | BREPSTAU | CURR | 6 | ||
BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 6 | ||
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 | 5 | ||
RDAZUST | Condition of roof | RDAZUST | NUMC | 2 | TIV83 | |
XDAZUST | Condition of roof | XDAZUST | CHAR | 50 | ||
RFAZUST | Condition of facade | RFAZUST | NUMC | 2 | TIV83 | |
XFAZUST | Condition of facade | XFAZUST | CHAR | 50 | ||
BUBRA | Cubic Volume | BUBRA | DEC | 6 | ||
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 | NUMC | 8 | VIGBUCH | |
XGBVON | Land register district | XGBVON | CHAR | 25 | ||
XGETXT | Building text | XGETXT | CHAR | 60 | ||
BEINHEITW | Assessed value of building | BEINHEITW | CURR | 6 | ||
NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | ||
BVERSWRT | Insurable value amount | BVERSWRT | CURR | 6 | ||
RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | ||
XVERSWRT | Type of insurance value | XVERSWRT | CHAR | 25 | ||
SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | TIV20 | |
XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | ||
SLAGK | Location class | SLAGK | NUMC | 2 | TIV22 | |
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 | CHAR | 6 | TKB1A | |
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 | 3 | ||
RPGENR | Building no. of hierarchical superior building part | VVRPGENR | CHAR | 8 | VIOB03 | |
XPGENR | Building text | XGETXT | CHAR | 60 | ||
SMERKMA | Fixtures and Fittings Characteristics | SMERKMA | NUMC | 3 | TIV71 | |
XMERKMA | Description of characteristic | XMERKMA | CHAR | 50 | ||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA |