VIORRR SAP (Rental Request) Table details

Dictionary Type: Table
Description: Rental Request




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




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

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

The VIORRR table consists of various fields, each holding specific information or linking keys about Rental Request data available in SAP. These include INTRENO (Internal Key of Real Estate Object), RRID (RE Search Request 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 VIORRR 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
RRIDRE Search Request Number REORRRIDCHAR20ALPHAREORRRIDREORRENTREQNOREORRR
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
RRCNBEGRequested Contract Start Date REORRRCNBEGDATS8REORRRCNBEG
RRCNENDRequested Contract End Date REORRRCNENDDATS8REDATRECADATEEND
RRCNBEGLATERLater Contract Start Date Possible REORRRCNBEGLATERCHAR1RECABOOL
RRTYPEType of RE Search Request REORRRTYPECHAR2TIVORRRTYPEREORRRTYPEREORRRTYPE
ACQUISTYPELease/Buy REORACQUISTYPECHAR2REORACQUISTYPE
XRRText for RE Search Request REORXRRCHAR255REORXLDESCRIPTION
SEARCHTERMText Search REORSEARCHTERMCHAR45RSDSSELOPT
.INCLU-01 0
CDVALUETO01Maximum Condition Amount REORCDVALUETOCURR15(2) RECACURR
CDVALUETOL01Maximum Condition Amount Including Tolerance Limit REORCDVALUETOLCURR15(2) RECACURR
CDCURR01Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-02 0
CDVALUETO02Maximum Condition Amount REORCDVALUETOCURR15(2) RECACURR
CDVALUETOL02Maximum Condition Amount Including Tolerance Limit REORCDVALUETOLCURR15(2) RECACURR
CDCURR02Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-03 0
CDVALUETO03Maximum Condition Amount REORCDVALUETOCURR15(2) RECACURR
CDVALUETOL03Maximum Condition Amount Including Tolerance Limit REORCDVALUETOLCURR15(2) RECACURR
CDCURR03Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-04 0
CDVALUETO04Maximum Condition Amount REORCDVALUETOCURR15(2) RECACURR
CDVALUETOL04Maximum Condition Amount Including Tolerance Limit REORCDVALUETOLCURR15(2) RECACURR
CDCURR04Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-01 0
MSVALUEFROM01Minimum Measurement REORMSVALUEFROMQUAN17(4) REBDMEASVALUE
MSVALUETO01Maximum Measurement REORMSVALUETOQUAN17(4) REBDMEASVALUE
MSVALUETOLFROM01Minimum Measurement Including Tolerance Limit REORMSVALUETOLFROMQUAN17(4) REBDMEASVALUE
MSVALUETOLTO01Maximum Measurement Including Tolerance REORMSVALUETOLTOQUAN17(4) REBDMEASVALUE
MSUNIT01Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-02 0
MSVALUEFROM02Minimum Measurement REORMSVALUEFROMQUAN17(4) REBDMEASVALUE
MSVALUETO02Maximum Measurement REORMSVALUETOQUAN17(4) REBDMEASVALUE
MSVALUETOLFROM02Minimum Measurement Including Tolerance Limit REORMSVALUETOLFROMQUAN17(4) REBDMEASVALUE
MSVALUETOLTO02Maximum Measurement Including Tolerance REORMSVALUETOLTOQUAN17(4) REBDMEASVALUE
MSUNIT02Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-03 0
MSVALUEFROM03Minimum Measurement REORMSVALUEFROMQUAN17(4) REBDMEASVALUE
MSVALUETO03Maximum Measurement REORMSVALUETOQUAN17(4) REBDMEASVALUE
MSVALUETOLFROM03Minimum Measurement Including Tolerance Limit REORMSVALUETOLFROMQUAN17(4) REBDMEASVALUE
MSVALUETOLTO03Maximum Measurement Including Tolerance REORMSVALUETOLTOQUAN17(4) REBDMEASVALUE
MSUNIT03Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-04 0
MSVALUEFROM04Minimum Measurement REORMSVALUEFROMQUAN17(4) REBDMEASVALUE
MSVALUETO04Maximum Measurement REORMSVALUETOQUAN17(4) REBDMEASVALUE
MSVALUETOLFROM04Minimum Measurement Including Tolerance Limit REORMSVALUETOLFROMQUAN17(4) REBDMEASVALUE
MSVALUETOLTO04Maximum Measurement Including Tolerance REORMSVALUETOLTOQUAN17(4) REBDMEASVALUE
MSUNIT04Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
RRFLOORSTRFloor REORRRFLOORSTRCHAR255REORRRFLOORSTR
RRREGLOCSTRRegional Location REORRRREGLOCSTRCHAR255REORRRREGLOCSTR
RRLOCATIONSTRLocation REORRRLOCATIONSTRCHAR255REORRRLOCATIONSTR
RRLOCATIONNESTRLocation REORRRLOCATIONSTRCHAR255REORRRLOCATIONSTR
RRDISTLOCSTRDistrict Location REORRRDISTLOCSTRCHAR255REORRRDISTLOCSTR
RRTRANSPCONNSTRTransport Connections REORRRTRANSPCONNSTRCHAR255REORRRTRANSPCONNSTR
BUILDAGEFROMBuilding Age From REORBUILDAGEFROMDATS8RECADATEBEG
BUILDAGETOBuilding Age To REORBUILDAGETODATS8REDATRECADATEEND
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
NEIGHBORHOODSTRNeighborhood REORNEIGHBORHOODSTRCHAR255REORNEIGHBORHOODSTR
EDITINDICATORProcessing Indicator for RE Search Request REOREDITINDICATORCHAR2TIVOREDITINDREOREDITINDICATOR
EDITSTATUSProcessing Status for RE Search Request REOREDITSTATUSCHAR2TIVOREDITSTATREOREDITSTATUS
PRESELECTIONPreselection Indicator for RE Search Request REORPRESELECTIONCHAR2TIVORPRESELECTREORPRESELECTION
INFLOWFROMSource of Prospect REORINFLOWFROMCHAR2TIVORINFLOWFROMREORINFLOWFROM
INFLOWREASONReason for Search REORINFLOWREASONCHAR2TIVORINFLOWREASREORINFLOWREASON
INFLOWWAYSource of Inquiry REORINFLOWWAYCHAR2TIVORINFLOWWAYREORINFLOWWAY
RRSEARCHPARTParticipation in Search REORRRSEARCHPARTCHAR1REORRRSEARCHPART
AECEXISTSAccommodation Entitlement Certificate Exists REORAECEXISTSCHAR1RECABOOL
AECCLASSSTRAEC Level String REORAECCLASSSTRCHAR60REORAECCLASSSTR
AECDATEOFISSUEIssue Date of Accommodation Entitlement Certificate REORAECDATEOFISSUEDATS8RECADATE
AECVALIDTOAccommodation Entitlement Certificate Valid To REORAECVALIDTODATS8REDATRECADATEEND
AECPRIORITYPriority for Accommodation Entitlement Certificate REORAECPRIORITYCHAR4TIVORAECPRIOREORAECPRIORITY
AECPERSONGROUPPerson Group for Accommodation Entitlement Certificate REORAECPERSONGROUPCHAR4TIVORAECPERSONREORAECPERSONGROUP
AECINFOAdditional Info for Accommodation Entitlement Certificate REORAECINFOCHAR4TIVORAECINFOREORAECINFO

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIORRR
INTO CORRESPONDING FIELDS OF WA_VIORRR
WHERE...

How to access SAP table VIORRR

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