SAP ABAP Table RECP_OI_DOC_OF (Document Data: Contract Offer)
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_OF   Table Relationship Diagram
Short Description Document Data: 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   General Output Parameters  
53 TEMPLATE RECPOITEMPLATE TEXT64 CHAR 64   0   Template for Printing with Office Application  
54 LANGU RECPOILANGU SPRAS LANG 1   0   Language for Document Creation *
55 SELDATE RECPOISELDATE RECADATE DATS 8   0   Key Date for Data Selection  
56 PRNDATE RECPOIPRNDATE RECADATE DATS 8   0   Print Date  
57 .INCLUDE       0   0   General Data for the Business Object  
58 IDENTKEY RECAIDENTKEY CHAR45 CHAR 45   0   ID Part Key, for example "1000/123"  
59 IDENT RECAIDENT CHAR50 CHAR 50   0   Complete Object Identification, for Example BE 1000/123  
60 XIDENT RECAXIDENT TEXT80 CHAR 80   0   Object ID, for Example, Business Entity 1000/123  
61 XOBJTYPE RECAXOBJTYPE CHAR3 CHAR 3   0   Partial Object Type ID, for example "BE"  
62 XLOBJTYPE RECAXLOBJTYPE TEXT20 CHAR 20   0   Object Type Name (20)  
63 BUSTYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
64 BUSKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
65 .INCLUDE       0   0   Sender (Company Code Data)  
66 .INCLU-_SE       0   0   Company Code Data  
67 BUKRS_SE BUKRS BUKRS CHAR 4   0   Company Code *
68 BUTXT_SE BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
69 ORT01_SE ORT01 TEXT25 CHAR 25   0   City  
70 LAND1_SE LAND1 LAND1 CHAR 3   0   Country Key *
71 WAERS_SE WAERS WAERS CUKY 5   0   Currency Key *
72 SPRAS_SE SPRAS SPRAS LANG 1   0   Language Key *
73 KTOPL_SE KTOPL KTOPL CHAR 4   0   Chart of Accounts *
74 WAABW_SE WAABW_001 NUM02 NUMC 2   0   Maximum exchange rate deviation in percent  
75 PERIV_SE PERIV PERIV CHAR 2   0   Fiscal Year Variant *
76 KOKFI_SE KOKFI KOKFI CHAR 1   0   Allocation Indicator  
77 RCOMP_SE RCOMP_D RCOMP CHAR 6   0   Company *
78 ADRNR_SE ADRNR ADRNR CHAR 10   0   Address *
79 STCEG_SE STCEG STCEG CHAR 20   0   VAT Registration Number  
80 FIKRS_SE FIKRS FIKRS CHAR 4   0   Financial Management Area *
81 TXJCD_SE TXJCD_NSTX TXJCD CHAR 15   0   Jurisdiction for tax calculation - tax jurisdiction code *
82 .INCLUDE       0   0   Recipient  
83 .INCLU-_RC       0   0   Business Partner: General Data  
84 PARTNER_RC BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
85 PARTN_CAT_RC BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
86 SEARCHTERM1_RC BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
87 SEARCHTERM2_RC BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
88 FIRSTNAME_RC BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
89 LASTNAME_RC BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
90 NAME1_RC BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
91 NAME2_RC BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
92 NAME3_RC BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
93 NAME4_RC BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
94 NAMEGROUP1_RC BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
95 NAMEGROUP2_RC BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
96 XNAME_RC REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
97 XPARTNER_RC REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
98 XSALUTATION_RC REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
99 XADDRESS_RC REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
100 LINE0_RC LINES LINES CHAR 80   0   Address line  
101 LINE1_RC LINES LINES CHAR 80   0   Address line  
102 LINE2_RC LINES LINES CHAR 80   0   Address line  
103 LINE3_RC LINES LINES CHAR 80   0   Address line  
104 LINE4_RC LINES LINES CHAR 80   0   Address line  
105 LINE5_RC LINES LINES CHAR 80   0   Address line  
106 LINE6_RC LINES LINES CHAR 80   0   Address line  
107 LINE7_RC LINES LINES CHAR 80   0   Address line  
108 LINE8_RC LINES LINES CHAR 80   0   Address line  
109 LINE9_RC LINES LINES CHAR 80   0   Address line  
110 ADDRCATE_RC AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
111 ADDRNUMBER_RC AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
112 PERSNUMBER_RC AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
113 SMTP_ADDR_RC AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
114 TEL_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
115 TEL_NUMBER_RC AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
116 TEL_EXTENS_RC AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
117 TEL_NUMBER_LONG_RC AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
118 FAX_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
119 FAX_NUMBER_RC AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
120 FAX_EXTENS_RC AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
121 FAX_NUMBER_LONG_RC AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
122 INTRENO_RC RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
123 ROLE_RC REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
124 XROLE_RC REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
125 SUBROLE_RC REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
126 XSUBROLE_RC REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
127 ROLECATE_RC REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
128 APPL_RC REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
129 VALIDFROM_RC REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
130 VALIDTO_RC REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
131 ADDRTYPE_RC REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
132 .INCLUDE       0   0   Clerk  
133 .INCLU-_CL       0   0   Business Partner: General Data  
134 PARTNER_CL BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
135 PARTN_CAT_CL BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
136 SEARCHTERM1_CL BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
137 SEARCHTERM2_CL BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
138 FIRSTNAME_CL BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
139 LASTNAME_CL BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
140 NAME1_CL BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
141 NAME2_CL BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
142 NAME3_CL BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
143 NAME4_CL BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
144 NAMEGROUP1_CL BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
145 NAMEGROUP2_CL BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
146 XNAME_CL REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
147 XPARTNER_CL REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
148 XSALUTATION_CL REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
149 XADDRESS_CL REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
150 LINE0_CL LINES LINES CHAR 80   0   Address line  
151 LINE1_CL LINES LINES CHAR 80   0   Address line  
152 LINE2_CL LINES LINES CHAR 80   0   Address line  
153 LINE3_CL LINES LINES CHAR 80   0   Address line  
154 LINE4_CL LINES LINES CHAR 80   0   Address line  
155 LINE5_CL LINES LINES CHAR 80   0   Address line  
156 LINE6_CL LINES LINES CHAR 80   0   Address line  
157 LINE7_CL LINES LINES CHAR 80   0   Address line  
158 LINE8_CL LINES LINES CHAR 80   0   Address line  
159 LINE9_CL LINES LINES CHAR 80   0   Address line  
160 ADDRCATE_CL AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
161 ADDRNUMBER_CL AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
162 PERSNUMBER_CL AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
163 SMTP_ADDR_CL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
164 TEL_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
165 TEL_NUMBER_CL AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
166 TEL_EXTENS_CL AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
167 TEL_NUMBER_LONG_CL AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
168 FAX_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
169 FAX_NUMBER_CL AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
170 FAX_EXTENS_CL AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
171 FAX_NUMBER_LONG_CL AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
172 INTRENO_CL RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
173 ROLE_CL REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
174 XROLE_CL REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
175 SUBROLE_CL REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
176 XSUBROLE_CL REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
177 ROLECATE_CL REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
178 APPL_CL REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
179 VALIDFROM_CL REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
180 VALIDTO_CL REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
181 ADDRTYPE_CL REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
182 .INCLUDE       0   0   Further Partner 1  
183 .INCLU-_P1       0   0   Business Partner: General Data  
184 PARTNER_P1 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
185 PARTN_CAT_P1 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
186 SEARCHTERM1_P1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
187 SEARCHTERM2_P1 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
188 FIRSTNAME_P1 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
189 LASTNAME_P1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
190 NAME1_P1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
191 NAME2_P1 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
192 NAME3_P1 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
193 NAME4_P1 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
194 NAMEGROUP1_P1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
195 NAMEGROUP2_P1 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
196 XNAME_P1 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
197 XPARTNER_P1 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
198 XSALUTATION_P1 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
199 XADDRESS_P1 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
200 LINE0_P1 LINES LINES CHAR 80   0   Address line  
201 LINE1_P1 LINES LINES CHAR 80   0   Address line  
202 LINE2_P1 LINES LINES CHAR 80   0   Address line  
203 LINE3_P1 LINES LINES CHAR 80   0   Address line  
204 LINE4_P1 LINES LINES CHAR 80   0   Address line  
205 LINE5_P1 LINES LINES CHAR 80   0   Address line  
206 LINE6_P1 LINES LINES CHAR 80   0   Address line  
207 LINE7_P1 LINES LINES CHAR 80   0   Address line  
208 LINE8_P1 LINES LINES CHAR 80   0   Address line  
209 LINE9_P1 LINES LINES CHAR 80   0   Address line  
210 ADDRCATE_P1 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
211 ADDRNUMBER_P1 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
212 PERSNUMBER_P1 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
213 SMTP_ADDR_P1 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
214 TEL_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
215 TEL_NUMBER_P1 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
216 TEL_EXTENS_P1 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
217 TEL_NUMBER_LONG_P1 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
218 FAX_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
219 FAX_NUMBER_P1 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
220 FAX_EXTENS_P1 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
221 FAX_NUMBER_LONG_P1 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
222 INTRENO_P1 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
223 ROLE_P1 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
224 XROLE_P1 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
225 SUBROLE_P1 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
226 XSUBROLE_P1 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
227 ROLECATE_P1 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
228 APPL_P1 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
229 VALIDFROM_P1 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
230 VALIDTO_P1 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
231 ADDRTYPE_P1 REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
232 .INCLUDE       0   0   Further Partner 2  
233 .INCLU-_P2       0   0   Business Partner: General Data  
234 PARTNER_P2 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
235 PARTN_CAT_P2 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
236 SEARCHTERM1_P2 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
237 SEARCHTERM2_P2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
238 FIRSTNAME_P2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
239 LASTNAME_P2 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
240 NAME1_P2 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
241 NAME2_P2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
242 NAME3_P2 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
243 NAME4_P2 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
244 NAMEGROUP1_P2 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
245 NAMEGROUP2_P2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
246 XNAME_P2 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
247 XPARTNER_P2 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
248 XSALUTATION_P2 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
249 XADDRESS_P2 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
250 LINE0_P2 LINES LINES CHAR 80   0   Address line  
251 LINE1_P2 LINES LINES CHAR 80   0   Address line  
252 LINE2_P2 LINES LINES CHAR 80   0   Address line  
253 LINE3_P2 LINES LINES CHAR 80   0   Address line  
254 LINE4_P2 LINES LINES CHAR 80   0   Address line  
255 LINE5_P2 LINES LINES CHAR 80   0   Address line  
256 LINE6_P2 LINES LINES CHAR 80   0   Address line  
257 LINE7_P2 LINES LINES CHAR 80   0   Address line  
258 LINE8_P2 LINES LINES CHAR 80   0   Address line  
259 LINE9_P2 LINES LINES CHAR 80   0   Address line  
260 ADDRCATE_P2 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
261 ADDRNUMBER_P2 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
262 PERSNUMBER_P2 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
263 SMTP_ADDR_P2 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
264 TEL_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
265 TEL_NUMBER_P2 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
266 TEL_EXTENS_P2 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
267 TEL_NUMBER_LONG_P2 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
268 FAX_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
269 FAX_NUMBER_P2 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
270 FAX_EXTENS_P2 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
271 FAX_NUMBER_LONG_P2 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
272 INTRENO_P2 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
273 ROLE_P2 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
274 XROLE_P2 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
275 SUBROLE_P2 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
276 XSUBROLE_P2 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
277 ROLECATE_P2 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
278 APPL_P2 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
279 VALIDFROM_P2 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
280 VALIDTO_P2 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
281 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_OF DPTARGETTYPE TIVCNDPTYPE DPTYPE    
2 RECP_OI_DOC_OF RECNBUKRSCOLLECT T001 BUKRS    
3 RECP_OI_DOC_OF RECNCNCURR TCURC WAERS    
4 RECP_OI_DOC_OF RECNTLAW TIV03 SMIETR    
5 RECP_OI_DOC_OF RESPONSIBLE USR02 BNAME REF 1 CN
6 RECP_OI_DOC_OF SUBROLE_CL TIVBPSUBROLE SUBROLE REF C CN
7 RECP_OI_DOC_OF SUBROLE_P1 TIVBPSUBROLE SUBROLE REF C CN
8 RECP_OI_DOC_OF SUBROLE_P2 TIVBPSUBROLE SUBROLE REF C CN
9 RECP_OI_DOC_OF SUBROLE_RC TIVBPSUBROLE SUBROLE REF C CN
10 RECP_OI_DOC_OF USEREXCLUSIVE USR02 BNAME REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 600