VIOB02
Property master dataExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table VIOB02.
SAP table VIOB02 has 4 primary key fields: MANDT,BUKRS,SWENR,SGRNR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
VIOB02 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||||||||||
| Key BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||||||||||||
| Key SWENR | Business Entity Number | CHAR | 8 | 0 | VIOB01 | SWENR | |||||||||||||||||||||
| Key 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 | ||||||||||||||||||||||
| |||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| |||||||||||||||||||||||||||
| RESPONSIBLE | Person Responsible | CHAR | 12 | 0 | RECARESPONSIBLE | ||||||||||||||||||||||
| USEREXCLUSIVE | User with Exclusive Change Authorization | CHAR | 12 | 0 | RECAUSEREXCLUSIVE | ||||||||||||||||||||||
VIOB02 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| VIOB02 | ADRNR | SANO1 | Address-object relationship | MANDT |
| VIOB02 | ADRNR | SANO1 | Address-object relationship | ADRNR |
| VIOB02 | ADRNR | SANO1 | Address-object relationship | OBTYP |
| VIOB02 | BUKRS | T001 | Company Codes | BUKRS |
| VIOB02 | GEMEINDE | TIVG1 | Municipality Key | MANDT |
| VIOB02 | GSBER | TGSB | Business Areas | MANDT |
| VIOB02 | GSBER | TGSB | Business Areas | GSBER |
| VIOB02 | JERBBAU | TDO9 | Heritable Building Right Indicator for Collateral Objects | MANDT |
| VIOB02 | JERBBAU | TDO9 | Heritable Building Right Indicator for Collateral Objects | SOBJERBBAU |
| VIOB02 | J_OBJNR | ONR00 | General Object Number | MANDT |
| VIOB02 | KOKRS | TKA01 | Controlling Areas | MANDT |
| VIOB02 | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| VIOB02 | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| VIOB02 | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| VIOB02 | PROFL | TKB1A | Settlement Profile | MANDT |
| VIOB02 | PROFL | TKB1A | Settlement Profile | APROF |
| VIOB02 | RGRNART | TIVC4 | Usage Type acc. to Area Usage Plan | MANDT |
| VIOB02 | RNBPLAN | TIVB3 | Usage Types acc. to Development plan | RNBPLAN |
| VIOB02 | SGRART | TIV56 | Property types | MANDT |
| VIOB02 | SGRFRM | TIV58 | Property ground type | MANDT |
| VIOB02 | SGRGZS | TIV59 | Overall condition of property | MANDT |
| VIOB02 | SGRQAL | TIV57 | Quality of property location | MANDT |
| VIOB02 | SGRUNDB | VIGBUCH | Land register | MANDT |
| VIOB02 | SUNUTZA | TIV36 | Main Usage Types | MANDT |
| VIOB02 | SWENR | VIOB01 | Business entities | MANDT |
| VIOB02 | SWENR | VIOB01 | Business entities | BUKRS |
| VIOB02 | XGEMARK | TIVG2 | Local Subdistrict | GEMARK |