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
⤷ 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 |