SAP VIORRR RE Search Request Table

Overview

VIORRR is a standard SAP S/4HANA table that stores RE Search Request data. There are total 94 fields in the VIORRR table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIORRR belongs to Offer and Rental Request (RE-FX-OR) module and is located in the package RE: RE Search Request (RE_OR_RR).

In addition, following links provide an overview of foreign key relationships, if any, that link VIORRR to other SAP tables and standard CDS views available based on VIORRR table in S/4HANA 2020.

Techincal Settings of VIORRR

Below are technical details of the table VIORRR

Buffering not allowed
No buffering
Storage type is Column Store

List of VIORRR Fields

The following table gives you an overview of the fields available in VIORRR

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
INTRENO	Internal Key of Real Estate Object	RECAINTRENO		CHAR	13
RRID	RE Search Request Number	REORRRID		CHAR	20
OBJNR	Object Number	RECAOBJNR	*	CHAR	22
CREATIONTYPE	How the Object Was Created	RECACREATIONTYPE		CHAR	1
RERF	Entered By	RERF		CHAR	12
DERF	First Entered On	DERF		DATS	8
TERF	Time of Creation	TERF		TIMS	6
REHER	Source of Initial Entry	REHER		CHAR	10
RBEAR	Employee ID	RBEAR		CHAR	12
DBEAR	Last Edited On	DBEAR		DATS	8
TBEAR	Last Edited At	TBEAR		TIMS	6
RBHER	Editing Source	RBHER		CHAR	10
RESPONSIBLE	Person Responsible	RECARESPONSIBLE	USR02	CHAR	12
USEREXCLUSIVE	User with Exclusive Change Authorization	RECAUSEREXCLUSIVE	USR02	CHAR	12
AUTHGRP	Authorization Group	RECAAUTHGRP		CHAR	40
RRCNBEG	Requested Contract Start Date	REORRRCNBEG		DATS	8
RRCNEND	Requested Contract End Date	REORRRCNEND		DATS	8
RRCNBEGLATER	Later Contract Start Date Possible	REORRRCNBEGLATER		CHAR	1
RRTYPE	Type of RE Search Request	REORRRTYPE	TIVORRRTYPE	CHAR	2
ACQUISTYPE	Lease/Buy	REORACQUISTYPE		CHAR	2
XRR	Text for RE Search Request	REORXRR		CHAR	255
SEARCHTERM	Text Search	REORSEARCHTERM		CHAR	45
CDVALUETO01	Maximum Condition Amount	REORCDVALUETO		CURR	15
CDVALUETOL01	Maximum Condition Amount Including Tolerance Limit	REORCDVALUETOL		CURR	15
CDCURR01	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUEFROM01	Minimum Condition Amount	REORCDVALUEFROM		CURR	15
CDVALUETOLFROM01	Minimum Condition Amount Including Tolerance	REORCDVALUETOLFROM		CURR	15
CDVALUETO02	Maximum Condition Amount	REORCDVALUETO		CURR	15
CDVALUETOL02	Maximum Condition Amount Including Tolerance Limit	REORCDVALUETOL		CURR	15
CDCURR02	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUEFROM02	Minimum Condition Amount	REORCDVALUEFROM		CURR	15
CDVALUETOLFROM02	Minimum Condition Amount Including Tolerance	REORCDVALUETOLFROM		CURR	15
CDVALUETO03	Maximum Condition Amount	REORCDVALUETO		CURR	15
CDVALUETOL03	Maximum Condition Amount Including Tolerance Limit	REORCDVALUETOL		CURR	15
CDCURR03	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUEFROM03	Minimum Condition Amount	REORCDVALUEFROM		CURR	15
CDVALUETOLFROM03	Minimum Condition Amount Including Tolerance	REORCDVALUETOLFROM		CURR	15
CDVALUETO04	Maximum Condition Amount	REORCDVALUETO		CURR	15
CDVALUETOL04	Maximum Condition Amount Including Tolerance Limit	REORCDVALUETOL		CURR	15
CDCURR04	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUEFROM04	Minimum Condition Amount	REORCDVALUEFROM		CURR	15
CDVALUETOLFROM04	Minimum Condition Amount Including Tolerance	REORCDVALUETOLFROM		CURR	15
MSVALUEFROM01	Minimum Measurement	REORMSVALUEFROM		QUAN	17
MSVALUETO01	Maximum Measurement	REORMSVALUETO		QUAN	17
MSVALUETOLFROM01	Minimum Measurement Including Tolerance Limit	REORMSVALUETOLFROM		QUAN	17
MSVALUETOLTO01	Maximum Measurement Including Tolerance	REORMSVALUETOLTO		QUAN	17
MSUNIT01	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUEFROM02	Minimum Measurement	REORMSVALUEFROM		QUAN	17
MSVALUETO02	Maximum Measurement	REORMSVALUETO		QUAN	17
MSVALUETOLFROM02	Minimum Measurement Including Tolerance Limit	REORMSVALUETOLFROM		QUAN	17
MSVALUETOLTO02	Maximum Measurement Including Tolerance	REORMSVALUETOLTO		QUAN	17
MSUNIT02	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUEFROM03	Minimum Measurement	REORMSVALUEFROM		QUAN	17
MSVALUETO03	Maximum Measurement	REORMSVALUETO		QUAN	17
MSVALUETOLFROM03	Minimum Measurement Including Tolerance Limit	REORMSVALUETOLFROM		QUAN	17
MSVALUETOLTO03	Maximum Measurement Including Tolerance	REORMSVALUETOLTO		QUAN	17
MSUNIT03	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUEFROM04	Minimum Measurement	REORMSVALUEFROM		QUAN	17
MSVALUETO04	Maximum Measurement	REORMSVALUETO		QUAN	17
MSVALUETOLFROM04	Minimum Measurement Including Tolerance Limit	REORMSVALUETOLFROM		QUAN	17
MSVALUETOLTO04	Maximum Measurement Including Tolerance	REORMSVALUETOLTO		QUAN	17
MSUNIT04	Measurement Unit	REBDMEASUNIT	*	UNIT	3
RRFLOORSTR	Floor	REORRRFLOORSTR		CHAR	255
RRREGLOCSTR	Regional Location	REORRRREGLOCSTR		CHAR	255
RRLOCATIONSTR	Location	REORRRLOCATIONSTR		CHAR	255
RRLOCATIONNESTR	Location	REORRRLOCATIONSTR		CHAR	255
RRDISTLOCSTR	District Location	REORRRDISTLOCSTR		CHAR	255
RRTRANSPCONNSTR	Transport Connections	REORRRTRANSPCONNSTR		CHAR	255
BUILDAGEFROM	Building Age From	REORBUILDAGEFROM		DATS	8
BUILDAGETO	Building Age To	REORBUILDAGETO		DATS	8
RRCHARACTSTR	Fixtures and Fittings Characteristic String	REORRRCHARACTSTR		CHAR	80
COUNTRY	Country/Region Key	LAND1	T005	CHAR	3
REGION	Region (State Province County)	REGIO	T005S	CHAR	3
POST_CODE1	City postal code	AD_PSTCD1		CHAR	10
CITY1	City	AD_CITY1		CHAR	40
CITY2	District	AD_CITY2		CHAR	40
STREET	Street	AD_STREET		CHAR	60
HOUSE_NUM1	House Number	AD_HSNM1		CHAR	10
NEIGHBORHOODSTR	Neighborhood	REORNEIGHBORHOODSTR		CHAR	255
EDITINDICATOR	Processing Indicator for RE Search Request	REOREDITINDICATOR	TIVOREDITIND	CHAR	2
EDITSTATUS	Processing Status for RE Search Request	REOREDITSTATUS	TIVOREDITSTAT	CHAR	2
PRESELECTION	Preselection Indicator for RE Search Request	REORPRESELECTION	TIVORPRESELECT	CHAR	2
INFLOWFROM	Source of Prospect	REORINFLOWFROM	TIVORINFLOWFROM	CHAR	2
INFLOWREASON	Reason for Search	REORINFLOWREASON	TIVORINFLOWREAS	CHAR	2
INFLOWWAY	Source of Inquiry	REORINFLOWWAY	TIVORINFLOWWAY	CHAR	2
RRSEARCHPART	Participation in Search	REORRRSEARCHPART		CHAR	1
AECEXISTS	Accommodation Entitlement Certificate Exists	REORAECEXISTS		CHAR	1
AECCLASSSTR	AEC Level String	REORAECCLASSSTR		CHAR	60
AECDATEOFISSUE	Issue Date of Accommodation Entitlement Certificate	REORAECDATEOFISSUE		DATS	8
AECVALIDTO	Accommodation Entitlement Certificate Valid To	REORAECVALIDTO		DATS	8
AECPRIORITY	Priority for Accommodation Entitlement Certificate	REORAECPRIORITY	TIVORAECPRIO	CHAR	4
AECPERSONGROUP	Person Group for Accommodation Entitlement Certificate	REORAECPERSONGROUP	TIVORAECPERSON	CHAR	4
AECINFO	Additional Info for Accommodation Entitlement Certificate	REORAECINFO	TIVORAECINFO	CHAR	4

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIORRR

Table Name	Field	Cardinality	Check Table
VIORRR	AECINFO	:	TIVORAECINFO
VIORRR	AECPERSONGROUP	:	TIVORAECPERSON
VIORRR	AECPRIORITY	:	TIVORAECPRIO
VIORRR	COUNTRY	:	T005
VIORRR	EDITINDICATOR	:	TIVOREDITIND
VIORRR	EDITSTATUS	:	TIVOREDITSTAT
VIORRR	INFLOWFROM	:	TIVORINFLOWFROM
VIORRR	INFLOWREASON	:	TIVORINFLOWREAS
VIORRR	INFLOWWAY	:	TIVORINFLOWWAY
VIORRR	PRESELECTION	:	TIVORPRESELECT
VIORRR	REGION	:	T005S
VIORRR	RESPONSIBLE	1: CN	USR02
VIORRR	RRTYPE	1: CN	TIVORRRTYPE
VIORRR	USEREXCLUSIVE	C: CN	USR02

SAP VIORRR RE Search Request Table

Overview

Techincal Settings of VIORRR

List of VIORRR Fields

Foreign Key Relationships

Other References