SAP ABAP Table RECP_OI_DOC_OO (Document Data: Offered Object)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-CP (Application Component) Correspondence
     RE_CP_OI (Package) RE: Office Integration (Correspondence with OfficeIntegr.)
Basic Data
Table Category INTTAB    Structure 
Structure RECP_OI_DOC_OO   Table Relationship Diagram
Short Description Document Data: Offered Object    
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   Offered Object: Basic and Additional Data  
2 .INCLUDE       0   0   Offered Object  
3 .INCLUDE       0   0   Offered Object  
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   Offered Object: Key Fields  
7 OOID REOROOID REOROOID CHAR 20   0   Offered Object Number  
8 .INCLUDE       0   0   Offered Object: 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 OOBEG REOROOBEG RECADATEBEG DATS 8   0   Available From  
24 OOEND REOROOEND RECADATEEND DATS 8   0   Available To  
25 MEAS REBDMEAS REBDMEAS CHAR 4   0   Measurement Type TIVBDMEAS
26 USAGETYPE REBDUSAGETYPE SNUNR NUMC 4   0   Usage Type of Rental Object TIV01
27 RSOBJTYPE REORRSOBJTYPE REORRSOBJTYPE CHAR 2   0   Reservation Object Type TIVORRSOBJTYPE
28 RSAREA REORRSAREA REORRSAREA CHAR 10   0   Reservation Area TIVORRSAREA
29 ACQUISTYPE REORACQUISTYPE REORACQUISTYPE CHAR 2   0   Lease/Buy  
30 XOO REORXOO REORXLDESCRIPTION CHAR 255   0   Text for Offered Object  
31 OOIDEXT REOROOIDEXT REOROOIDEXT CHAR 45   0   External ID of Reservation Object  
32 OBJTYPEREF RECAOBJTYPE J_OBART CHAR 2   0   Object Type *
33 OBJNRREF RECAOBJNR J_OBJNR CHAR 22   0   Object Number *
34 OODATAFROM REOROODATAFROM RECADATEEND DATS 8   0   Offer Data Valid From  
35 OODATATO REOROODATATO RECADATEEND DATS 8   0   Offer Data Valid To  
36 OORESFROM REOROORESFROM RECADATEBEG DATS 8   0   Offer Reserved From  
37 OORESTO REOROORESTO RECADATEEND DATS 8   0   Offered Object Reserved To  
38 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
39 BENO REBDBENO REBDBENO CHAR 8   0   Business Entity Number *
40 BUNO REBDBUNO REBDBUNO CHAR 8   0   Number of Building  
41 PRNO REBDPRNO REBDPRNO CHAR 8   0   Number of Land  
42 RONO REBDRONO REBDRONO CHAR 8   0   Number of Rental Object  
43 OFID REOROFID REOROFID CHAR 13   0   Contract Offer Number  
44 .INCLU-01       0   0   Amount for Condition Group  
45 CDVALUE01 REORCDVALUE RECACURR CURR 15   2   Condition Amount  
46 CDCURR01 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
47 .INCLU-02       0   0   Amount for Condition Group  
48 CDVALUE02 REORCDVALUE RECACURR CURR 15   2   Condition Amount  
49 CDCURR02 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
50 .INCLU-03       0   0   Amount for Condition Group  
51 CDVALUE03 REORCDVALUE RECACURR CURR 15   2   Condition Amount  
52 CDCURR03 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
53 .INCLU-04       0   0   Amount for Condition Group  
54 CDVALUE04 REORCDVALUE RECACURR CURR 15   2   Condition Amount  
55 CDCURR04 RECDCONDCURR WAERS CUKY 5   0   Currency of condition item *
56 .INCLU-01       0   0   Measurement Amount  
57 MSVALUE01 REORMSVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount  
58 MSUNIT01 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
59 .INCLU-02       0   0   Measurement Amount  
60 MSVALUE02 REORMSVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount  
61 MSUNIT02 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
62 .INCLU-03       0   0   Measurement Amount  
63 MSVALUE03 REORMSVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount  
64 MSUNIT03 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
65 .INCLU-04       0   0   Measurement Amount  
66 MSVALUE04 REORMSVALUE REBDMEASVALUE QUAN 17   4   Measurement Amount  
67 MSUNIT04 REBDMEASUNIT MEINS UNIT 3   0   Measurement Unit *
68 FLOOR REORRRFLOOR REORRRFLOOR CHAR 2   0   Floor  
69 SSTDORT VVSSTDORT VVSSTDORT CHAR 10   0   Regional location TIV35
70 SLAGEWE SLAGEWE SLAGEWE NUMC 4   0   Business entity location number TIV10
71 SOBJLAGE RESOBJLAGE RESOBJLAGE NUMC 2   0   Indicator: District Location of Object TIV45
72 TRANSPCONN SVERKEHR SVERKEHR CHAR 1   0   Transport Connections of Business Entity TIV44
73 BUILDYEAR VVYBAUJAHR DATUM DATS 8   0   ConstYr  
74 RRCHARACTSTR REORRRCHARACTSTR REORCHARACTSTR CHAR 80   0   Fixtures and Fittings Characteristic String  
75 .INCLUDE       0   0   Address for Real Estate Search  
76 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
77 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
78 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
79 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
80 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
81 STREET AD_STREET TEXT60 CHAR 60   0   Street  
82 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
83 NEIGHBORH1 REBDNEIGHBORHOOD REBDNEIGHBORHOOD CHAR 30   0   Neighborhood  
84 NEIGHBORH2 REBDNEIGHBORHOOD REBDNEIGHBORHOOD CHAR 30   0   Neighborhood  
85 NEIGHBORH3 REBDNEIGHBORHOOD REBDNEIGHBORHOOD CHAR 30   0   Neighborhood  
86 AECNEEDED REORAECNEEDED RECABOOL CHAR 1   0   Accommodation Entitlement Certificate Required  
87 AECCLASSSTR REORAECCLASSSTR REORAECCLASSSTR CHAR 60   0   AEC Level String  
88 OBJNRCN REOROBJNRCN J_OBJNR CHAR 22   0   Outline Agreement *
89 ACCDETKEY RERAACCDETKEY RERAACCDETKEY CHAR 10   0   Account Determination Value TIVRADETKEY
90 RESPOBJNRDEF REORRESPOBJNRDEF J_OBJNR CHAR 22   0   Responsible Account Assignment Object (Default) *
91 RESPOBJNR1 REORRESPOBJNR J_OBJNR CHAR 22   0   Responsible Account Assignment Object *
92 RESPOBJNR2 REORRESPOBJNR J_OBJNR CHAR 22   0   Responsible Account Assignment Object *
93 RESPOBJNR3 REORRESPOBJNR J_OBJNR CHAR 22   0   Responsible Account Assignment Object *
94 RESPOBJNR4 REORRESPOBJNR J_OBJNR CHAR 22   0   Responsible Account Assignment Object *
95 PRICECODE1 REORPRICECODE REORPRICECODE CHAR 10   0   Price Code TIVORPRICECODE
96 PRICECODE2 REORPRICECODE REORPRICECODE CHAR 10   0   Price Code TIVORPRICECODE
97 PRICECODE3 REORPRICECODE REORPRICECODE CHAR 10   0   Price Code TIVORPRICECODE
98 PRICECODE4 REORPRICECODE REORPRICECODE CHAR 10   0   Price Code TIVORPRICECODE
99 LOCKEDFROM REORLOCKEDFROM RECADATEBEG DATS 8   0   Start of Lock Period  
100 LOCKEDTO REORLOCKEDTO RECADATE DATS 8   0   End of Lock Period  
101 LOCKREASON REORLOCKREASON REORLOCKREASON CHAR 4   0   Lock Reason TIVORLOCKRS
102 XLOCKREASONEXT REORXLOCKREASONEXT RECAXCOMMENT CHAR 100   0   Other Lock Reason  
103 BILLEDTO REORBILLEDTO RECADATE DATS 8   0   Date Up to Which Postings Were Made  
104 NTPER RECNNTPER RECADATE DATS 8   0   Contract Notice Per  
105 NTREQUESTON RECNNTREQUESTON RECADATE DATS 8   0   Tenant's notice request date  
106 BILLFROM REORBILLFROM RECADATE DATS 8   0   First Posting From  
107 .INCLUDE       0   0    
108 XAUTHGRP RECAXAUTHGRP RECAXLDESCRIPTION CHAR 60   0   Description of Authorization Group  
109 XRRFLOOR REORXRRFLOOR RECAXMDESCRIPTION CHAR 30   0   Name of Floor  
110 XSTDORT VVXSTDORT XTEXT35 CHAR 35   0   Regional location  
111 XMBEZ XLAGEWEM XMBEZ CHAR 30   0   Description of location of business entity  
112 XOBJLAGE XOBJLAGE XTEXT50 CHAR 50   0   District Location  
113 XVERKEHR XVERKEHR XTEXT50 CHAR 50   0   Transport connections  
114 XSTOCKL XGMBEZ XMBEZ CHAR 30   0   Long Description for Floor  
115 IDENTRESPOBJDEF REORRESPIDENTDEF CHAR50 CHAR 50   0   Standard Account Assignment Object (Default)  
116 IDENTRESPOBJ1 REORRESPIDENT CHAR50 CHAR 50   0   Responsible Account Assignment Object  
117 IDENTRESPOBJ2 REORRESPIDENT CHAR50 CHAR 50   0   Responsible Account Assignment Object  
118 IDENTRESPOBJ3 REORRESPIDENT CHAR50 CHAR 50   0   Responsible Account Assignment Object  
119 IDENTRESPOBJ4 REORRESPIDENT CHAR50 CHAR 50   0   Responsible Account Assignment Object  
120 XLOCKREASON REORXLOCKREASON RECAXMDESCRIPTION CHAR 30   0   Text for Lock Reason  
121 XNEIGHBORH1 REBDXNEIGHBORHOOD RECAXMDESCRIPTION CHAR 30   0   Text for Neighborhood  
122 XNEIGHBORH2 REBDXNEIGHBORHOOD RECAXMDESCRIPTION CHAR 30   0   Text for Neighborhood  
123 XNEIGHBORH3 REBDXNEIGHBORHOOD RECAXMDESCRIPTION CHAR 30   0   Text for Neighborhood  
124 XRSOBJTYPE REORXRSOBJTYPE RECAXMDESCRIPTION CHAR 30   0   Name of Reservation Object Type  
125 XPRICECODE1 REORXPRICECODE RECAXMDESCRIPTION CHAR 30   0   Name of Price Code  
126 XPRICECODE2 REORXPRICECODE RECAXMDESCRIPTION CHAR 30   0   Name of Price Code  
127 XPRICECODE3 REORXPRICECODE RECAXMDESCRIPTION CHAR 30   0   Name of Price Code  
128 XPRICECODE4 REORXPRICECODE RECAXMDESCRIPTION CHAR 30   0   Name of Price Code  
129 XACCDETKEY RERAXMACCDETKEY RECAXMDESCRIPTION CHAR 30   0   Account Determination Value Name  
130 .INCLUDE       0   0   Object Address  
131 .INCLU-_OB       0   0   Address  
132 XADDRESS_OB REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
133 CITY1_OB AD_CITY1 TEXT40 CHAR 40   0   City  
134 CITY2_OB AD_CITY2 TEXT40 CHAR 40   0   District  
135 POST_CODE1_OB AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
136 STREET_OB AD_STREET TEXT60 CHAR 60   0   Street  
137 HOUSE_NUM1_OB AD_HSNM1 TEXT10 CHAR 10   0   House Number  
138 COUNTRY_OB LAND1 LAND1 CHAR 3   0   Country Key *
139 REGION_OB REGIO REGIO CHAR 3   0   Region (State, Province, County) *
140 ADRZUS_OB REBDXOBJECT TEXT35 CHAR 35   0   Object Description  
141 ADRNR_OB AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
142 ADRNR_ORI_OB REBDJADRORIG REBDJDATORIG CHAR 1   0   Address Origin ID  
143 OBJNR_HI_OB REBDSOBJNRHI CHAR13 CHAR 13   0   Number of the Superordinate Address Object  
144 .INCLUDE       0   0   General Output Parameters  
145 TEMPLATE RECPOITEMPLATE TEXT64 CHAR 64   0   Template for Printing with Office Application  
146 LANGU RECPOILANGU SPRAS LANG 1   0   Language for Document Creation *
147 SELDATE RECPOISELDATE RECADATE DATS 8   0   Key Date for Data Selection  
148 PRNDATE RECPOIPRNDATE RECADATE DATS 8   0   Print Date  
149 .INCLUDE       0   0   General Data for the Business Object  
150 IDENTKEY RECAIDENTKEY CHAR45 CHAR 45   0   ID Part Key, for example "1000/123"  
151 IDENT RECAIDENT CHAR50 CHAR 50   0   Complete Object Identification, for Example BE 1000/123  
152 XIDENT RECAXIDENT TEXT80 CHAR 80   0   Object ID, for Example, Business Entity 1000/123  
153 XOBJTYPE RECAXOBJTYPE CHAR3 CHAR 3   0   Partial Object Type ID, for example "BE"  
154 XLOBJTYPE RECAXLOBJTYPE TEXT20 CHAR 20   0   Object Type Name (20)  
155 BUSTYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
156 BUSKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
157 .INCLUDE       0   0   Sender (Company Code Data)  
158 .INCLU-_SE       0   0   Company Code Data  
159 BUKRS_SE BUKRS BUKRS CHAR 4   0   Company Code *
160 BUTXT_SE BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
161 ORT01_SE ORT01 TEXT25 CHAR 25   0   City  
162 LAND1_SE LAND1 LAND1 CHAR 3   0   Country Key *
163 WAERS_SE WAERS WAERS CUKY 5   0   Currency Key *
164 SPRAS_SE SPRAS SPRAS LANG 1   0   Language Key *
165 KTOPL_SE KTOPL KTOPL CHAR 4   0   Chart of Accounts *
166 WAABW_SE WAABW_001 NUM02 NUMC 2   0   Maximum exchange rate deviation in percent  
167 PERIV_SE PERIV PERIV CHAR 2   0   Fiscal Year Variant *
168 KOKFI_SE KOKFI KOKFI CHAR 1   0   Allocation Indicator  
169 RCOMP_SE RCOMP_D RCOMP CHAR 6   0   Company *
170 ADRNR_SE ADRNR ADRNR CHAR 10   0   Address *
171 STCEG_SE STCEG STCEG CHAR 20   0   VAT Registration Number  
172 FIKRS_SE FIKRS FIKRS CHAR 4   0   Financial Management Area *
173 TXJCD_SE TXJCD_NSTX TXJCD CHAR 15   0   Jurisdiction for tax calculation - tax jurisdiction code *
174 .INCLUDE       0   0   Recipient  
175 .INCLU-_RC       0   0   Business Partner: General Data  
176 PARTNER_RC BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
177 PARTN_CAT_RC BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
178 SEARCHTERM1_RC BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
179 SEARCHTERM2_RC BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
180 FIRSTNAME_RC BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
181 LASTNAME_RC BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
182 NAME1_RC BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
183 NAME2_RC BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
184 NAME3_RC BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
185 NAME4_RC BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
186 NAMEGROUP1_RC BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
187 NAMEGROUP2_RC BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
188 XNAME_RC REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
189 XPARTNER_RC REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
190 XSALUTATION_RC REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
191 XADDRESS_RC REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
192 LINE0_RC LINES LINES CHAR 80   0   Address line  
193 LINE1_RC LINES LINES CHAR 80   0   Address line  
194 LINE2_RC LINES LINES CHAR 80   0   Address line  
195 LINE3_RC LINES LINES CHAR 80   0   Address line  
196 LINE4_RC LINES LINES CHAR 80   0   Address line  
197 LINE5_RC LINES LINES CHAR 80   0   Address line  
198 LINE6_RC LINES LINES CHAR 80   0   Address line  
199 LINE7_RC LINES LINES CHAR 80   0   Address line  
200 LINE8_RC LINES LINES CHAR 80   0   Address line  
201 LINE9_RC LINES LINES CHAR 80   0   Address line  
202 ADDRCATE_RC AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
203 ADDRNUMBER_RC AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
204 PERSNUMBER_RC AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
205 SMTP_ADDR_RC AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
206 TEL_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
207 TEL_NUMBER_RC AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
208 TEL_EXTENS_RC AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
209 TEL_NUMBER_LONG_RC AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
210 FAX_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
211 FAX_NUMBER_RC AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
212 FAX_EXTENS_RC AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
213 FAX_NUMBER_LONG_RC AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
214 INTRENO_RC RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
215 ROLE_RC REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
216 XROLE_RC REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
217 SUBROLE_RC REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
218 XSUBROLE_RC REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
219 ROLECATE_RC REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
220 APPL_RC REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
221 VALIDFROM_RC REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
222 VALIDTO_RC REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
223 ADDRTYPE_RC REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
224 .INCLUDE       0   0   Clerk  
225 .INCLU-_CL       0   0   Business Partner: General Data  
226 PARTNER_CL BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
227 PARTN_CAT_CL BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
228 SEARCHTERM1_CL BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
229 SEARCHTERM2_CL BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
230 FIRSTNAME_CL BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
231 LASTNAME_CL BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
232 NAME1_CL BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
233 NAME2_CL BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
234 NAME3_CL BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
235 NAME4_CL BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
236 NAMEGROUP1_CL BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
237 NAMEGROUP2_CL BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
238 XNAME_CL REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
239 XPARTNER_CL REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
240 XSALUTATION_CL REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
241 XADDRESS_CL REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
242 LINE0_CL LINES LINES CHAR 80   0   Address line  
243 LINE1_CL LINES LINES CHAR 80   0   Address line  
244 LINE2_CL LINES LINES CHAR 80   0   Address line  
245 LINE3_CL LINES LINES CHAR 80   0   Address line  
246 LINE4_CL LINES LINES CHAR 80   0   Address line  
247 LINE5_CL LINES LINES CHAR 80   0   Address line  
248 LINE6_CL LINES LINES CHAR 80   0   Address line  
249 LINE7_CL LINES LINES CHAR 80   0   Address line  
250 LINE8_CL LINES LINES CHAR 80   0   Address line  
251 LINE9_CL LINES LINES CHAR 80   0   Address line  
252 ADDRCATE_CL AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
253 ADDRNUMBER_CL AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
254 PERSNUMBER_CL AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
255 SMTP_ADDR_CL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
256 TEL_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
257 TEL_NUMBER_CL AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
258 TEL_EXTENS_CL AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
259 TEL_NUMBER_LONG_CL AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
260 FAX_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
261 FAX_NUMBER_CL AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
262 FAX_EXTENS_CL AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
263 FAX_NUMBER_LONG_CL AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
264 INTRENO_CL RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
265 ROLE_CL REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
266 XROLE_CL REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
267 SUBROLE_CL REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
268 XSUBROLE_CL REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
269 ROLECATE_CL REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
270 APPL_CL REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
271 VALIDFROM_CL REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
272 VALIDTO_CL REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
273 ADDRTYPE_CL REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
274 .INCLUDE       0   0   Further Partner 1  
275 .INCLU-_P1       0   0   Business Partner: General Data  
276 PARTNER_P1 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
277 PARTN_CAT_P1 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
278 SEARCHTERM1_P1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
279 SEARCHTERM2_P1 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
280 FIRSTNAME_P1 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
281 LASTNAME_P1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
282 NAME1_P1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
283 NAME2_P1 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
284 NAME3_P1 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
285 NAME4_P1 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
286 NAMEGROUP1_P1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
287 NAMEGROUP2_P1 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
288 XNAME_P1 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
289 XPARTNER_P1 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
290 XSALUTATION_P1 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
291 XADDRESS_P1 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
292 LINE0_P1 LINES LINES CHAR 80   0   Address line  
293 LINE1_P1 LINES LINES CHAR 80   0   Address line  
294 LINE2_P1 LINES LINES CHAR 80   0   Address line  
295 LINE3_P1 LINES LINES CHAR 80   0   Address line  
296 LINE4_P1 LINES LINES CHAR 80   0   Address line  
297 LINE5_P1 LINES LINES CHAR 80   0   Address line  
298 LINE6_P1 LINES LINES CHAR 80   0   Address line  
299 LINE7_P1 LINES LINES CHAR 80   0   Address line  
300 LINE8_P1 LINES LINES CHAR 80   0   Address line  
301 LINE9_P1 LINES LINES CHAR 80   0   Address line  
302 ADDRCATE_P1 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
303 ADDRNUMBER_P1 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
304 PERSNUMBER_P1 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
305 SMTP_ADDR_P1 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
306 TEL_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
307 TEL_NUMBER_P1 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
308 TEL_EXTENS_P1 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
309 TEL_NUMBER_LONG_P1 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
310 FAX_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
311 FAX_NUMBER_P1 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
312 FAX_EXTENS_P1 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
313 FAX_NUMBER_LONG_P1 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
314 INTRENO_P1 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
315 ROLE_P1 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
316 XROLE_P1 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
317 SUBROLE_P1 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
318 XSUBROLE_P1 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
319 ROLECATE_P1 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
320 APPL_P1 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
321 VALIDFROM_P1 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
322 VALIDTO_P1 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
323 ADDRTYPE_P1 REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
324 .INCLUDE       0   0   Further Partner 2  
325 .INCLU-_P2       0   0   Business Partner: General Data  
326 PARTNER_P2 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
327 PARTN_CAT_P2 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
328 SEARCHTERM1_P2 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
329 SEARCHTERM2_P2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
330 FIRSTNAME_P2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
331 LASTNAME_P2 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
332 NAME1_P2 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
333 NAME2_P2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
334 NAME3_P2 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
335 NAME4_P2 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
336 NAMEGROUP1_P2 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
337 NAMEGROUP2_P2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
338 XNAME_P2 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
339 XPARTNER_P2 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
340 XSALUTATION_P2 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
341 XADDRESS_P2 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
342 LINE0_P2 LINES LINES CHAR 80   0   Address line  
343 LINE1_P2 LINES LINES CHAR 80   0   Address line  
344 LINE2_P2 LINES LINES CHAR 80   0   Address line  
345 LINE3_P2 LINES LINES CHAR 80   0   Address line  
346 LINE4_P2 LINES LINES CHAR 80   0   Address line  
347 LINE5_P2 LINES LINES CHAR 80   0   Address line  
348 LINE6_P2 LINES LINES CHAR 80   0   Address line  
349 LINE7_P2 LINES LINES CHAR 80   0   Address line  
350 LINE8_P2 LINES LINES CHAR 80   0   Address line  
351 LINE9_P2 LINES LINES CHAR 80   0   Address line  
352 ADDRCATE_P2 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
353 ADDRNUMBER_P2 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
354 PERSNUMBER_P2 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
355 SMTP_ADDR_P2 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
356 TEL_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
357 TEL_NUMBER_P2 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
358 TEL_EXTENS_P2 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
359 TEL_NUMBER_LONG_P2 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
360 FAX_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
361 FAX_NUMBER_P2 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
362 FAX_EXTENS_P2 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
363 FAX_NUMBER_LONG_P2 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
364 INTRENO_P2 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
365 ROLE_P2 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
366 XROLE_P2 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
367 SUBROLE_P2 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
368 XSUBROLE_P2 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
369 ROLECATE_P2 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
370 APPL_P2 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
371 VALIDFROM_P2 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
372 VALIDTO_P2 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
373 ADDRTYPE_P2 REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RECP_OI_DOC_OO ACCDETKEY TIVRADETKEY ACCDETKEY    
2 RECP_OI_DOC_OO COUNTRY T005 LAND1    
3 RECP_OI_DOC_OO LOCKREASON TIVORLOCKRS LOCKREASON REF C CN
4 RECP_OI_DOC_OO MEAS TIVBDMEAS MEAS    
5 RECP_OI_DOC_OO PRICECODE1 TIVORPRICECODE PRICECODE    
6 RECP_OI_DOC_OO PRICECODE2 TIVORPRICECODE PRICECODE    
7 RECP_OI_DOC_OO PRICECODE3 TIVORPRICECODE PRICECODE    
8 RECP_OI_DOC_OO PRICECODE4 TIVORPRICECODE PRICECODE    
9 RECP_OI_DOC_OO REGION T005S BLAND    
10 RECP_OI_DOC_OO RESPONSIBLE USR02 BNAME REF 1 CN
11 RECP_OI_DOC_OO RSAREA TIVORRSAREA RSAREA REF C CN
12 RECP_OI_DOC_OO RSOBJTYPE TIVORRSOBJTYPE RSOBJTYPE REF C CN
13 RECP_OI_DOC_OO SLAGEWE TIV10 SLAGEWE    
14 RECP_OI_DOC_OO SOBJLAGE TIV45 SOBJLAGE    
15 RECP_OI_DOC_OO SSTDORT TIV35 SSTDORT    
16 RECP_OI_DOC_OO SUBROLE_CL TIVBPSUBROLE SUBROLE REF C CN
17 RECP_OI_DOC_OO SUBROLE_P1 TIVBPSUBROLE SUBROLE REF C CN
18 RECP_OI_DOC_OO SUBROLE_P2 TIVBPSUBROLE SUBROLE REF C CN
19 RECP_OI_DOC_OO SUBROLE_RC TIVBPSUBROLE SUBROLE REF C CN
20 RECP_OI_DOC_OO TRANSPCONN TIV44 SVERKEHR    
21 RECP_OI_DOC_OO USAGETYPE TIV01 SNUNR    
22 RECP_OI_DOC_OO USEREXCLUSIVE USR02 BNAME REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 600