SAP ABAP Table REIS_OF_L (ALV Reporting: Contract Offer)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-IS (Application Component) Information System
     RE_IS_OR (Package) RE: Contract Offer and RE Search Request Information System
Basic Data
Table Category INTTAB    Structure 
Structure REIS_OF_L   Table Relationship Diagram
Short Description ALV Reporting: Contract Offer    
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   Contract Offer: Reason and Additional Data  
2 .INCLUDE       0   0   Contract Offer  
3 .INCLUDE       0   0   Contract Offer  
4 MANDT MANDT MANDT CLNT 3   0   Client *
5 INTRENO RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
6 .INCLUDE       0   0   Contract Offer: Key Fields  
7 OFID REOROFID REOROFID CHAR 13   0   Contract Offer Number  
8 .INCLUDE       0   0   Contract Offer: Non-Key Fields  
9 OBJNR RECAOBJNR J_OBJNR CHAR 22   0   Object Number *
10 CREATIONTYPE RECACREATIONTYPE RECACREATIONTYPE CHAR 1   0   How the Object Was Created  
11 .INCLUDE       0   0   Field String for Maintenance of User Data  
12 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
13 DERF DERF DATUM DATS 8   0   First Entered on  
14 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
15 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
16 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
17 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
18 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
19 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
20 RESPONSIBLE RECARESPONSIBLE XUBNAME CHAR 12   0   Person Responsible USR02
21 USEREXCLUSIVE RECAUSEREXCLUSIVE XUBNAME CHAR 12   0   User with Exclusive Change Authorization USR02
22 AUTHGRP RECAAUTHGRP RECAAUTHGRP CHAR 40   0   Authorization Group  
23 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
24 RECNTYPE RECNCONTRACTTYPE SMVART CHAR 4   0   Contract Type *
25 OFCNBEG RECNCNBEG RECADATE DATS 8   0   Date of contract start  
26 OFCNENDABS RECNCNENDABS RECADATEEND DATS 8   0   Term End Date  
27 XOF REORXOF RECAXLDESCRIPTION CHAR 60   0   Name of Contract Offer  
28 OFREJDATE REOROFREJDATE RECADATE DATS 8   0   Rejection of Contract Offer  
29 RECNNR RECNNUMBER RECNNUMBER CHAR 13   0   Contract Number  
30 RECNTLAW SMIETR SMIETR CHAR 5   0   Tenancy law TIV03
31 RECNBUKRSCOLLECT RECNBUKRSCOLLECT BUKRS CHAR 4   0   Company code of main contract T001
32 RECNNRCOLLECT RECNNUMBERCOLLECT RECNNUMBER CHAR 13   0   Number of Real Estate Main Contract  
33 RECNCNCURR RECNWAERS_CN WAERS CUKY 5   0   Currency for Contract TCURC
34 INDUSTRY BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry *
35 SRRELEVANT RECNSALESRENTRELEVANT RECABOOL CHAR 1   0   Relevant to Sales  
36 DPTARGETTYPE RECNDPTYPE RECNDPTYPE CHAR 4   0   Security Deposit Type TIVCNDPTYPE
37 OFRESTO REOROFRESTO RECADATE DATS 8   0   Contract Offer Reserved To  
38 RECNDAT RECNDAT DDAT DATS 8   0   Date of Contract Conclusion  
39 RECNDPO RECDCFSTARTFROM RECADATE DATS 8   0   Cash Flow Generated Starting On  
40 RECNEND1ST RECNCNEND1ST RECADATE DATS 8   0   Date of First Contract End  
41 BENOCN RECNBENOCN REBDBENO CHAR 8   0   Business Entity That Belongs to Contract *
42 POSSDATEFROM REBDPOSSDATEFROM RECADATE DATS 8   0   Date From Which the Object Is Made Available for Use  
43 POSSDATETO REBDPOSSDATETO RECADATE DATS 8   0   Date Up to Which the Object Is Used  
44 .INCLUDE       0   0    
45 XBUKRS BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
46 XRECNTYPE XMVARTM XMBEZ CHAR 30   0   Description of type of RE contract type  
47 XTENANCYLAW XMIETR XTEXT50 CHAR 50   0   Tenancy law long text  
48 XCOLLECT RECNTXT XTEXT80 CHAR 80   0   Contract name  
49 XAUTHGRP RECAXAUTHGRP RECAXLDESCRIPTION CHAR 60   0   Description of Authorization Group  
50 XINDUSTRY BU_TEXT20 TEXT20 CHAR 20   0   Description  
51 RECNTXT RECNTXT XTEXT80 CHAR 80   0   Contract name  
52 .INCLUDE       0   0   Time Slot Valid in a Row in the Info System  
53 RECISVALIDFROM REISRECVALIDFROM RECADATE DATS 8   0   Displayed Row Is Valid From  
54 RECISVALIDTO REISRECVALIDTO RECADATE DATS 8   0   Displayed Row Is Valid Until  
55 .INCLUDE       0   0   Maximum Possible Set of Conditions for Reporting  
56 .INCLU-01       0   0   Condition in Report Profile  
57 CONDVALUE_CN01 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
58 CONDCURR_CN01 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
59 FREQUENCY_CN01 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
60 CONDVALIDFROM_CN01 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
61 CONDVALIDTO_CN01 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
62 UNITPRICE_CN01 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
63 CONDVALUENET_CN01 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
64 CONDVALUEGROSS_CN01 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
65 .INCLU-02       0   0   Condition in Report Profile  
66 CONDVALUE_CN02 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
67 CONDCURR_CN02 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
68 FREQUENCY_CN02 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
69 CONDVALIDFROM_CN02 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
70 CONDVALIDTO_CN02 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
71 UNITPRICE_CN02 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
72 CONDVALUENET_CN02 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
73 CONDVALUEGROSS_CN02 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
74 .INCLU-03       0   0   Condition in Report Profile  
75 CONDVALUE_CN03 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
76 CONDCURR_CN03 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
77 FREQUENCY_CN03 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
78 CONDVALIDFROM_CN03 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
79 CONDVALIDTO_CN03 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
80 UNITPRICE_CN03 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
81 CONDVALUENET_CN03 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
82 CONDVALUEGROSS_CN03 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
83 .INCLU-04       0   0   Condition in Report Profile  
84 CONDVALUE_CN04 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
85 CONDCURR_CN04 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
86 FREQUENCY_CN04 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
87 CONDVALIDFROM_CN04 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
88 CONDVALIDTO_CN04 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
89 UNITPRICE_CN04 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
90 CONDVALUENET_CN04 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
91 CONDVALUEGROSS_CN04 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
92 .INCLU-05       0   0   Condition in Report Profile  
93 CONDVALUE_CN05 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
94 CONDCURR_CN05 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
95 FREQUENCY_CN05 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
96 CONDVALIDFROM_CN05 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
97 CONDVALIDTO_CN05 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
98 UNITPRICE_CN05 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
99 CONDVALUENET_CN05 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
100 CONDVALUEGROSS_CN05 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
101 .INCLU-06       0   0   Condition in Report Profile  
102 CONDVALUE_CN06 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
103 CONDCURR_CN06 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
104 FREQUENCY_CN06 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
105 CONDVALIDFROM_CN06 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
106 CONDVALIDTO_CN06 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
107 UNITPRICE_CN06 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
108 CONDVALUENET_CN06 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
109 CONDVALUEGROSS_CN06 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
110 .INCLU-07       0   0   Condition in Report Profile  
111 CONDVALUE_CN07 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
112 CONDCURR_CN07 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
113 FREQUENCY_CN07 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
114 CONDVALIDFROM_CN07 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
115 CONDVALIDTO_CN07 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
116 UNITPRICE_CN07 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
117 CONDVALUENET_CN07 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
118 CONDVALUEGROSS_CN07 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
119 .INCLU-08       0   0   Condition in Report Profile  
120 CONDVALUE_CN08 RECDCONDVALUE RECACURR CURR 15   2   Condition item currency amount  
121 CONDCURR_CN08 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
122 FREQUENCY_CN08 REISFREQUENCY   CHAR 12   0   Name of Unit for Posting Frequency  
123 CONDVALIDFROM_CN08 RECDVALIDFROM RECADATE DATS 8   0   Date from when condition is valid  
124 CONDVALIDTO_CN08 RECDVALIDTO RECADATEEND DATS 8   0   Date up to when condition is valid  
125 UNITPRICE_CN08 REISCONDMEASPRICE RECDUNITPRICE DEC 19   6   Price per Measurement  
126 CONDVALUENET_CN08 RECDCONDVALUENET RECACURR CURR 15   2   Currency Amount (Net) of Condition Item  
127 CONDVALUEGROSS_CN08 RECDCONDVALUEGROSS RECACURR CURR 15   2   Currency Amount (Gross) of Condition Item  
128 .INCLUDE       0   0    
129 CONDVALUEFURTHER_CN REISCONDVALUEFURTHER RECACURR CURR 15   2   Total of Further Condition Amounts  
130 TAXVALUE_CN RECDTAXVALUE RECACURR CURR 15   2   Tax on Sales/Purchase of Condition Item  
131 CDCNISVALIDFROM REISRECVALIDFROM RECADATE DATS 8   0   Displayed Row Is Valid From  
132 CDCNISVALIDTO REISRECVALIDTO RECADATE DATS 8   0   Displayed Row Is Valid Until  
133 .INCLUDE       0   0   Reporting Fields: Main Contractual Partner  
134 ROLE_BP1 REBPROLE1 BU_ROLE CHAR 6   0   First Main Contractual Partner: Role *
135 XROLE_BP1 REBPXROLE1 RECAXMDESCRIPTION CHAR 30   0   1st Main Contractual Partner: Name of Role Category  
136 PARTNER_BP1 REBPPARTNER1 BU_PARTNER CHAR 10   0   First Main Contractual Partner *
137 XPARTNER_BP1 REBPXPARTNER1 TEXT80 CHAR 80   0   Name/Address of 1st Business Partner  
138 TEL_NUMBER_LONG_BP1 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
139 FAX_NUMBER_LONG_BP1 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
140 SMTP_ADDR_BP1 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
141 XNAME_BP1 REBPXNAME1 BU_TEXT50 CHAR 50   0   Short Description of 1st Business Partner  
142 STREET_BP1 AD_STREET TEXT60 CHAR 60   0   Street  
143 HOUSE_NUM1_BP1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
144 POST_CODE1_BP1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
145 CITY1_BP1 AD_CITY1 TEXT40 CHAR 40   0   City  
146 CITY2_BP1 AD_CITY2 TEXT40 CHAR 40   0   District  
147 REGION_BP1 REGIO REGIO CHAR 3   0   Region (State, Province, County) *
148 PO_BOX_BP1 AD_POBX CHAR10 CHAR 10   0   PO Box  
149 POST_CODE2_BP1 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
150 ROLE_BP2 REBPROLE2 BU_ROLE CHAR 6   0   Second Main Contractual Partner: Role *
151 XROLE_BP2 REBPXROLE2 RECAXMDESCRIPTION CHAR 30   0   2nd Main Contractual Partner: Name of Role Category  
152 PARTNER_BP2 REBPPARTNER2 BU_PARTNER CHAR 10   0   Second Main Contractual Partner *
153 XPARTNER_BP2 REBPXPARTNER2 TEXT80 CHAR 80   0   Name/Address of 2nd Business Partner  
154 TEL_NUMBER_LONG_BP2 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
155 FAX_NUMBER_LONG_BP2 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
156 SMTP_ADDR_BP2 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
157 XNAME_BP2 REBPXNAME2 BU_TEXT50 CHAR 50   0   Short Description of 2nd Business Partner  
158 STREET_BP2 AD_STREET TEXT60 CHAR 60   0   Street  
159 HOUSE_NUM1_BP2 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
160 POST_CODE1_BP2 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
161 CITY1_BP2 AD_CITY1 TEXT40 CHAR 40   0   City  
162 CITY2_BP2 AD_CITY2 TEXT40 CHAR 40   0   District  
163 REGION_BP2 REGIO REGIO CHAR 3   0   Region (State, Province, County) *
164 PO_BOX_BP2 AD_POBX CHAR10 CHAR 10   0   PO Box  
165 POST_CODE2_BP2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
166 ALVROWS REISALVROWS   INT2 5   0   Number of Rows  
167 .INCLUDE       0   0   Measurements in Report Profile  
168 .INCLU-01       0   0   Measurement in Report Profile  
169 MEASVALUE01 REBDMEASVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount: Available  
170 MEASVALUECMPL01 REBDMEASVALUECMPL REBDMEASVALUE QUAN 17   4   Measurement Amount: Capacity  
171 MEASUNIT01 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
172 MEASVALIDFROM01 REBDMEASVALIDFROM RECADATE DATS 8   0   Date: Measurement Valid From  
173 MEASVALIDTO01 REBDMEASVALIDTO RECADATEEND DATS 8   0   Date: Measurement Valid To  
174 .INCLU-02       0   0   Measurement in Report Profile  
175 MEASVALUE02 REBDMEASVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount: Available  
176 MEASVALUECMPL02 REBDMEASVALUECMPL REBDMEASVALUE QUAN 17   4   Measurement Amount: Capacity  
177 MEASUNIT02 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
178 MEASVALIDFROM02 REBDMEASVALIDFROM RECADATE DATS 8   0   Date: Measurement Valid From  
179 MEASVALIDTO02 REBDMEASVALIDTO RECADATEEND DATS 8   0   Date: Measurement Valid To  
180 .INCLU-03       0   0   Measurement in Report Profile  
181 MEASVALUE03 REBDMEASVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount: Available  
182 MEASVALUECMPL03 REBDMEASVALUECMPL REBDMEASVALUE QUAN 17   4   Measurement Amount: Capacity  
183 MEASUNIT03 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
184 MEASVALIDFROM03 REBDMEASVALIDFROM RECADATE DATS 8   0   Date: Measurement Valid From  
185 MEASVALIDTO03 REBDMEASVALIDTO RECADATEEND DATS 8   0   Date: Measurement Valid To  
186 .INCLU-04       0   0   Measurement in Report Profile  
187 MEASVALUE04 REBDMEASVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount: Available  
188 MEASVALUECMPL04 REBDMEASVALUECMPL REBDMEASVALUE QUAN 17   4   Measurement Amount: Capacity  
189 MEASUNIT04 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
190 MEASVALIDFROM04 REBDMEASVALIDFROM RECADATE DATS 8   0   Date: Measurement Valid From  
191 MEASVALIDTO04 REBDMEASVALIDTO RECADATEEND DATS 8   0   Date: Measurement Valid To  
192 .INCLU-05       0   0   Measurement in Report Profile  
193 MEASVALUE05 REBDMEASVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount: Available  
194 MEASVALUECMPL05 REBDMEASVALUECMPL REBDMEASVALUE QUAN 17   4   Measurement Amount: Capacity  
195 MEASUNIT05 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
196 MEASVALIDFROM05 REBDMEASVALIDFROM RECADATE DATS 8   0   Date: Measurement Valid From  
197 MEASVALIDTO05 REBDMEASVALIDTO RECADATEEND DATS 8   0   Date: Measurement Valid To  
198 .INCLUDE       0   0    
199 MEASISVALIDFROM REISRECVALIDFROM RECADATE DATS 8   0   Displayed Row Is Valid From  
200 MEASISVALIDTO REISRECVALIDTO RECADATE DATS 8   0   Displayed Row Is Valid Until  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 REIS_OF_L DPTARGETTYPE TIVCNDPTYPE DPTYPE    
2 REIS_OF_L RECNBUKRSCOLLECT T001 BUKRS    
3 REIS_OF_L RECNCNCURR TCURC WAERS    
4 REIS_OF_L RECNTLAW TIV03 SMIETR    
5 REIS_OF_L RESPONSIBLE USR02 BNAME REF 1 CN
6 REIS_OF_L USEREXCLUSIVE USR02 BNAME REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 600