SAP ABAP Table RECP_OI_DOC_AO (Document Data: Arch. 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_AO   Table Relationship Diagram
Short Description Document Data: Arch. 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   Architectural Object and Additional Fields (VIBDAO)  
2 .INCLUDE       0   0   Architectural Object (VIBDAO)  
3 .INCLUDE       0   0   Architectural Object  
4 MANDT MANDT MANDT CLNT 3   0   Client *
5 INTRENO REBDINTRENOAO RECAINTRENO CHAR 13   0   Internal Object Number for Architecture Objects (INTRENO)  
6 .INCLUDE       0   0   Architectural Object: Key  
7 AOID REBDAOID REBDAOID CHAR 30   0   Identification of Architectural Object  
8 .INCLUDE       0   0   Architectural Object: Attributes  
9 .INCLUDE       0   0   Architectural Object: Header  
10 AOTYPE REBDAOTYPE REBDAOTYPE CHAR 4   0   Architectural Object Type *
11 AONR REBDAONR REBDAONR CHAR 13   0   Number of Architectural Object  
12 VALIDFROM REBDOBJVALIDFROM RECADATEBEG DATS 8   0   Date: Object Valid From  
13 VALIDTO REBDOBJVALIDTO RECADATEEND DATS 8   0   Date: Object Valid To  
14 PARTSEPARATOR REBDPARTSEPARATOR REBDPARTSEPARATOR CHAR 10   0   AOID Code: Separator  
15 PARTAOID REBDPARTAOID REBDPARTAOID CHAR 30   0   AOID Code  
16 XAO REBDXAO RECAXLDESCRIPTION CHAR 60   0   Name of Architectural Object  
17 AOFUNCTION REBDAOFUNCTION REBDAOFUNCTION CHAR 4   0   Function of Architectural Object TIVBDARFUNC
18 USAGECOMMON REBDUSCOMMON REBDUSCOMMON CHAR 1   0   Common Usage  
19 OBJNR RECAOBJNR J_OBJNR CHAR 22   0   Object Number *
20 AUTHGRP RECAAUTHGRP RECAAUTHGRP CHAR 40   0   Authorization Group  
21 .INCLUDE       0   0   Field String for Maintenance of User Data  
22 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
23 DERF DERF DATUM DATS 8   0   First Entered on  
24 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
25 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
26 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
27 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
28 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
29 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
30 RESPONSIBLE RECARESPONSIBLE XUBNAME CHAR 12   0   Person Responsible USR02
31 USEREXCLUSIVE RECAUSEREXCLUSIVE XUBNAME CHAR 12   0   User with Exclusive Change Authorization USR02
32 .INCLUDE       0   0   Architectural Object: Detail Data  
33 .INCLUDE       0   0   Architectural Object: General Attributes  
34 LASTRENO DRENOV DATUM DATS 8   0   Date of last redecoration  
35 MEASSTRC REBDMEASSTRC REBDMEASSTRC CHAR 4   0   Measurement Structure TIVBDMEASSTRC
36 DOORPLT REBDDOORPLT REBDDOORPLT CHAR 15   0   Short description  
37 RSAREA REORRSAREA REORRSAREA CHAR 10   0   Reservation Area TIVORRSAREA
38 .INCLUDE       0   0   Architectural Object: Attributes of Business Entity  
39 SINSTBEZ SINSTBEZ SINSTBEZ NUMC 5   0   Maintenance district TIV16
40 SVERKEHR SVERKEHR SVERKEHR CHAR 1   0   Transport Connections of Business Entity TIV44
41 SLAGEWE SLAGEWE SLAGEWE NUMC 4   0   Business entity location number TIV10
42 SOBJLAGE RESOBJLAGE RESOBJLAGE NUMC 2   0   Indicator: District Location of Object TIV45
43 .INCLUDE       0   0   Architectural Object: Attributes of Property  
44 RGRNART RGRNART CHAR2 CHAR 2   0   Usage Type of Property According to Land Use Map TIVC4
45 RBEPLAN RBEPLAN XMBEZ CHAR 30   0   Development plan  
46 DBEPLAN DBEPLAN DDAT DATS 8   0   Date of development plan  
47 RNBPLAN RNBPLAN RGRNART CHAR 4   0   Usage type according to development plan TIVB3
48 XNUTZGRU XNUTZGRU XMBEZ CHAR 30   0   Current usage of property  
49 SUNUTZA VVSUNART VVSUNART CHAR 8   0   Main usage type TIV36
50 JUNUTZA VVJUNUTZA JANE CHAR 1   0   Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36  
51 NZGRZ NZGRZ DEC1_2 DEC 3   2   Permitted Usage: Site Occupancy Index  
52 NZGFZ NZGFZ DEC2_2 DEC 4   2   Permitted Usage: Floor Area Ratio  
53 NZBMZ NZBMZ DEC3_2 DEC 5   2   Permitted Usage: Construction Dimension Number  
54 NTGRZ NTGRZ DEC1_2 DEC 3   2   Actual Usage: Site Occupancy Index  
55 NTGFZ NTGFZ DEC2_2 DEC 4   2   Actual Usage: Floor Area Ratio  
56 NTBMZ NTBMZ DEC3_2 DEC 5   2   Actual Usage: Construction Dimension Number  
57 SGRART VVSGRART VVSGRART NUMC 4   0   Property type TIV56
58 SGRQAL VVSGRQAL VVSGRQAL NUMC 3   0   Property: Quality of location TIV57
59 SGRFRM VVSGRFRM VVSGRFRM NUMC 3   0   Property ground type TIV58
60 SGRGZS VVSGRGZS VVSGRGZS NUMC 3   0   Overall condition of property TIV59
61 JERBBAU JERBBAU SOBJERBBAU CHAR 1   0   Heritable building right indicator TDO9
62 ZULBAUH REBDALLOWEDHEIGHT REBDALLOWEDHEIGHT INT2 5   0   Allowed Building Height (as Integer)  
63 .INCLUDE       0   0   Architectural Object: Attributes of Building  
64 RGEBART RGEBART SOBJART NUMC 2   0   Type of building TIV5A
65 RGEBZUST RGEBZUST VVRZUSTAND NUMC 2   0   General condition of building TIV83
66 YBAUJAHR VVYBAUJAHR DATUM DATS 8   0   ConstYr  
67 JNURJAHR VVJNURJ JANE CHAR 1   0   Indicator: Only regard construction date in terms of years  
68 YMODERN VVYMODERN DATUM DATS 8   0   Year of modernization  
69 YAUFBAU VVYAUFBAU DATUM DATS 8   0   Year of reconstruction  
70 DBAUBEGI DBAUBEGI DDAT DATS 8   0   Construction start date  
71 DBAUVOR DBAUVOR DDAT DATS 8   0   Date of planning inquiry  
72 DVORBES DVORBES DDAT DATS 8   0   Date of prior notice  
73 DANTBAU DANTBAU DATUM DATS 8   0   Application for building permit  
74 DBAUGENE DBAUGENE DDAT DATS 8   0   Building permit  
75 XBAUGENE XBAUGENE XMBEZ CHAR 30   0   Note on building permit  
76 DFERTIG DFERTIG DDAT DATS 8   0   Completion  
77 DSCHLUSS DSCHLUSS DDAT DATS 8   0   Final Inspection  
78 DBEZUGSF DBEZUGSF DDAT DATS 8   0   Ready for occupancy  
79 RDAZUST RECADUMMYN2 NUMC2 NUMC 2   0   Dummy: No Longer Used  
80 RFAZUST RECADUMMYN2 NUMC2 NUMC 2   0   Dummy: No Longer Used  
81 JDENKMAL JDENKMAL JANE CHAR 1   0   Protection of Historical Sites  
82 DFRDVON VVDFRDVON DATUM DATS 8   0   Public funding from  
83 DFRDBIS VVDFRDBIS DATUM DATS 8   0   Public funding to  
84 BANZGE VVBANZGE DEC3_1 DEC 4   1   Number of floors  
85 AUGESCH AUGESCH DEC2 DEC 2   0   Number of basements  
86 SSTCKBIS VVSTCKBIS VVSSTOCKW NUMC 3   0   Uppermost Floor of a Building TIV37
87 SLIFTBIS VVLIFTBIS VVSSTOCKW NUMC 3   0   Elevator to Floor in Building TIV37
88 NSTCKLFT VVNSTCKLFT NUMC3 NUMC 3   0   Number of highest floor reached by elevator  
89 .INCLUDE       0   0    
90 ISROOT REBDISROOT RECABOOL CHAR 1   0   Top Level Object Type of Architectural Hierarchy  
91 XMAOTYPE REBDXMAOTYPE RECAXMDESCRIPTION CHAR 30   0   Name of Architectural Object Type  
92 XMAOFUNCTION REBDXMAOFUNCTION RECAXMDESCRIPTION CHAR 30   0   Name of Function of Arch. Object - Medium-Length  
93 XMMEASSTRC REBDXMMEASSTRC RECAXMDESCRIPTION CHAR 30   0   Name of Measurement Structure - Medium-Length  
94 XINSTBEZM XINSTBEZM XMBEZ CHAR 30   0   Description of maintenance district  
95 XVERKEHR XVERKEHR XTEXT50 CHAR 50   0   Transport connections  
96 XLAGEWEM XLAGEWEM XMBEZ CHAR 30   0   Description of location of business entity  
97 XOBJLAGE XOBJLAGE XTEXT50 CHAR 50   0   District Location  
98 XGRNART XGRNART XTEXT50 CHAR 50   0   Property usage type according to development plan  
99 RNBPLANMBZ RNBPLANMBZ XMBEZ CHAR 30   0   Description of usage type according to development plan  
100 XUNART VVXUNART XTEXT35 CHAR 35   0   Main usage type  
101 XGRART VVXGRART VVXTEXT20 CHAR 20   0   Property type  
102 XGRQAL VVXGRQAL VVXTEXT20 CHAR 20   0   Quality of property location  
103 XGRFRM VVXGRFRM VVXTEXT20 CHAR 20   0   Text: Ground type of property  
104 XGRGZS VVXGRGZS VVXTEXT20 CHAR 20   0   Text about property overall condition  
105 XLJERBBAU XTEXT30 TEXT30 CHAR 30   0   Name  
106 XOBJARTM XOBJARTM XMBEZ CHAR 30   0   Description of object type  
107 XGEBZUST XGEBZUS XTEXT50 CHAR 50   0   General condition of building  
108 XSTOCKO REBDXSTOCKO XKBEZ CHAR 15   0   Top Floor (Floor Name)  
109 XSTOCKL REBDXSTOCKL XKBEZ CHAR 15   0   Elevator to (Floor Name)  
110 REALVALIDFROM REBDREALVALIDFROM RECADATEBEG DATS 8   0   Date: Valid from (Effective)  
111 REALVALIDTO REBDREALVALIDTO RECADATEEND DATS 8   0   Date: Valid to (Effective)  
112 XUSAGECOMMON REBDXUSAGECOMMON RECAXLDESCRIPTION CHAR 60   0   Text for Common Usage  
113 XAUTHGRP RECAXAUTHGRP RECAXLDESCRIPTION CHAR 60   0   Description of Authorization Group  
114 XRSAREA REORXRSAREA RECAXMDESCRIPTION CHAR 30   0   Name of Reservation Area  
115 .INCLUDE       0   0   Object Address  
116 .INCLU-_OB       0   0   Address  
117 XADDRESS_OB REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
118 CITY1_OB AD_CITY1 TEXT40 CHAR 40   0   City  
119 CITY2_OB AD_CITY2 TEXT40 CHAR 40   0   District  
120 POST_CODE1_OB AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
121 STREET_OB AD_STREET TEXT60 CHAR 60   0   Street  
122 HOUSE_NUM1_OB AD_HSNM1 TEXT10 CHAR 10   0   House Number  
123 COUNTRY_OB LAND1 LAND1 CHAR 3   0   Country Key *
124 REGION_OB REGIO REGIO CHAR 3   0   Region (State, Province, County) *
125 ADRZUS_OB REBDXOBJECT TEXT35 CHAR 35   0   Object Description  
126 ADRNR_OB AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
127 ADRNR_ORI_OB REBDJADRORIG REBDJDATORIG CHAR 1   0   Address Origin ID  
128 OBJNR_HI_OB REBDSOBJNRHI CHAR13 CHAR 13   0   Number of the Superordinate Address Object  
129 .INCLUDE       0   0   General Output Parameters  
130 TEMPLATE RECPOITEMPLATE TEXT64 CHAR 64   0   Template for Printing with Office Application  
131 LANGU RECPOILANGU SPRAS LANG 1   0   Language for Document Creation *
132 SELDATE RECPOISELDATE RECADATE DATS 8   0   Key Date for Data Selection  
133 PRNDATE RECPOIPRNDATE RECADATE DATS 8   0   Print Date  
134 .INCLUDE       0   0   General Data for the Business Object  
135 IDENTKEY RECAIDENTKEY CHAR45 CHAR 45   0   ID Part Key, for example "1000/123"  
136 IDENT RECAIDENT CHAR50 CHAR 50   0   Complete Object Identification, for Example BE 1000/123  
137 XIDENT RECAXIDENT TEXT80 CHAR 80   0   Object ID, for Example, Business Entity 1000/123  
138 XOBJTYPE RECAXOBJTYPE CHAR3 CHAR 3   0   Partial Object Type ID, for example "BE"  
139 XLOBJTYPE RECAXLOBJTYPE TEXT20 CHAR 20   0   Object Type Name (20)  
140 BUSTYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
141 BUSKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
142 .INCLUDE       0   0   Sender (Company Code Data)  
143 .INCLU-_SE       0   0   Company Code Data  
144 BUKRS_SE BUKRS BUKRS CHAR 4   0   Company Code *
145 BUTXT_SE BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
146 ORT01_SE ORT01 TEXT25 CHAR 25   0   City  
147 LAND1_SE LAND1 LAND1 CHAR 3   0   Country Key *
148 WAERS_SE WAERS WAERS CUKY 5   0   Currency Key *
149 SPRAS_SE SPRAS SPRAS LANG 1   0   Language Key *
150 KTOPL_SE KTOPL KTOPL CHAR 4   0   Chart of Accounts *
151 WAABW_SE WAABW_001 NUM02 NUMC 2   0   Maximum exchange rate deviation in percent  
152 PERIV_SE PERIV PERIV CHAR 2   0   Fiscal Year Variant *
153 KOKFI_SE KOKFI KOKFI CHAR 1   0   Allocation Indicator  
154 RCOMP_SE RCOMP_D RCOMP CHAR 6   0   Company *
155 ADRNR_SE ADRNR ADRNR CHAR 10   0   Address *
156 STCEG_SE STCEG STCEG CHAR 20   0   VAT Registration Number  
157 FIKRS_SE FIKRS FIKRS CHAR 4   0   Financial Management Area *
158 TXJCD_SE TXJCD_NSTX TXJCD CHAR 15   0   Jurisdiction for tax calculation - tax jurisdiction code *
159 .INCLUDE       0   0   Recipient  
160 .INCLU-_RC       0   0   Business Partner: General Data  
161 PARTNER_RC BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
162 PARTN_CAT_RC BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
163 SEARCHTERM1_RC BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
164 SEARCHTERM2_RC BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
165 FIRSTNAME_RC BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
166 LASTNAME_RC BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
167 NAME1_RC BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
168 NAME2_RC BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
169 NAME3_RC BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
170 NAME4_RC BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
171 NAMEGROUP1_RC BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
172 NAMEGROUP2_RC BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
173 XNAME_RC REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
174 XPARTNER_RC REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
175 XSALUTATION_RC REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
176 XADDRESS_RC REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
177 LINE0_RC LINES LINES CHAR 80   0   Address line  
178 LINE1_RC LINES LINES CHAR 80   0   Address line  
179 LINE2_RC LINES LINES CHAR 80   0   Address line  
180 LINE3_RC LINES LINES CHAR 80   0   Address line  
181 LINE4_RC LINES LINES CHAR 80   0   Address line  
182 LINE5_RC LINES LINES CHAR 80   0   Address line  
183 LINE6_RC LINES LINES CHAR 80   0   Address line  
184 LINE7_RC LINES LINES CHAR 80   0   Address line  
185 LINE8_RC LINES LINES CHAR 80   0   Address line  
186 LINE9_RC LINES LINES CHAR 80   0   Address line  
187 ADDRCATE_RC AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
188 ADDRNUMBER_RC AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
189 PERSNUMBER_RC AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
190 SMTP_ADDR_RC AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
191 TEL_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
192 TEL_NUMBER_RC AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
193 TEL_EXTENS_RC AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
194 TEL_NUMBER_LONG_RC AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
195 FAX_COUNTRY_RC AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
196 FAX_NUMBER_RC AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
197 FAX_EXTENS_RC AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
198 FAX_NUMBER_LONG_RC AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
199 INTRENO_RC RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
200 ROLE_RC REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
201 XROLE_RC REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
202 SUBROLE_RC REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
203 XSUBROLE_RC REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
204 ROLECATE_RC REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
205 APPL_RC REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
206 VALIDFROM_RC REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
207 VALIDTO_RC REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
208 ADDRTYPE_RC REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
209 .INCLUDE       0   0   Clerk  
210 .INCLU-_CL       0   0   Business Partner: General Data  
211 PARTNER_CL BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
212 PARTN_CAT_CL BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
213 SEARCHTERM1_CL BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
214 SEARCHTERM2_CL BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
215 FIRSTNAME_CL BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
216 LASTNAME_CL BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
217 NAME1_CL BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
218 NAME2_CL BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
219 NAME3_CL BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
220 NAME4_CL BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
221 NAMEGROUP1_CL BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
222 NAMEGROUP2_CL BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
223 XNAME_CL REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
224 XPARTNER_CL REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
225 XSALUTATION_CL REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
226 XADDRESS_CL REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
227 LINE0_CL LINES LINES CHAR 80   0   Address line  
228 LINE1_CL LINES LINES CHAR 80   0   Address line  
229 LINE2_CL LINES LINES CHAR 80   0   Address line  
230 LINE3_CL LINES LINES CHAR 80   0   Address line  
231 LINE4_CL LINES LINES CHAR 80   0   Address line  
232 LINE5_CL LINES LINES CHAR 80   0   Address line  
233 LINE6_CL LINES LINES CHAR 80   0   Address line  
234 LINE7_CL LINES LINES CHAR 80   0   Address line  
235 LINE8_CL LINES LINES CHAR 80   0   Address line  
236 LINE9_CL LINES LINES CHAR 80   0   Address line  
237 ADDRCATE_CL AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
238 ADDRNUMBER_CL AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
239 PERSNUMBER_CL AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
240 SMTP_ADDR_CL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
241 TEL_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
242 TEL_NUMBER_CL AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
243 TEL_EXTENS_CL AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
244 TEL_NUMBER_LONG_CL AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
245 FAX_COUNTRY_CL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
246 FAX_NUMBER_CL AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
247 FAX_EXTENS_CL AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
248 FAX_NUMBER_LONG_CL AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
249 INTRENO_CL RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
250 ROLE_CL REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
251 XROLE_CL REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
252 SUBROLE_CL REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
253 XSUBROLE_CL REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
254 ROLECATE_CL REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
255 APPL_CL REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
256 VALIDFROM_CL REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
257 VALIDTO_CL REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
258 ADDRTYPE_CL REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
259 .INCLUDE       0   0   Further Partner 1  
260 .INCLU-_P1       0   0   Business Partner: General Data  
261 PARTNER_P1 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
262 PARTN_CAT_P1 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
263 SEARCHTERM1_P1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
264 SEARCHTERM2_P1 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
265 FIRSTNAME_P1 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
266 LASTNAME_P1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
267 NAME1_P1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
268 NAME2_P1 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
269 NAME3_P1 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
270 NAME4_P1 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
271 NAMEGROUP1_P1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
272 NAMEGROUP2_P1 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
273 XNAME_P1 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
274 XPARTNER_P1 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
275 XSALUTATION_P1 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
276 XADDRESS_P1 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
277 LINE0_P1 LINES LINES CHAR 80   0   Address line  
278 LINE1_P1 LINES LINES CHAR 80   0   Address line  
279 LINE2_P1 LINES LINES CHAR 80   0   Address line  
280 LINE3_P1 LINES LINES CHAR 80   0   Address line  
281 LINE4_P1 LINES LINES CHAR 80   0   Address line  
282 LINE5_P1 LINES LINES CHAR 80   0   Address line  
283 LINE6_P1 LINES LINES CHAR 80   0   Address line  
284 LINE7_P1 LINES LINES CHAR 80   0   Address line  
285 LINE8_P1 LINES LINES CHAR 80   0   Address line  
286 LINE9_P1 LINES LINES CHAR 80   0   Address line  
287 ADDRCATE_P1 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
288 ADDRNUMBER_P1 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
289 PERSNUMBER_P1 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
290 SMTP_ADDR_P1 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
291 TEL_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
292 TEL_NUMBER_P1 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
293 TEL_EXTENS_P1 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
294 TEL_NUMBER_LONG_P1 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
295 FAX_COUNTRY_P1 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
296 FAX_NUMBER_P1 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
297 FAX_EXTENS_P1 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
298 FAX_NUMBER_LONG_P1 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
299 INTRENO_P1 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
300 ROLE_P1 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
301 XROLE_P1 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
302 SUBROLE_P1 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
303 XSUBROLE_P1 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
304 ROLECATE_P1 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
305 APPL_P1 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
306 VALIDFROM_P1 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
307 VALIDTO_P1 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
308 ADDRTYPE_P1 REBPADDRTYPE BU_ADRKIND CHAR 10   0   Address Type *
309 .INCLUDE       0   0   Further Partner 2  
310 .INCLU-_P2       0   0   Business Partner: General Data  
311 PARTNER_P2 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
312 PARTN_CAT_P2 BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
313 SEARCHTERM1_P2 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
314 SEARCHTERM2_P2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
315 FIRSTNAME_P2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
316 LASTNAME_P2 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
317 NAME1_P2 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
318 NAME2_P2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
319 NAME3_P2 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
320 NAME4_P2 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
321 NAMEGROUP1_P2 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
322 NAMEGROUP2_P2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
323 XNAME_P2 REBPXNAME BU_TEXT50 CHAR 50   0   Short Name of Business Partner  
324 XPARTNER_P2 REBPXPARTNER TEXT80 CHAR 80   0   Name/Address of Business Partner  
325 XSALUTATION_P2 REBPXSALUTATION CHAR80 CHAR 80   0   Salutation for Business Partner  
326 XADDRESS_P2 REBPXADDRESS REBPXADDRESS CHAR 80   0   Compact Display of Address  
327 LINE0_P2 LINES LINES CHAR 80   0   Address line  
328 LINE1_P2 LINES LINES CHAR 80   0   Address line  
329 LINE2_P2 LINES LINES CHAR 80   0   Address line  
330 LINE3_P2 LINES LINES CHAR 80   0   Address line  
331 LINE4_P2 LINES LINES CHAR 80   0   Address line  
332 LINE5_P2 LINES LINES CHAR 80   0   Address line  
333 LINE6_P2 LINES LINES CHAR 80   0   Address line  
334 LINE7_P2 LINES LINES CHAR 80   0   Address line  
335 LINE8_P2 LINES LINES CHAR 80   0   Address line  
336 LINE9_P2 LINES LINES CHAR 80   0   Address line  
337 ADDRCATE_P2 AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
338 ADDRNUMBER_P2 AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
339 PERSNUMBER_P2 AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
340 SMTP_ADDR_P2 AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
341 TEL_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
342 TEL_NUMBER_P2 AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
343 TEL_EXTENS_P2 AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
344 TEL_NUMBER_LONG_P2 AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
345 FAX_COUNTRY_P2 AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
346 FAX_NUMBER_P2 AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
347 FAX_EXTENS_P2 AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
348 FAX_NUMBER_LONG_P2 AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
349 INTRENO_P2 RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
350 ROLE_P2 REBPROLE BU_ROLE CHAR 6   0   Business Partner: Role *
351 XROLE_P2 REBPXROLE RECAXMDESCRIPTION CHAR 30   0   Name of Business Partner Role  
352 SUBROLE_P2 REBPSUBROLE REBPSUBROLE CHAR 4   0   Business Partner: Role Type TIVBPSUBROLE
353 XSUBROLE_P2 REBPXSUBROLE RECAXMDESCRIPTION CHAR 30   0   Name of Role Type  
354 ROLECATE_P2 REBPROLECATE REBPROLECATE CHAR 1   0   Category of Role Category  
355 APPL_P2 REBPAPPL BP_APPL CHAR 4   0   Business Partner: Application Category *
356 VALIDFROM_P2 REBPVALIDFROM RECADATEBEG DATS 8   0   Date of Start of Relationship  
357 VALIDTO_P2 REBPVALIDTO RECADATEEND DATS 8   0   Date of End of Relationship  
358 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_AO AOFUNCTION TIVBDARFUNC AOFUNCTION KEY 1 CN
2 RECP_OI_DOC_AO JERBBAU TDO9 SOBJERBBAU    
3 RECP_OI_DOC_AO MEASSTRC TIVBDMEASSTRC MEASSTRC KEY 1 CN
4 RECP_OI_DOC_AO RESPONSIBLE USR02 BNAME REF 1 CN
5 RECP_OI_DOC_AO RGEBART TIV5A SOBJART    
6 RECP_OI_DOC_AO RGEBZUST TIV83 RZUSTAND    
7 RECP_OI_DOC_AO RGRNART TIVC4 RGRNART KEY 1 CN
8 RECP_OI_DOC_AO RNBPLAN TIVB3 RNBPLAN 1 CN
9 RECP_OI_DOC_AO RSAREA TIVORRSAREA RSAREA KEY    
10 RECP_OI_DOC_AO SGRART TIV56 SGRART    
11 RECP_OI_DOC_AO SGRFRM TIV58 SGRFRM    
12 RECP_OI_DOC_AO SGRGZS TIV59 SGRGZS    
13 RECP_OI_DOC_AO SGRQAL TIV57 SGRQAL    
14 RECP_OI_DOC_AO SINSTBEZ TIV16 SINSTBEZ    
15 RECP_OI_DOC_AO SLAGEWE TIV10 SLAGEWE    
16 RECP_OI_DOC_AO SLIFTBIS TIV37 SSTOCKW    
17 RECP_OI_DOC_AO SOBJLAGE TIV45 SOBJLAGE    
18 RECP_OI_DOC_AO SSTCKBIS TIV37 SSTOCKW    
19 RECP_OI_DOC_AO SUBROLE_CL TIVBPSUBROLE SUBROLE REF C CN
20 RECP_OI_DOC_AO SUBROLE_P1 TIVBPSUBROLE SUBROLE REF C CN
21 RECP_OI_DOC_AO SUBROLE_P2 TIVBPSUBROLE SUBROLE REF C CN
22 RECP_OI_DOC_AO SUBROLE_RC TIVBPSUBROLE SUBROLE REF C CN
23 RECP_OI_DOC_AO SUNUTZA TIV36 SUNART    
24 RECP_OI_DOC_AO SVERKEHR TIV44 SVERKEHR    
25 RECP_OI_DOC_AO USEREXCLUSIVE USR02 BNAME REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 110