SAP table VIOB02 (Property master data)

SAP table VIOB02 has 4 primary key fields being MANDT,BUKRS,SWENR,SGRNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VIOB02 foreign key relationships

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