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 | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
JAUSNAHM
Special licence indicator
|
JAUSNAHM |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
JGRUNDW
Ground water indicator
|
JGRUNDW |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
JUEBERS
Danger of flooding indicator
|
JUEBERS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
RARTOPT
Option rate calculation type
|
RARTOPT |
NUMC
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
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 | VIOB02 | MANDT |
SANO1
Address-object relationship
|
MANDT |
| 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 | BUKRS | VIOB02 | BUKRS |
T001
Company Codes
|
BUKRS |
| VIOB02 | BUKRS | VIOB02 | MANDT |
T001
Company Codes
|
MANDT |
| 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 | VIOB02 | MANDT |
CEPC
Profit Center Master Data Table
|
MANDT |
| VIOB02 | PRCTR | VIOB02 | PRCTR |
CEPC
Profit Center Master Data Table
|
PRCTR |
| VIOB02 | PRCTR | SYST | DATUM |
CEPC
Profit Center Master Data Table
|
DATBI |
| VIOB02 | PRCTR | * |
CEPC
Profit Center Master Data Table
|
KOKRS | |
| 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 | RNBPLAN |
TIVB3
Usage Types acc. to Development plan
|
RNBPLAN |
| VIOB02 | RNBPLAN | VIOB02 | MANDT |
TIVB3
Usage Types acc. to Development plan
|
MANDT |
| VIOB02 | SGRART | VIOB02 | MANDT |
TIV56
Property types
|
MANDT |
| VIOB02 | SGRART | VIOB02 | SGRART |
TIV56
Property types
|
SGRART |
| VIOB02 | SGRFRM | VIOB02 | MANDT |
TIV58
Property ground type
|
MANDT |
| VIOB02 | SGRFRM | VIOB02 | SGRFRM |
TIV58
Property ground type
|
SGRFRM |
| 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 | MANDT |
VIGBUCH
Land register
|
MANDT |
| VIOB02 | SGRUNDB | VIOB02 | SGRUNDB |
VIGBUCH
Land register
|
SGRUNDB |
| 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 |