Menu

SAP Table VIOB03

Real estate building master

The table VIOB03 (Real estate building master) is a standard table in SAP ERP. It belongs to the package FVVI.

Technical Information

Table VIOB03
Short Text Real estate building master
Package FVVI
Table Type Transparent Table

Fields for Table VIOB03

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
BUKRS Company Code BUKRS CHAR 4 T001
SGENR Building Number SGENR CHAR 8
ADRNR Object number (virtual object) SOBJNR NUMC 10 SANO1
RGEBART Type of building RGEBART NUMC 2 TIV5A
JERBBAU Heritable building right indicator JERBBAU CHAR 1 TDO9
RGEBZUST General condition of building RGEBZUST NUMC 2 TIV83
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 NUMC 2 TIV83
RFAZUST Condition of facade RFAZUST NUMC 2 TIV83
BUBRA Cubic Volume BUBRA DEC 11
JDENKMAL Protection of Historical Sites JDENKMAL CHAR 1
AGESCH Dummy, since replaced: Number of floors AGESCH DEC 3
AUGESCH Number of basements AUGESCH DEC 2
RARTOPT Option rate calculation type RARTOPT NUMC 1
JLOESCH Real Estate Deletion Indicator/Flag JLOESCH CHAR 1
RERF Entered by RERF CHAR 12
DERF First Entered on DERF DATS 8
TERF Time of Initial Entry TERF TIMS 6
REHER Source of initial entry REHER CHAR 10
RBEAR Employee ID RBEAR CHAR 12
DBEAR Last Edited on DBEAR DATS 8
TBEAR Last Edited at TBEAR TIMS 6
RBHER Editing Source RBHER CHAR 10
DAKTBEST Date active in portfolio DAKTBEST DATS 8
IMKEY Internal Key for Real Estate Object IMKEY CHAR 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 *
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
SLAGK Location class SLAGK NUMC 2 TIV22
KOSTL Cost Center KOSTL CHAR 10 *
J_OBJNR Object number J_OBJNR CHAR 22 ONR00
RFAKT Conversion factor for fractional share of property VVRFAKT NUMC 6
JNURJAHR Indicator: Only regard construction date in terms of years VVJNURJ CHAR 1
PRCTR Profit Center PRCTR CHAR 10 CEPC
DWIRTUB Transfer usage / charges VVDWIRTUB DATS 8
DVERKAUF Sale date VVDVERKAUF DATS 8
SUNUTZA Main usage type VVSUNART CHAR 8 TIV36
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 VVJUNUTZA CHAR 1
PROFL Settlement profile APROF CHAR 6 TKB1A
KOKRS Controlling Area KOKRS CHAR 4 TKA01
DVRKPLAN Planned sale VVDVRKPLAN DATS 8
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 VVNSTCKLFT NUMC 3
BANZGE Number of floors VVBANZGE DEC 4
RPGENR Building no. of hierarchical superior building part VVRPGENR CHAR 8 *
JANLHIE Indicator: Asset allocation valid for subordin. building VVJANLHIE CHAR 1
SSTCKBIS Uppermost Floor of a Building VVSTCKBIS NUMC 3 *
SLIFTBIS Elevator to Floor in Building VVLIFTBIS NUMC 3 *
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13
GSBER Business Area GSBER CHAR 4 TGSB
TXJCD Tax Jurisdiction TXJCD CHAR 15 *
BERGRP Authorization group VVBERGRP CHAR 40
GEMEINDE Municipality key VVGEMEINDE CHAR 8 TIVG1
EXPOSURE Exposure (direction) of Building/ Part of building HB_EXPOSR CHAR 4 CHBSEXP
REFNO External Reference Number HB_REFNO CHAR 24
SGEBT Part of Building SGEBT CHAR 2 TIV12
SSTOCKW Floor VVSSTOCKW NUMC 3 TIV37
RLGESCH Location on Floor RLGESCH CHAR 2 TIV38
XSTANDNR Number of garage / parking space VVXSTANDNR CHAR 5
HB_MARKER Single-Character Indicator CHAR1 CHAR 1
VALIDFROM Date: Object Valid From REBDOBJVALIDFROM DATS 8
VALIDTO Date: Object Valid To REBDOBJVALIDTO DATS 8
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1
RESPONSIBLE Person Responsible RECARESPONSIBLE CHAR 12 *
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE CHAR 12 *