SAP ABAP Table RECP_OI_DOC_PR (Document Data: Property)
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_PR   Table Relationship Diagram
Short Description Document Data: Property    
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   Property and Additional Fields (VIBDPR)  
2 .INCLUDE       0   0   Land (VIBDPR)  
3 .INCLUDE       0   0   Land  
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   Property: Key Fields  
7 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
8 SWENR REBDBENO REBDBENO CHAR 8   0   Business Entity Number *
9 SGRNR REBDPRNO REBDPRNO CHAR 8   0   Number of Land  
10 .INCLUDE       0   0   Property: Non-Key Fields  
11 OBJNR RECAOBJNR J_OBJNR CHAR 22   0   Object Number *
12 IMKEY RECAIMKEY IMKEY CHAR 8   0   Internal Key of Real Estate Object (FI)  
13 CREATIONTYPE RECACREATIONTYPE RECACREATIONTYPE CHAR 1   0   How the Object Was Created  
14 .INCLUDE       0   0   Field String for Maintenance of User Data  
15 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
16 DERF DERF DATUM DATS 8   0   First Entered on  
17 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
18 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
19 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
20 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
21 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
22 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
23 RESPONSIBLE RECARESPONSIBLE XUBNAME CHAR 12   0   Person Responsible USR02
24 USEREXCLUSIVE RECAUSEREXCLUSIVE XUBNAME CHAR 12   0   User with Exclusive Change Authorization USR02
25 AUTHGRP RECAAUTHGRP RECAAUTHGRP CHAR 40   0   Authorization Group  
26 VALIDFROM REBDOBJVALIDFROM RECADATEBEG DATS 8   0   Date: Object Valid From  
27 VALIDTO REBDOBJVALIDTO RECADATEEND DATS 8   0   Date: Object Valid To  
28 XGRTXT REBDXPR RECAXLDESCRIPTION CHAR 60   0   Name of Land  
29 RGRNART RGRNART CHAR2 CHAR 2   0   Usage Type of Property According to Land Use Map TIVC4
30 BDMQMB1 BDMQMB1 WRTV7 CURR 13   2   Market value  
31 BDMQMB2 BDMQMB2 WRTV7 CURR 13   2   Purchase price  
32 BDNRWERT BDNRWERT WRTV7 CURR 13   2   Land reference value for determining current market value  
33 BDNWERT BDNWERT WRTV7 CURR 13   2   Land value for determining current market value  
34 DBDNWERT DBDNWERT DDAT DATS 8   0   Date of land value  
35 RBEPLAN RBEPLAN XMBEZ CHAR 30   0   Development plan  
36 DBEPLAN DBEPLAN DDAT DATS 8   0   Date of development plan  
37 XNUTZGRU XNUTZGRU XMBEZ CHAR 30   0   Current usage of property  
38 NZGRZ NZGRZ DEC1_2 DEC 3   2   Permitted Usage: Site Occupancy Index  
39 NZGFZ NZGFZ DEC2_2 DEC 4   2   Permitted Usage: Floor Area Ratio  
40 NZBMZ NZBMZ DEC3_2 DEC 5   2   Permitted Usage: Construction Dimension Number  
41 NTGRZ NTGRZ DEC1_2 DEC 3   2   Actual Usage: Site Occupancy Index  
42 NTGFZ NTGFZ DEC2_2 DEC 4   2   Actual Usage: Floor Area Ratio  
43 NTBMZ NTBMZ DEC3_2 DEC 5   2   Actual Usage: Construction Dimension Number  
44 RNBPLAN RNBPLAN RGRNART CHAR 4   0   Usage type according to development plan TIVB3
45 SGRART VVSGRART VVSGRART NUMC 4   0   Property type TIV56
46 SGRQAL VVSGRQAL VVSGRQAL NUMC 3   0   Property: Quality of location TIV57
47 SGRFRM VVSGRFRM VVSGRFRM NUMC 3   0   Property ground type TIV58
48 SGRGZS VVSGRGZS VVSGRGZS NUMC 3   0   Overall condition of property TIV59
49 DWIRTUB VVDWIRTUB DATUM DATS 8   0   Transfer usage / charges  
50 DVERKAUF VVDVERKAUF DATUM DATS 8   0   Sale date  
51 SUNUTZA VVSUNART VVSUNART CHAR 8   0   Main usage type TIV36
52 JUNUTZA REBDJUNUTZAOBS CHAR1 CHAR 1   0   OBSOLETE: Main Usage Type  
53 DVRKPLAN VVDVRKPLAN DATUM DATS 8   0   Planned sale  
54 XGEMARK VVGEMARK VVGEMARK CHAR 12   0   Local Subdistrict TIVG2
55 NFLURNR NFLURNR NFLURNR CHAR 6   0   Number of Tract of Land in Land Register  
56 XFLURST XFLURST TEXT10 CHAR 10   0   Parcel of Land  
57 BRFLURST VVBRFLURST VVBRFLURST CHAR 4   0   Fractional Parcel of Land  
58 JERBBAU JERBBAU SOBJERBBAU CHAR 1   0   Heritable building right indicator TDO9
59 GEMEINDE VVGEMEINDE VVGEMEINDE CHAR 8   0   Municipality key TIVG1
60 ZULBAUH VVZULBAUH VVZULBAUH QUAN 4   0   Permitted building height  
61 LEINS VVLEINS MEINS UNIT 3   0   Unit of length T006
62 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
63 USGFUNCTION REBDUSGFUNCTION REBDUSGFUNCTION CHAR 4   0   Function of Object TIVBDUSGFUNC
64 .INCLUDE       0   0    
65 .INCLU--AP       0   0   Country specific fields (CI) for Switzerland - PR  
66 .INCLUDE       0   0   Rental Object Customer fields  
67 PLANNO RELMRPRGNO RELMRPRGNO NUMC 6   0   Real Properties Register Number  
68 LOCATIONCH REXCCHPRLOCATION RECAXLDESCRIPTION CHAR 60   0   Location Description of Land Acc. To Tax Auth.  
69 ESTATEDESCR REXCCHPRDESCRIPTION RECAXLDESCRIPTION CHAR 60   0   Location Description of Land Acc. To Land Register  
70 GEMEINDECH RELMLRDISTRICT RELMLRDISTRICT CHAR 6   0   Land Register District *
71 .INCLU--AP       0   0   Country specific fields for India - PR  
72 SECCO SECCO SECCO CHAR 4   0   Section Code *
73 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
74 .INCLU--AP       0   0   Country-Specific Fields for Portugal - Property  
75 .INCLUDE       0   0   Country-Specific Fields for Portugal - Property  
76 VPT REXCPTVPT_NOSIGN REXCPTVPT_NOSIGN CURR 15   2   Property Taxable Value  
77 CURRENCY WAERS WAERS CUKY 5   0   Currency Key TCURC
78 BUTXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
79 XWETEXT REBDXBE RECAXLDESCRIPTION CHAR 60   0   Business Entity Name  
80 XUNART VVXUNART XTEXT35 CHAR 35   0   Main usage type  
81 KTEXT KTEXT TEXT20 CHAR 20   0   General Name  
82 XGEMEINDE VVXGEMEINDE VVXGEMEINDE CHAR 50   0   Name of municipality  
83 XKREIS VVXKREIS VVXKREIS CHAR 30   0   Name of district  
84 XREGIO VVXREGIO VVXREGIO CHAR 30   0   Name of federal state  
85 LGEMARK VVLGEMARK VVLGEMARK CHAR 25   0   Explanation of sub-district  
86 XADDRESS REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
87 GSBER GSBER GSBER CHAR 4   0   Business Area *
88 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
89 REALVALIDFROM REBDREALVALIDFROM RECADATEBEG DATS 8   0   Date: Valid from (Effective)  
90 REALVALIDTO REBDREALVALIDTO RECADATEEND DATS 8   0   Date: Valid to (Effective)  
91 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
92 XAUTHGRP RECAXAUTHGRP RECAXLDESCRIPTION CHAR 60   0   Description of Authorization Group  
93 XMUSGFUNCTION REBDXMUSGFUNCTION RECAXMDESCRIPTION CHAR 30   0   Name of Function of Object (Medium)  
94 XJERBBAUK XTEXT15 TEXT15 CHAR 15   0   Name  
95 XJERBBAUL XTEXT30 TEXT30 CHAR 30   0   Name  
96 .INCLUDE       0   0   Object Address  
97 .INCLU-_OB       0   0   Address  
98 XADDRESS_OB REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
99 CITY1_OB AD_CITY1 TEXT40 CHAR 40   0   City  
100 CITY2_OB AD_CITY2 TEXT40 CHAR 40   0   District  
101 POST_CODE1_OB AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
102 STREET_OB AD_STREET TEXT60 CHAR 60   0   Street  
103 HOUSE_NUM1_OB AD_HSNM1 TEXT10 CHAR 10   0   House Number  
104 COUNTRY_OB LAND1 LAND1 CHAR 3   0   Country Key *
105 REGION_OB REGIO REGIO CHAR 3   0   Region (State, Province, County) *
106 ADRZUS_OB REBDXOBJECT TEXT35 CHAR 35   0   Object Description  
107 ADRNR_OB AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
108 ADRNR_ORI_OB REBDJADRORIG REBDJDATORIG CHAR 1   0   Address Origin ID  
109 OBJNR_HI_OB REBDSOBJNRHI CHAR13 CHAR 13   0   Number of the Superordinate Address Object  
110 .INCLUDE       0   0   General Output Parameters  
111 TEMPLATE RECPOITEMPLATE TEXT64 CHAR 64   0   Template for Printing with Office Application  
112 LANGU RECPOILANGU SPRAS LANG 1   0   Language for Document Creation *
113 SELDATE RECPOISELDATE RECADATE DATS 8   0   Key Date for Data Selection  
114 PRNDATE RECPOIPRNDATE RECADATE DATS 8   0   Print Date  
115 .INCLUDE       0   0   General Data for the Business Object  
116 IDENTKEY RECAIDENTKEY CHAR45 CHAR 45   0   ID Part Key, for example "1000/123"  
117 IDENT RECAIDENT CHAR50 CHAR 50   0   Complete Object Identification, for Example BE 1000/123  
118 XIDENT RECAXIDENT TEXT80 CHAR 80   0   Object ID, for Example, Business Entity 1000/123  
119 XOBJTYPE RECAXOBJTYPE CHAR3 CHAR 3   0   Partial Object Type ID, for example "BE"  
120 XLOBJTYPE RECAXLOBJTYPE TEXT20 CHAR 20   0   Object Type Name (20)  
121 BUSTYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
122 BUSKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
123 .INCLUDE       0   0   Sender (Company Code Data)  
124 .INCLU-_SE       0   0   Company Code Data  
125 BUKRS_SE BUKRS BUKRS CHAR 4   0   Company Code *
126 BUTXT_SE BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
127 ORT01_SE ORT01 TEXT25 CHAR 25   0   City  
128 LAND1_SE LAND1 LAND1 CHAR 3   0   Country Key *
129 WAERS_SE WAERS WAERS CUKY 5   0   Currency Key *
130 SPRAS_SE SPRAS SPRAS LANG 1   0   Language Key *
131 KTOPL_SE KTOPL KTOPL CHAR 4   0   Chart of Accounts *
132 WAABW_SE WAABW_001 NUM02 NUMC 2   0   Maximum exchange rate deviation in percent  
133 PERIV_SE PERIV PERIV CHAR 2   0   Fiscal Year Variant *
134 KOKFI_SE KOKFI KOKFI CHAR 1   0   Allocation Indicator  
135 RCOMP_SE RCOMP_D RCOMP CHAR 6   0   Company *
136 ADRNR_SE ADRNR ADRNR CHAR 10   0   Address *
137 STCEG_SE STCEG STCEG CHAR 20   0   VAT Registration Number  
138 FIKRS_SE FIKRS FIKRS CHAR 4   0   Financial Management Area *
139 TXJCD_SE TXJCD_NSTX TXJCD CHAR 15   0   Jurisdiction for tax calculation - tax jurisdiction code *
140 .INCLUDE       0   0   Recipient  
141 .INCLU-_RC       0   0   Business Partner: General Data  
142 PARTNER_RC BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
143 PARTN_CAT_RC BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
144 SEARCHTERM1_RC BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
145 SEARCHTERM2_RC BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
146 FIRSTNAME_RC BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
147 LASTNAME_RC BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
148 NAME1_RC BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
149 NAME2_RC BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
150 NAME3_RC BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
151 NAME4_RC BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
152 NAMEGROUP1_RC BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
153 NAMEGROUP2_RC BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
154 XNAME_RC REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
155 XPARTNER_RC REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
156 XSALUTATION_RC REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
157 XADDRESS_RC REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
158 LINE0_RC LINES LINES CHAR 80   0   Address line  
159 LINE1_RC LINES LINES CHAR 80   0   Address line  
160 LINE2_RC LINES LINES CHAR 80   0   Address line  
161 LINE3_RC LINES LINES CHAR 80   0   Address line  
162 LINE4_RC LINES LINES CHAR 80   0   Address line  
163 LINE5_RC LINES LINES CHAR 80   0   Address line  
164 LINE6_RC LINES LINES CHAR 80   0   Address line  
165 LINE7_RC LINES LINES CHAR 80   0   Address line  
166 LINE8_RC LINES LINES CHAR 80   0   Address line  
167 LINE9_RC LINES LINES CHAR 80   0   Address line  
168 ADDRCATE_RC AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
169 ADDRNUMBER_RC AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
170 PERSNUMBER_RC AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
171 SMTP_ADDR_RC AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
172 TEL_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
173 TEL_NUMBER_RC AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
174 TEL_EXTENS_RC AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
175 TEL_NUMBER_LONG_RC AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
176 FAX_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
177 FAX_NUMBER_RC AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
178 FAX_EXTENS_RC AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
179 FAX_NUMBER_LONG_RC AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
180 INTRENO_RC RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
181 ROLE_RC REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
182 XROLE_RC REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
183 SUBROLE_RC REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
184 XSUBROLE_RC REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
185 ROLECATE_RC REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
186 APPL_RC REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
187 VALIDFROM_RC REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
188 VALIDTO_RC REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
189 ADDRTYPE_RC REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
190 .INCLUDE       0   0   Clerk  
191 .INCLU-_CL       0   0   Business Partner: General Data  
192 PARTNER_CL BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
193 PARTN_CAT_CL BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
194 SEARCHTERM1_CL BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
195 SEARCHTERM2_CL BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
196 FIRSTNAME_CL BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
197 LASTNAME_CL BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
198 NAME1_CL BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
199 NAME2_CL BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
200 NAME3_CL BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
201 NAME4_CL BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
202 NAMEGROUP1_CL BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
203 NAMEGROUP2_CL BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
204 XNAME_CL REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
205 XPARTNER_CL REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
206 XSALUTATION_CL REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
207 XADDRESS_CL REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
208 LINE0_CL LINES LINES CHAR 80   0   Address line  
209 LINE1_CL LINES LINES CHAR 80   0   Address line  
210 LINE2_CL LINES LINES CHAR 80   0   Address line  
211 LINE3_CL LINES LINES CHAR 80   0   Address line  
212 LINE4_CL LINES LINES CHAR 80   0   Address line  
213 LINE5_CL LINES LINES CHAR 80   0   Address line  
214 LINE6_CL LINES LINES CHAR 80   0   Address line  
215 LINE7_CL LINES LINES CHAR 80   0   Address line  
216 LINE8_CL LINES LINES CHAR 80   0   Address line  
217 LINE9_CL LINES LINES CHAR 80   0   Address line  
218 ADDRCATE_CL AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
219 ADDRNUMBER_CL AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
220 PERSNUMBER_CL AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
221 SMTP_ADDR_CL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
222 TEL_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
223 TEL_NUMBER_CL AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
224 TEL_EXTENS_CL AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
225 TEL_NUMBER_LONG_CL AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
226 FAX_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
227 FAX_NUMBER_CL AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
228 FAX_EXTENS_CL AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
229 FAX_NUMBER_LONG_CL AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
230 INTRENO_CL RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
231 ROLE_CL REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
232 XROLE_CL REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
233 SUBROLE_CL REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
234 XSUBROLE_CL REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
235 ROLECATE_CL REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
236 APPL_CL REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
237 VALIDFROM_CL REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
238 VALIDTO_CL REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
239 ADDRTYPE_CL REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
240 .INCLUDE       0   0   Further Partner 1  
241 .INCLU-_P1       0   0   Business Partner: General Data  
242 PARTNER_P1 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
243 PARTN_CAT_P1 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
244 SEARCHTERM1_P1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
245 SEARCHTERM2_P1 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
246 FIRSTNAME_P1 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
247 LASTNAME_P1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
248 NAME1_P1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
249 NAME2_P1 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
250 NAME3_P1 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
251 NAME4_P1 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
252 NAMEGROUP1_P1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
253 NAMEGROUP2_P1 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
254 XNAME_P1 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
255 XPARTNER_P1 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
256 XSALUTATION_P1 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
257 XADDRESS_P1 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
258 LINE0_P1 LINES LINES CHAR 80   0   Address line  
259 LINE1_P1 LINES LINES CHAR 80   0   Address line  
260 LINE2_P1 LINES LINES CHAR 80   0   Address line  
261 LINE3_P1 LINES LINES CHAR 80   0   Address line  
262 LINE4_P1 LINES LINES CHAR 80   0   Address line  
263 LINE5_P1 LINES LINES CHAR 80   0   Address line  
264 LINE6_P1 LINES LINES CHAR 80   0   Address line  
265 LINE7_P1 LINES LINES CHAR 80   0   Address line  
266 LINE8_P1 LINES LINES CHAR 80   0   Address line  
267 LINE9_P1 LINES LINES CHAR 80   0   Address line  
268 ADDRCATE_P1 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
269 ADDRNUMBER_P1 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
270 PERSNUMBER_P1 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
271 SMTP_ADDR_P1 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
272 TEL_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
273 TEL_NUMBER_P1 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
274 TEL_EXTENS_P1 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
275 TEL_NUMBER_LONG_P1 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
276 FAX_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
277 FAX_NUMBER_P1 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
278 FAX_EXTENS_P1 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
279 FAX_NUMBER_LONG_P1 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
280 INTRENO_P1 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
281 ROLE_P1 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
282 XROLE_P1 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
283 SUBROLE_P1 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
284 XSUBROLE_P1 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
285 ROLECATE_P1 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
286 APPL_P1 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
287 VALIDFROM_P1 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
288 VALIDTO_P1 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
289 ADDRTYPE_P1 REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
290 .INCLUDE       0   0   Further Partner 2  
291 .INCLU-_P2       0   0   Business Partner: General Data  
292 PARTNER_P2 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
293 PARTN_CAT_P2 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
294 SEARCHTERM1_P2 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
295 SEARCHTERM2_P2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
296 FIRSTNAME_P2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
297 LASTNAME_P2 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
298 NAME1_P2 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
299 NAME2_P2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
300 NAME3_P2 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
301 NAME4_P2 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
302 NAMEGROUP1_P2 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
303 NAMEGROUP2_P2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
304 XNAME_P2 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
305 XPARTNER_P2 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
306 XSALUTATION_P2 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
307 XADDRESS_P2 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
308 LINE0_P2 LINES LINES CHAR 80   0   Address line  
309 LINE1_P2 LINES LINES CHAR 80   0   Address line  
310 LINE2_P2 LINES LINES CHAR 80   0   Address line  
311 LINE3_P2 LINES LINES CHAR 80   0   Address line  
312 LINE4_P2 LINES LINES CHAR 80   0   Address line  
313 LINE5_P2 LINES LINES CHAR 80   0   Address line  
314 LINE6_P2 LINES LINES CHAR 80   0   Address line  
315 LINE7_P2 LINES LINES CHAR 80   0   Address line  
316 LINE8_P2 LINES LINES CHAR 80   0   Address line  
317 LINE9_P2 LINES LINES CHAR 80   0   Address line  
318 ADDRCATE_P2 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
319 ADDRNUMBER_P2 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
320 PERSNUMBER_P2 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
321 SMTP_ADDR_P2 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
322 TEL_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
323 TEL_NUMBER_P2 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
324 TEL_EXTENS_P2 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
325 TEL_NUMBER_LONG_P2 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
326 FAX_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
327 FAX_NUMBER_P2 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
328 FAX_EXTENS_P2 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
329 FAX_NUMBER_LONG_P2 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
330 INTRENO_P2 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
331 ROLE_P2 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
332 XROLE_P2 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
333 SUBROLE_P2 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
334 XSUBROLE_P2 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
335 ROLECATE_P2 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
336 APPL_P2 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
337 VALIDFROM_P2 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
338 VALIDTO_P2 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
339 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_PR BUKRS T001 BUKRS KEY 1 CN
2 RECP_OI_DOC_PR CURRENCY TCURC WAERS    
3 RECP_OI_DOC_PR GEMEINDE TIVG1 GEMEINDE KEY 1 CN
4 RECP_OI_DOC_PR JERBBAU TDO9 SOBJERBBAU    
5 RECP_OI_DOC_PR LEINS T006 MSEHI REF C CN
6 RECP_OI_DOC_PR RESPONSIBLE USR02 BNAME REF 1 CN
7 RECP_OI_DOC_PR RGRNART TIVC4 RGRNART KEY 1 CN
8 RECP_OI_DOC_PR RNBPLAN TIVB3 RNBPLAN 1 CN
9 RECP_OI_DOC_PR SGRART TIV56 SGRART    
10 RECP_OI_DOC_PR SGRFRM TIV58 SGRFRM    
11 RECP_OI_DOC_PR SGRGZS TIV59 SGRGZS    
12 RECP_OI_DOC_PR SGRQAL TIV57 SGRQAL    
13 RECP_OI_DOC_PR SUBROLE_CL TIVBPSUBROLE SUBROLE REF C CN
14 RECP_OI_DOC_PR SUBROLE_P1 TIVBPSUBROLE SUBROLE REF C CN
15 RECP_OI_DOC_PR SUBROLE_P2 TIVBPSUBROLE SUBROLE REF C CN
16 RECP_OI_DOC_PR SUBROLE_RC TIVBPSUBROLE SUBROLE REF C CN
17 RECP_OI_DOC_PR SUNUTZA TIV36 SUNART    
18 RECP_OI_DOC_PR TXJCD TTXJ TXJCD REF C CN
19 RECP_OI_DOC_PR USEREXCLUSIVE USR02 BNAME REF C CN
20 RECP_OI_DOC_PR USGFUNCTION TIVBDUSGFUNC USGFUNCTION    
21 RECP_OI_DOC_PR WAERS TCURC WAERS REF C CN
22 RECP_OI_DOC_PR XGEMARK TIVG2 GEMARK    
History
Last changed by/on SAP  20140121 
SAP Release Created in 110