1. Home
  2. Resources
  3. SAP Tables
  4. VIOB02 - Property master data

SAP Table VIOB02

Property master data

VIOB02 (Property master data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIOB02 to other SAP tables.

VIOB02 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SWENR Site Number SWENR VIOB01 CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
XGRTXT Text for property XGRTXT CHAR 60 0
SGRUNDB Land register number SGRUNDB VIGBUCH NUMC 8 0
RGRNART Usage Type of Property According to Land Use Map RGRNART TIVC4 CHAR 2 0
BDMQMB1 Market value BDMQMB1 CURR 13 2
BDMQMB2 Purchase price BDMQMB2 CURR 13 2
BDNRWERT Land reference value for determining current market value BDNRWERT CURR 13 2
BDNWERT Land value for determining current market value BDNWERT CURR 13 2
DBDNWERT Date of land value DBDNWERT DATS 8 0
RBEPLAN Development plan RBEPLAN CHAR 30 0
DBEPLAN Date of development plan DBEPLAN DATS 8 0
XNUTZGRU Current usage of property XNUTZGRU CHAR 30 0
NZGRZ Permitted Usage: Site Occupancy Index NZGRZ DEC 3 2
NZGFZ Permitted Usage: Floor Area Ratio NZGFZ DEC 4 2
NZBMZ Permitted Usage: Construction Dimension Number NZBMZ DEC 5 2
NTGRZ Actual Usage: Site Occupancy Index NTGRZ DEC 3 2
NTGFZ Actual Usage: Floor Area Ratio NTGFZ DEC 4 2
NTBMZ Actual Usage: Construction Dimension Number NTBMZ DEC 5 2
JVORKAUF Preemptive right indicator JVORKAUF CHAR 1 0
0 No
1 Yes
JAUSNAHM Special licence indicator JAUSNAHM CHAR 1 0
0 No
1 Yes
JGRUNDW Ground water indicator JGRUNDW CHAR 1 0
0 No
1 Yes
JUEBERS Danger of flooding indicator JUEBERS CHAR 1 0
0 No
1 Yes
RARTOPT Option rate calculation type RARTOPT NUMC 1 0
0 No calculation/date of service
1 Square meter ratio (automatic)
2 Cubic meter ratio (automatic)
3 Apport.unit relat. (automatic)
4 Predistribution (automatic)
5 Plan option rate (manual)
6 Square meter ratio (manual)
7 Cubic meter ratio (manual)
8 Other procedure (manual)
9 No input tax option (automatic)
JLOESCH Real Estate Deletion Indicator/Flag JLOESCH CHAR 1 0
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
DAKTBEST Date active in portfolio DAKTBEST DATS 8 0
ADRNR Object number (virtual object) SOBJNR SANO1 NUMC 10 0
RNBPLAN Usage type according to development plan RNBPLAN TIVB3 CHAR 4 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KOSTL Cost Center KOSTL CHAR 10 0
J_OBJNR Object number J_OBJNR ONR00 CHAR 22 0
RFAKT Conversion factor for fractional share of property VVRFAKT NUMC 6 0
SGRART Property type VVSGRART TIV56 NUMC 4 0
SGRQAL Property: Quality of location VVSGRQAL TIV57 NUMC 3 0
SGRFRM Property ground type VVSGRFRM TIV58 NUMC 3 0
SGRGZS Overall condition of property VVSGRGZS TIV59 NUMC 3 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
DWIRTUB Transfer usage / charges VVDWIRTUB DATS 8 0
DVERKAUF Sale date VVDVERKAUF DATS 8 0
SUNUTZA Main usage type VVSUNART TIV36 CHAR 8 0
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 VVJUNUTZA CHAR 1 0
NULL No
X Yes
PROFL Settlement profile for costs VVAPROF TKB1A CHAR 6 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
DVRKPLAN Planned sale VVDVRKPLAN DATS 8 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
GSBER Business Area GSBER TGSB CHAR 4 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
BERGRP Authorization group VVBERGRP CHAR 40 0
XGEMARK Local Subdistrict VVGEMARK TIVG2 CHAR 12 0
NFLURNR Number of Tract of Land in Land Register NFLURNR CHAR 6 0
XFLURST Parcel of Land XFLURST CHAR 10 0
BRFLURST Fractional Parcel of Land VVBRFLURST CHAR 4 0
JERBBAU Heritable building right indicator JERBBAU TDO9 CHAR 1 0
GEMEINDE Municipality key VVGEMEINDE TIVG1 CHAR 8 0
ZULBAUH Permitted building height VVZULBAUH QUAN 4 0
LEINS Unit of length VVLEINS UNIT 3 0
VALIDFROM Date: Object Valid From REBDOBJVALIDFROM DATS 8 0
VALIDTO Date: Object Valid To REBDOBJVALIDTO DATS 8 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RESPONSIBLE Person Responsible RECARESPONSIBLE CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE CHAR 12 0

VIOB02 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIOB02 ADRNR * SANO1 Address-object relationship ADRNR
VIOB02 ADRNR VIOB02 ADRNR SANO1 Address-object relationship OBJNR
VIOB02 ADRNR '52' SANO1 Address-object relationship OBTYP
VIOB02 ADRNR VIOB02 MANDT SANO1 Address-object relationship MANDT
VIOB02 BUKRS VIOB02 MANDT T001 Company Codes MANDT
VIOB02 BUKRS VIOB02 BUKRS T001 Company Codes BUKRS
VIOB02 GEMEINDE VIOB02 MANDT TIVG1 Municipality Key MANDT
VIOB02 GEMEINDE VIOB02 GEMEINDE TIVG1 Municipality Key GEMEINDE
VIOB02 GSBER VIOB02 MANDT TGSB Business Areas MANDT
VIOB02 GSBER VIOB02 GSBER TGSB Business Areas GSBER
VIOB02 JERBBAU VIOB02 MANDT TDO9 Heritable Building Right Indicator for Collateral Objects MANDT
VIOB02 JERBBAU VIOB02 JERBBAU TDO9 Heritable Building Right Indicator for Collateral Objects SOBJERBBAU
VIOB02 J_OBJNR VIOB02 MANDT ONR00 General Object Number MANDT
VIOB02 J_OBJNR VIOB02 J_OBJNR ONR00 General Object Number OBJNR
VIOB02 KOKRS VIOB02 MANDT TKA01 Controlling Areas MANDT
VIOB02 KOKRS VIOB02 KOKRS TKA01 Controlling Areas KOKRS
VIOB02 PRCTR SYST DATUM CEPC Profit Center Master Data Table DATBI
VIOB02 PRCTR * CEPC Profit Center Master Data Table KOKRS
VIOB02 PRCTR VIOB02 MANDT CEPC Profit Center Master Data Table MANDT
VIOB02 PRCTR VIOB02 PRCTR CEPC Profit Center Master Data Table PRCTR
VIOB02 PROFL VIOB02 MANDT TKB1A Settlement Profile MANDT
VIOB02 PROFL VIOB02 PROFL TKB1A Settlement Profile APROF
VIOB02 RGRNART VIOB02 MANDT TIVC4 Usage Type acc. to Area Usage Plan MANDT
VIOB02 RGRNART VIOB02 RGRNART TIVC4 Usage Type acc. to Area Usage Plan RGRNART
VIOB02 RNBPLAN VIOB02 MANDT TIVB3 Usage Types acc. to Development plan MANDT
VIOB02 RNBPLAN VIOB02 RNBPLAN TIVB3 Usage Types acc. to Development plan RNBPLAN
VIOB02 SGRART VIOB02 MANDT TIV56 Property types MANDT
VIOB02 SGRART VIOB02 SGRART TIV56 Property types SGRART
VIOB02 SGRFRM VIOB02 SGRFRM TIV58 Property ground type SGRFRM
VIOB02 SGRFRM VIOB02 MANDT TIV58 Property ground type MANDT
VIOB02 SGRGZS VIOB02 MANDT TIV59 Overall condition of property MANDT
VIOB02 SGRGZS VIOB02 SGRGZS TIV59 Overall condition of property SGRGZS
VIOB02 SGRQAL VIOB02 MANDT TIV57 Quality of property location MANDT
VIOB02 SGRQAL VIOB02 SGRQAL TIV57 Quality of property location SGRQAL
VIOB02 SGRUNDB VIOB02 SGRUNDB VIGBUCH Land register SGRUNDB
VIOB02 SGRUNDB VIOB02 MANDT VIGBUCH Land register MANDT
VIOB02 SUNUTZA VIOB02 MANDT TIV36 Main Usage Types MANDT
VIOB02 SUNUTZA VIOB02 SUNUTZA TIV36 Main Usage Types SUNART
VIOB02 SWENR VIOB02 MANDT VIOB01 Business entities MANDT
VIOB02 SWENR VIOB02 BUKRS VIOB01 Business entities BUKRS
VIOB02 SWENR VIOB02 SWENR VIOB01 Business entities SWENR
VIOB02 XGEMARK VIOB02 MANDT TIVG2 Local Subdistrict MANDT
VIOB02 XGEMARK VIOB02 XGEMARK TIVG2 Local Subdistrict GEMARK