SAP ABAP Table VIORRR_TAB (RE Search Request: Non-Key Fields)

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	VIORRR_TAB	Table Relationship Diagram
Short Description	RE Search Request: Non-Key Fields

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

Foreign Keys

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

History

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