VIOROO SAP (Offered Object) Table details

Dictionary Type: Table
Description: Offered Object




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




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

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

The VIOROO table consists of various fields, each holding specific information or linking keys about Offered Object data available in SAP. These include INTRENO (Internal Key of Real Estate Object), OOID (Offered Object Number), OBJNR (Object Number), CREATIONTYPE (How the Object Was Created).. 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 VIOROO 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
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
OOIDOffered Object Number REOROOIDCHAR20ALPHAREOROOIDREOROOIDREOROO
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
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
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
OOBEGAvailable From REOROOBEGDATS8RECADATEBEG
OOENDAvailable To REOROOENDDATS8REDATRECADATEEND
MEASMeasurement Type REBDMEASCHAR4TIVBDMEASALPHAREBDMEASREBDMEASREBDMEAS
USAGETYPEUsage Type of Rental Object REBDUSAGETYPENUMC4TIV01SNUNRREBDUSAGETYPEREBDUSAGETYPE
RSOBJTYPEReservation Object Type REORRSOBJTYPECHAR2TIVORRSOBJTYPEREORRSOBJTYPEREORRSOBJTYPE
RSAREAReservation Area REORRSAREACHAR10TIVORRSAREAREORRSAREA
ACQUISTYPELease/Buy REORACQUISTYPECHAR2REORACQUISTYPE
XOOText for Offered Object REORXOOCHAR255REORXLDESCRIPTION
OOIDEXTExternal ID of Reservation Object REOROOIDEXTCHAR45REOROOIDEXTREOROOIDEXT
OBJTYPEREFObject Type RECAOBJTYPECHAR2Assigned to domainJ_OBARTRECAOBJTYPE
OBJNRREFObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
OODATAFROMOffer Data Valid From REOROODATAFROMDATS8REDATRECADATEEND
OODATATOOffer Data Valid To REOROODATATODATS8REDATRECADATEEND
OORESFROMOffer Reserved From REOROORESFROMDATS8RECADATEBEG
OORESTOOffered Object Reserved To REOROORESTODATS8REDATRECADATEEND
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BENOSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
BUNONumber of Building REBDBUNOCHAR8SGENRREBDBUNOREBDBUNOREBDBUNO
PRNONumber of Land REBDPRNOCHAR8SGRNRREBDPRNOREBDPRNOREBDPRNO
RONONumber of Rental Object REBDRONOCHAR8SMENRREBDRONOREBDRONOREBDRONO
OFIDContract Offer Number REOROFIDCHAR13ALPHAREOROFIDREOROFID
.INCLU-01 0
CDVALUE01Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR01Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-02 0
CDVALUE02Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR02Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-03 0
CDVALUE03Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR03Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-04 0
CDVALUE04Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR04Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-01 0
MSVALUE01Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT01Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-02 0
MSVALUE02Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT02Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-03 0
MSVALUE03Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT03Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-04 0
MSVALUE04Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT04Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
FLOORFloor REORRRFLOORCHAR2REORRRFLOOR
SSTDORTRegional location VVSSTDORTCHAR10TIV35VVSSTDORT
SLAGEWEBusiness entity location number SLAGEWENUMC4TIV10SLAGEWE
SOBJLAGEIndicator: District Location of Object RESOBJLAGENUMC2TIV45RESOBJLAGE
TRANSPCONNTransport Connections of Business Entity SVERKEHRCHAR1TIV44SVERKEHR
BUILDYEARConstYr VVYBAUJAHRDATS8DATUM
RRCHARACTSTRFixtures and Fittings Characteristic String REORRRCHARACTSTRCHAR80REORCHARACTSTR
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
NEIGHBORH1Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
NEIGHBORH2Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
NEIGHBORH3Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
AECNEEDEDAccommodation Entitlement Certificate Required REORAECNEEDEDCHAR1RECABOOL
AECCLASSSTRAEC Level String REORAECCLASSSTRCHAR60REORAECCLASSSTR
OBJNRCNOutline Agreement REOROBJNRCNCHAR22Assigned to domainJ_OBJNR
ACCDETKEYAccount Determination Value RERAACCDETKEYCHAR10TIVRADETKEYRERAACCDETKEY
RESPOBJNRDEFResponsible Account Assignment Object (Default) REORRESPOBJNRDEFCHAR22Assigned to domainJ_OBJNR
RESPOBJNR1Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR2Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR3Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR4Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
PRICECODE1Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE2Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE3Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE4Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
LOCKEDFROMStart of Lock Period REORLOCKEDFROMDATS8RECADATEBEG
LOCKEDTOEnd of Lock Period REORLOCKEDTODATS8RECADATE
LOCKREASONLock Reason REORLOCKREASONCHAR4TIVORLOCKRSALPHAREORLOCKREASON
XLOCKREASONEXTOther Lock Reason REORXLOCKREASONEXTCHAR100RECAXCOMMENT
BILLEDTODate Up to Which Postings Were Made REORBILLEDTODATS8RECADATE
NTPERContract Notice Per RECNNTPERDATS8RECADATE
NTREQUESTONTenant's notice request date RECNNTREQUESTONDATS8RECADATE
BILLFROMFirst Posting From REORBILLFROMDATS8RECADATE

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIOROO
INTO CORRESPONDING FIELDS OF WA_VIOROO
WHERE...

How to access SAP table VIOROO

Within an ECC or HANA version of SAP you can also view further information about VIOROO 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!