SAP ABAP Table VIORRR (Rental Request)

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	TRANSP	Transparent table
Transparent table	VIORRR	Table Relationship Diagram
Short Description	Rental Request

Delivery and Maintenance

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

Foreign Keys

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

History

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