SAP Table VIRPS405 - Building

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
SSOUR X SSOUR CHAR 3 4 0 Statistic(s) origin
VRSIO X VRSIO CHAR 7 3 0 P44V Version number in the information structure
SPMON X SPMON NUMC 10 6 0 Period to analyze - month
SPTAG X SPTAG DATS 16 8 0 Period to analyze - current date
SPWOC X SPWOC NUMC 24 6 0 Period to analyze - week
SPBUP X SPBUP NUMC 30 6 0 Period to analyze - posting period
BUKRS_01 X BUKRS CHAR 36 4 0 T001 Company Code
GSBER_02 X GSBER CHAR 40 4 0 TGSB Business Area
SWENR_03 X SWENR CHAR 44 8 0 VIOB01 Business Entity Number
SGENR_04 X SGENR CHAR 52 8 0 Building Number
BUKRS BUKRS CHAR 60 4 0 T001 Company Code
GSBER GSBER CHAR 64 4 0 TGSB Business Area
SWENR SWENR CHAR 68 8 0 VIOB01 Business Entity Number
SGENR SGENR CHAR 76 8 0 Building Number
PERIV PERIV CHAR 84 2 0 Fiscal Year Variant
VWDAT VWDAT NUMC 86 10 0 Pointer to administrative data
USRUNIT1 USRUNIT UNIT 96 3 0 T006 User field: Unit for quantity fields
USRUNIT2 USRUNIT UNIT 99 3 0 T006 User field: Unit for quantity fields
USRCUKY1 USRCUKY CUKY 102 5 0 TCURC User field: Unit for value fields
USRCUKY2 USRCUKY CUKY 107 5 0 TCURC User field: Unit for value fields
WAERS WAERS CUKY 112 5 0 TCURC Currency Key
FEINS FEINS UNIT 117 3 0 T006 Area unit
REINS REINS UNIT 120 3 0 T006 Unit for cubic volume
XORT VVXORT CHAR 123 35 0 Address: City
XPLZ VVXPLZ CHAR 158 10 0 Address: Postal code
XSTRASSE VVXSTRASSE CHAR 168 35 0 Address: Street/house number
ANZGE VVAGE DEC 203 6 0 No. of buildings
USR02 USRCHAR101 CHAR 207 10 0 User-defined field 1 for 10 characters
USR03 USRCHAR102 CHAR 217 10 0 User-defined field 2 for 10 characters
USR00 USRCHAR201 CHAR 227 20 0 User-defined field 1 for 20 characters
USR01 USRCHAR202 CHAR 247 20 0 User field 2 for 20 characters
USR08 USRDATE1 DATS 267 8 0 User field 1 for date
USR09 USRDATE2 DATS 275 8 0 User field 2 for date
USR10 USRFLAG1 CHAR 283 1 0 User field 1 indicator for evaluations
USR11 USRFLAG2 CHAR 284 1 0 User field 2 indicator for evaluations
USR04 USRQUAN131 QUAN 285 13 3 User field 1 for set (length 10,3)
USR05 USRQUAN132 QUAN 292 13 3 User field 2 for set (length 10.3)
USR06 USRCURR131 CURR 299 13 3 User field 1 for values (length 10.3)
USR07 USRCURR132 CURR 306 13 3 User field 2 for values (length 10.3)
FQMFLART VVBFLART QUAN 313 14 4 Area of area type
DSFLART VVDSFLART DATS 321 8 0 Area: effective from
SFLART SFLART NUMC 329 4 0 TIV08 Area type
KOSTL KOSTL CHAR 333 10 0 Cost Center
ADRNR SOBJNR NUMC 343 10 0 Object number (virtual object)
OBJNR J_OBJNR CHAR 353 22 0 ONR00 Object number
PRCTR PRCTR CHAR 375 10 0 Profit Center
STTXT_EXT VVXSTXTEXT CHAR 385 40 0 Status: Set by user
STTXT_INT VVXSTTXTIN CHAR 425 40 0 Status: Set by system
DVERKAUF VVDVERKAU2 DATS 465 8 0 Date: Sale
DVRKPLAN VVDVRKPLA2 DATS 473 8 0 Date: Planned sale
XUNART VVXUNART CHAR 481 35 0 Main usage type
SUNUTZA VVSUNART CHAR 516 8 0 Main usage type
RGEBART RGEBART NUMC 524 2 0 Type of building
XGEBART XGEBART CHAR 526 50 0 Type of building
JERBBAU JERBBAU CHAR 576 1 0 TDO9 Heritable building right indicator
RGEBZUST RGEBZUST NUMC 577 2 0 TIV83 General condition of building
XGEBZUST XGEBZUST CHAR 579 50 0 Description of condition of building
YBAUJAHR VVYBAUJAHR DATS 629 8 0 ConstYr
YMODERN VVYMODERN DATS 637 8 0 Year of modernization
YAUFBAU VVYAUFBAU DATS 645 8 0 Year of reconstruction
DBAUBEGI DBAUBEGI DATS 653 8 0 Construction start date
BBAUW13 BBAUW13 CURR 661 11 2 Building value
BBAUWAKT BBAUWAKT CURR 667 11 2 Current building value
BBETRIEB BBETRIEB CURR 673 11 2 Production equipment value
BAUSSEN BAUSSEN CURR 679 11 2 Grounds value
BSCHADEN BSCHADEN CURR 685 11 2 Structural damage value
BREPSTAU BREPSTAU CURR 691 11 2 Value of repair backlog
BDMCBMRA BDMCBMRA CURR 697 11 2 Amount per volume unit
DBAUGENE DBAUGENE DATS 703 8 0 Building permit
XBAUGENE XBAUGENE CHAR 711 30 0 Note on building permit
DBEZUGSF DBEZUGSF DATS 741 8 0 Ready for occupancy
DFERTIG DFERTIG DATS 749 8 0 Completion
DSCHLUSS DSCHLUSS DATS 757 8 0 Final Inspection
FDACHFL FDACHFL DEC 765 8 2 Attic space
RDAZUST RDAZUST NUMC 770 2 0 TIV83 Condition of roof
XDAZUST XDAZUST CHAR 772 50 0 Condition of roof
RFAZUST RFAZUST NUMC 822 2 0 TIV83 Condition of facade
XFAZUST XFAZUST CHAR 824 50 0 Condition of facade
BUBRA BUBRA DEC 874 11 3 Cubic Volume
JDENKMAL JDENKMAL CHAR 880 1 0 Protection of Historical Sites
AUGESCH AUGESCH DEC 881 2 0 Number of basements
DAKTBEST DAKTBEST DATS 883 8 0 Date active in portfolio
DBAUVOR DBAUVOR DATS 891 8 0 Date of planning inquiry
DVORBES DVORBES DATS 899 8 0 Date of prior notice
DANTBAU DANTBAU DATS 907 8 0 Application for building permit
SGRUNDB SGRUNDB NUMC 915 8 0 Land register number
XGBVON XGBVON CHAR 923 25 0 Land register district
XGETXT XGETXT CHAR 948 60 0 Building text
BEINHEITW BEINHEITW CURR 1008 11 2 Assessed value of building
NEINHEITW NEINHEITW NUMC 1014 4 0 Assessed value base year
BVERSWRT BVERSWRT CURR 1018 11 2 Insurable value amount
RVERSWRT RVERSWRT NUMC 1024 1 0 Type of insurance value
XVERSWRT XVERSWRT CHAR 1025 25 0 Type of insurance value
SMIETSP SMIETSP CHAR 1050 6 0 TIV20 Representative list of rents assignment
XMIETSP VVXMIETSP CHAR 1056 15 0 Representative list of rents: allocation
SLAGK SLAGK NUMC 1071 2 0 Location class
XLAGK XLAGK CHAR 1073 30 0 Description of location class for rep.list of rents
RFAKT VVRFAKT NUMC 1103 6 0 Conversion factor for fractional share of property
JNURJAHR VVJNURJ CHAR 1109 1 0 Indicator: Only regard construction date in terms of years
DWIRTUB VVDWIRTUB DATS 1110 8 0 Transfer usage / charges
PROFL APROF CHAR 1118 6 0 TKB1A Settlement profile
DNUTZEND VVDNUTZEND DATS 1124 8 0 End of usage
DFRDVON VVDFRDVON DATS 1132 8 0 Public funding from
DFRDBIS VVDFRDBIS DATS 1140 8 0 Public funding to
NSTCKLFT VVNSTCKLF2 CHAR 1148 3 0 Number of highest floor reached by elevator
BANZGE VVBANZGE DEC 1151 4 1 Number of floors
RPGENR VVRPGENR CHAR 1154 8 0 Building no. of hierarchical superior building part
XPGENR XGETXT CHAR 1162 60 0 Building text
SMERKMA SMERKMA NUMC 1222 3 0 Fixtures and Fittings Characteristics
XMERKMA XMERKMA CHAR 1225 50 0 Description of characteristic
ANLN1 ANLN1 CHAR 1275 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 1287 4 0 ANLA Asset Subnumber