VIOB02 SAP (Property master data) Table details

Dictionary Type: Table
Description: Property master data




ABAP Code to SELECT data from VIOB02
Related tables to VIOB02
Access table VIOB02




Table field list including key, data, relationships and ABAP select examples

VIOB02 is a standard SAP Table which is used to store Property master data data and is available within R/3 SAP systems depending on the version and release level.

The VIOB02 table consists of various fields, each holding specific information or linking keys about Property master data data available in SAP. These include BUKRS (Company Code), SWENR (Site Number), SGRNR (Property Number for BE), XGRTXT (Text for property).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIOB02 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SGRNRProperty Number for BE SGRNRCHAR8SGRNRSGRNRGRSMCGR
XGRTXTText for property XGRTXTCHAR60XLBEZ
SGRUNDBLand register number SGRUNDBNUMC8VIGBUCHSGRUNDBGBS
RGRNARTUsage Type of Property According to Land Use Map RGRNARTCHAR2TIVC4CHAR2
BDMQMB1Market value BDMQMB1CURR13(2) WRTV7
BDMQMB2Purchase price BDMQMB2CURR13(2) WRTV7
BDNRWERTLand reference value for determining current market value BDNRWERTCURR13(2) WRTV7
BDNWERTLand value for determining current market value BDNWERTCURR13(2) WRTV7
DBDNWERTDate of land value DBDNWERTDATS8DDAT
RBEPLANDevelopment plan RBEPLANCHAR30XMBEZ
DBEPLANDate of development plan DBEPLANDATS8DDAT
XNUTZGRUCurrent usage of property XNUTZGRUCHAR30XMBEZ
NZGRZPermitted Usage: Site Occupancy Index NZGRZDEC3(2) DEC1_2
NZGFZPermitted Usage: Floor Area Ratio NZGFZDEC4(2) DEC2_2
NZBMZPermitted Usage: Construction Dimension Number NZBMZDEC5(2) DEC3_2
NTGRZActual Usage: Site Occupancy Index NTGRZDEC3(2) DEC1_2
NTGFZActual Usage: Floor Area Ratio NTGFZDEC4(2) DEC2_2
NTBMZActual Usage: Construction Dimension Number NTBMZDEC5(2) DEC3_2
JVORKAUFPreemptive right indicator JVORKAUFCHAR1JANEI
JAUSNAHMSpecial licence indicator JAUSNAHMCHAR1JANEI
JGRUNDWGround water indicator JGRUNDWCHAR1JANEI
JUEBERSDanger of flooding indicator JUEBERSCHAR1JANEI
RARTOPTOption rate calculation type RARTOPTNUMC1RARTOPT
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
DAKTBESTDate active in portfolio DAKTBESTDATS8DATUM
ADRNRObject number (virtual object) SOBJNRNUMC10SANO1SOBJNR
RNBPLANUsage type according to development plan RNBPLANCHAR4TIVB3RGRNART
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
J_OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
RFAKTConversion factor for fractional share of property VVRFAKTNUMC6VVRFAKT
SGRARTProperty type VVSGRARTNUMC4TIV56VVSGRART
SGRQALProperty: Quality of location VVSGRQALNUMC3TIV57VVSGRQAL
SGRFRMProperty ground type VVSGRFRMNUMC3TIV58VVSGRFRM
SGRGZSOverall condition of property VVSGRGZSNUMC3TIV59VVSGRGZS
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
DWIRTUBTransfer usage / charges VVDWIRTUBDATS8DATUM
DVERKAUFSale date VVDVERKAUFDATS8DATUM
SUNUTZAMain usage type VVSUNARTCHAR8TIV36VVSUNART
JUNUTZAIndicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 VVJUNUTZACHAR1JANE
PROFLSettlement profile for costs VVAPROFCHAR6TKB1AALPHAAPROF
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
DVRKPLANPlanned sale VVDVRKPLANDATS8DATUM
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
XGEMARKLocal Subdistrict VVGEMARKCHAR12TIVG2VVGEMARK
NFLURNRNumber of Tract of Land in Land Register NFLURNRCHAR6NFLURNR
XFLURSTParcel of Land XFLURSTCHAR10TEXT10
BRFLURSTFractional Parcel of Land VVBRFLURSTCHAR4VVBRFLURST
JERBBAUHeritable building right indicator JERBBAUCHAR1TDO9SOBJERBBAU
GEMEINDEMunicipality key VVGEMEINDECHAR8TIVG1VVGEMEINDE
ZULBAUHPermitted building height VVZULBAUHQUAN4VVZULBAUH
LEINSUnit of length VVLEINSUNIT3Assigned to domainCUNITMEINS
.INCLU--AP 0
BLOCKBlock/section/tract HB_BLOCKCHAR10HBS_BLOCK
FRONTAGELength of the Lot Facing the Street HB_FRNTGEQUAN8(2) HBS_QUAN
DEPTHDepth of the Lot HB_DEPTHQUAN8(2) HBS_QUAN
LOTSIZEArea of the Lot HB_SIZEQUAN8(2) HBS_QUAN
REFNOExternal Reference Number HB_REFNOCHAR24HBS_REFNO
HB_MARKERSingle-Character Indicator CHAR1CHAR1CHAR1
PHASEDevelopment Phase Allocated to the Lot HB_PPHSECHAR11HBSPPHHBS_PHASE
.INCLU--AP 0
VALIDFROMDate: Object Valid From REBDOBJVALIDFROMDATS8RECADATEBEG
VALIDTODate: Object Valid To REBDOBJVALIDTODATS8REDATRECADATEEND
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12Assigned to domainXUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12Assigned to domainXUBNAMEUSER_COMP

Key field Non-key field



How do I retrieve data from SAP table VIOB02 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIOB02 to SELECT all data from the table
DATA: WA_VIOB02 TYPE VIOB02.

SELECT SINGLE *
FROM VIOB02
INTO CORRESPONDING FIELDS OF WA_VIOB02
WHERE...

How to access SAP table VIOB02

Within an ECC or HANA version of SAP you can also view further information about VIOB02 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!