SAP ABAP Table REOR_RENTAL_REQUEST (RE Search Request (VIORRR))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-OR (Application Component) Offer and Rental Request
     ⤷ RE_OR_RR (Package) RE: RE Search Request

Basic Data

Table Category	INTTAB	Structure
Structure	REOR_RENTAL_REQUEST	Table Relationship Diagram
Short Description	RE Search Request (VIORRR)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Rental Request
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
4	.INCLUDE	☐				0	0	RE Search Request: Key Fields
5	RRID	☐	REORRRID	REORRRID	CHAR	20	0	RE Search Request Number
6	.INCLUDE	☐				0	0	RE Search Request: Non-Key Fields
7	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
8	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
9	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
10	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
11	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
12	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
13	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
14	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
15	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
16	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
17	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
18	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
19	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
20	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
21	RRCNBEG	☐	REORRRCNBEG	REORRRCNBEG	DATS	8	0	Requested Contract Start Date
22	RRCNEND	☐	REORRRCNEND	RECADATEEND	DATS	8	0	Requested Contract End Date
23	RRCNBEGLATER	☐	REORRRCNBEGLATER	RECABOOL	CHAR	1	0	Later Contract Start Date Possible
24	RRTYPE	☐	REORRRTYPE	REORRRTYPE	CHAR	2	0	Type of RE Search Request	TIVORRRTYPE
25	ACQUISTYPE	☐	REORACQUISTYPE	REORACQUISTYPE	CHAR	2	0	Lease/Buy
26	XRR	☐	REORXRR	REORXLDESCRIPTION	CHAR	255	0	Text for RE Search Request
27	SEARCHTERM	☐	REORSEARCHTERM	RSDSSELOPT	CHAR	45	0	Text Search
28	.INCLU-01	☐				0	0	Maximum Amount for Condition Group
29	CDVALUETO01	☐	REORCDVALUETO	RECACURR	CURR	15	2	Maximum Condition Amount
30	CDVALUETOL01	☐	REORCDVALUETOL	RECACURR	CURR	15	2	Maximum Condition Amount Including Tolerance Limit
31	CDCURR01	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
32	.INCLU-02	☐				0	0	Maximum Amount for Condition Group
33	CDVALUETO02	☐	REORCDVALUETO	RECACURR	CURR	15	2	Maximum Condition Amount
34	CDVALUETOL02	☐	REORCDVALUETOL	RECACURR	CURR	15	2	Maximum Condition Amount Including Tolerance Limit
35	CDCURR02	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
36	.INCLU-03	☐				0	0	Maximum Amount for Condition Group
37	CDVALUETO03	☐	REORCDVALUETO	RECACURR	CURR	15	2	Maximum Condition Amount
38	CDVALUETOL03	☐	REORCDVALUETOL	RECACURR	CURR	15	2	Maximum Condition Amount Including Tolerance Limit
39	CDCURR03	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
40	.INCLU-04	☐				0	0	Maximum Amount for Condition Group
41	CDVALUETO04	☐	REORCDVALUETO	RECACURR	CURR	15	2	Maximum Condition Amount
42	CDVALUETOL04	☐	REORCDVALUETOL	RECACURR	CURR	15	2	Maximum Condition Amount Including Tolerance Limit
43	CDCURR04	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
44	.INCLU-01	☐				0	0	Size Restrictions for Measurement Type
45	MSVALUEFROM01	☐	REORMSVALUEFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement
46	MSVALUETO01	☐	REORMSVALUETO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement
47	MSVALUETOLFROM01	☐	REORMSVALUETOLFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement Including Tolerance Limit
48	MSVALUETOLTO01	☐	REORMSVALUETOLTO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement Including Tolerance
49	MSUNIT01	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
50	.INCLU-02	☐				0	0	Size Restrictions for Measurement Type
51	MSVALUEFROM02	☐	REORMSVALUEFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement
52	MSVALUETO02	☐	REORMSVALUETO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement
53	MSVALUETOLFROM02	☐	REORMSVALUETOLFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement Including Tolerance Limit
54	MSVALUETOLTO02	☐	REORMSVALUETOLTO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement Including Tolerance
55	MSUNIT02	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
56	.INCLU-03	☐				0	0	Size Restrictions for Measurement Type
57	MSVALUEFROM03	☐	REORMSVALUEFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement
58	MSVALUETO03	☐	REORMSVALUETO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement
59	MSVALUETOLFROM03	☐	REORMSVALUETOLFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement Including Tolerance Limit
60	MSVALUETOLTO03	☐	REORMSVALUETOLTO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement Including Tolerance
61	MSUNIT03	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
62	.INCLU-04	☐				0	0	Size Restrictions for Measurement Type
63	MSVALUEFROM04	☐	REORMSVALUEFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement
64	MSVALUETO04	☐	REORMSVALUETO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement
65	MSVALUETOLFROM04	☐	REORMSVALUETOLFROM	REBDMEASVALUE	QUAN	17	4	Minimum Measurement Including Tolerance Limit
66	MSVALUETOLTO04	☐	REORMSVALUETOLTO	REBDMEASVALUE	QUAN	17	4	Maximum Measurement Including Tolerance
67	MSUNIT04	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
68	RRFLOORSTR	☐	REORRRFLOORSTR	REORRRFLOORSTR	CHAR	255	0	Floor
69	RRREGLOCSTR	☐	REORRRREGLOCSTR	REORRRREGLOCSTR	CHAR	255	0	Regional Location
70	RRLOCATIONSTR	☐	REORRRLOCATIONSTR	REORRRLOCATIONSTR	CHAR	255	0	Location
71	RRLOCATIONNESTR	☐	REORRRLOCATIONSTR	REORRRLOCATIONSTR	CHAR	255	0	Location
72	RRDISTLOCSTR	☐	REORRRDISTLOCSTR	REORRRDISTLOCSTR	CHAR	255	0	District Location
73	RRTRANSPCONNSTR	☐	REORRRTRANSPCONNSTR	REORRRTRANSPCONNSTR	CHAR	255	0	Transport Connections
74	BUILDAGEFROM	☐	REORBUILDAGEFROM	RECADATEBEG	DATS	8	0	Building Age From
75	BUILDAGETO	☐	REORBUILDAGETO	RECADATEEND	DATS	8	0	Building Age To
76	RRCHARACTSTR	☐	REORRRCHARACTSTR	REORCHARACTSTR	CHAR	80	0	Fixtures and Fittings Characteristic String
77	.INCLUDE	☐				0	0	Address for Real Estate Search
78	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
79	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
80	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
81	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
82	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
83	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
84	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
85	NEIGHBORHOODSTR	☐	REORNEIGHBORHOODSTR	REORNEIGHBORHOODSTR	CHAR	255	0	Neighborhood
86	EDITINDICATOR	☐	REOREDITINDICATOR	REOREDITINDICATOR	CHAR	2	0	Processing Indicator for RE Search Request	TIVOREDITIND
87	EDITSTATUS	☐	REOREDITSTATUS	REOREDITSTATUS	CHAR	2	0	Processing Status for RE Search Request	TIVOREDITSTAT
88	PRESELECTION	☐	REORPRESELECTION	REORPRESELECTION	CHAR	2	0	Preselection Indicator for RE Search Request	TIVORPRESELECT
89	INFLOWFROM	☐	REORINFLOWFROM	REORINFLOWFROM	CHAR	2	0	Source of Prospect	TIVORINFLOWFROM
90	INFLOWREASON	☐	REORINFLOWREASON	REORINFLOWREASON	CHAR	2	0	Reason for Search	TIVORINFLOWREAS
91	INFLOWWAY	☐	REORINFLOWWAY	REORINFLOWWAY	CHAR	2	0	Source of Inquiry	TIVORINFLOWWAY
92	RRSEARCHPART	☐	REORRRSEARCHPART	REORRRSEARCHPART	CHAR	1	0	Participation in Search
93	AECEXISTS	☐	REORAECEXISTS	RECABOOL	CHAR	1	0	Accommodation Entitlement Certificate Exists
94	AECCLASSSTR	☐	REORAECCLASSSTR	REORAECCLASSSTR	CHAR	60	0	AEC Level String
95	AECDATEOFISSUE	☐	REORAECDATEOFISSUE	RECADATE	DATS	8	0	Issue Date of Accommodation Entitlement Certificate
96	AECVALIDTO	☐	REORAECVALIDTO	RECADATEEND	DATS	8	0	Accommodation Entitlement Certificate Valid To
97	AECPRIORITY	☐	REORAECPRIORITY	REORAECPRIORITY	CHAR	4	0	Priority for Accommodation Entitlement Certificate	TIVORAECPRIO
98	AECPERSONGROUP	☐	REORAECPERSONGROUP	REORAECPERSONGROUP	CHAR	4	0	Person Group for Accommodation Entitlement Certificate	TIVORAECPERSON
99	AECINFO	☐	REORAECINFO	REORAECINFO	CHAR	4	0	Additional Info for Accommodation Entitlement Certificate	TIVORAECINFO
100	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REOR_RENTAL_REQUEST	AECINFO	TIVORAECINFO	AECINFO
2	REOR_RENTAL_REQUEST	AECPERSONGROUP	TIVORAECPERSON	AECPERSONGROUP
3	REOR_RENTAL_REQUEST	AECPRIORITY	TIVORAECPRIO	AECPRIORITY
4	REOR_RENTAL_REQUEST	COUNTRY	T005	LAND1
5	REOR_RENTAL_REQUEST	EDITINDICATOR	TIVOREDITIND	EDITINDICATOR
6	REOR_RENTAL_REQUEST	EDITSTATUS	TIVOREDITSTAT	EDITSTATUS
7	REOR_RENTAL_REQUEST	INFLOWFROM	TIVORINFLOWFROM	INFLOWFROM
8	REOR_RENTAL_REQUEST	INFLOWREASON	TIVORINFLOWREAS	INFLOWREASON
9	REOR_RENTAL_REQUEST	INFLOWWAY	TIVORINFLOWWAY	INFLOWWAY
10	REOR_RENTAL_REQUEST	PRESELECTION	TIVORPRESELECT	PRESELECTION
11	REOR_RENTAL_REQUEST	REGION	T005S	BLAND
12	REOR_RENTAL_REQUEST	RESPONSIBLE	USR02	BNAME	REF	1	CN
13	REOR_RENTAL_REQUEST	RRTYPE	TIVORRRTYPE	RRTYPE	REF	1	CN
14	REOR_RENTAL_REQUEST	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600