VIORRR - RE Search Request

RE Search Request information is stored in SAP table VIORRR.
It is part of development package RE_OR_RR in software component RE-FX-OR. This development package consists of objects that can be grouped under "RE: RE Search Request".

Fields for table VIORRR

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