SAP ABAP Table RECP_OI_DOC_RO (Document Data: Rental 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_RO	Table Relationship Diagram
Short Description	Document Data: Rental 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	Rental Object and Additional Fields (VIBDRO)
2	.INCLUDE	☐				0	0	Rental Object (VIBDRO)
3	.INCLUDE	☐				0	0	Rental 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	Rental Object: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
9	SMENR	☐	REBDRONO	REBDRONO	CHAR	8	0	Number of Rental Object
10	.INCLUDE	☐				0	0	Rental Object: 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	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
29	SNUNR	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
30	XMETXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
31	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land	*
32	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building	*
33	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
34	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
35	FIRSTPOSTING	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
36	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
37	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
38	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
39	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
40	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
41	RLRAFIXFITCATE	☐	REAJRLRAFIXFITCATE	REAJRLRAFIXFITCATE	CHAR	6	0	Fixtures and Fittings Category	TIVAJRLRAFFCT
42	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
43	PZUABSP	☐	REBDSUREPERCENT	REBDSUREPERCENT	DEC	4	2	Increase or Reduction for Representative List of Rents
44	SPOSINMSP	☐	REBDRLRABASEIND	REAJRLRAADJMBASE	CHAR	1	0	Method for Calculating Base Rent of Rep. List of Rents
45	PPOSINMSP	☐	REBDRLRAPERCENT	DECV3_2	DEC	5	2	Percentage for Positioning RU in RLR Spread
46	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
47	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
48	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
49	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
50	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
51	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
52	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
53	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
54	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
55	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
56	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
57	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
58	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
59	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
60	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
61	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
62	COMMONOWNED	☐	REBDCOMMONOWNED	RECABOOL	CHAR	1	0	Rental Object Is Common Property
63	OOLOCK	☐	REOROOLOCK	RECABOOL	CHAR	1	0	Do Not Consider Object for Real Estate Search
64	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
65	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
66	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
67	.INCLUDE	☐				0	0
68	.INCLU--AP	☐				0	0	Country Specific fields for Switzerland
69	.INCLUDE	☐				0	0	Rental Object Customer fields
70	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
71	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
72	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
73	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
74	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
75	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
76	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
77	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
78	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
79	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
80	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
81	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
82	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
83	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
84	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal
85	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Rental Object
86	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
87	VPTCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
88	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
89	BUKRSTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
90	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
91	XGRTXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
92	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
93	XLROTYPE	☐	REBDXLROTYPE	RECAXLDESCRIPTION	CHAR	60	0	Name of Rental Object Type
94	XMBEZ	☐	XNUNRM	XMBEZ	CHAR	30	0	Description of external usage type of rental unit
95	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
96	XRLRAFIXFITCATE	☐	REAJXRLRAFIXFITCATE	RECAXLDESCRIPTION	CHAR	60	0	Description of Fixtures and Fittings Category
97	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
98	XAUSTKLL	☐	XAUSTKLL	XTEXT50	CHAR	50	0	Long text of fixture and fitting category
99	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
100	XSTOCKL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
101	XSTBISK	☐	VVXSTBISK	VVXSTOCKK	CHAR	4	0	For RUs with several storeys: Top storey of RU
102	XSTBISL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
103	XKLGESCH	☐	XKLGESCH	XKBEZ	CHAR	15	0	Location in floor short name
104	XSLIFTBIS	☐	VVXLIFTB	VVXSTOCKK	CHAR	4	0	Elevator to floor in building
105	XSTOCKL_LIFTBIS	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
106	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
107	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
108	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
109	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
110	XADDRESS	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
111	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
112	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
113	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
114	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
115	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
116	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
117	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
118	RLRAAGE	☐	REAJRLRAAGE	REAJRLRAAGE	CHAR	6	0	Building Age Category	TIVAJRLRAAGE
119	RLRASIZ	☐	REAJRLRASIZ	REAJRLRASIZ	CHAR	6	0	Size Class	TIVAJRLRASIZ
120	RLRALABEL	☐	REAJRLRALABEL	REAJRLRALABEL	CHAR	10	0	Representative List of Rents Label	TIVAJRLRALABEL
121	XRLRALABEL	☐	REAJXRLRALABEL	RECAXLDESCRIPTION	CHAR	60	0	Name of Representative List of Rents Label
122	XGEBM	☐	XGEBM	XMBEZ	CHAR	30	0	Building parts long text
123	.INCLUDE	☐				0	0	Object Address
124	.INCLU-_OB	☐				0	0	Address
125	XADDRESS_OB	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
126	CITY1_OB	☐	AD_CITY1	TEXT40	CHAR	40	0	City
127	CITY2_OB	☐	AD_CITY2	TEXT40	CHAR	40	0	District
128	POST_CODE1_OB	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
129	STREET_OB	☐	AD_STREET	TEXT60	CHAR	60	0	Street
130	HOUSE_NUM1_OB	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
131	COUNTRY_OB	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
132	REGION_OB	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
133	ADRZUS_OB	☐	REBDXOBJECT	TEXT35	CHAR	35	0	Object Description
134	ADRNR_OB	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
135	ADRNR_ORI_OB	☐	REBDJADRORIG	REBDJDATORIG	CHAR	1	0	Address Origin ID
136	OBJNR_HI_OB	☐	REBDSOBJNRHI	CHAR13	CHAR	13	0	Number of the Superordinate Address Object
137	.INCLUDE	☐				0	0	General Output Parameters
138	TEMPLATE	☐	RECPOITEMPLATE	TEXT64	CHAR	64	0	Template for Printing with Office Application
139	LANGU	☐	RECPOILANGU	SPRAS	LANG	1	0	Language for Document Creation	*
140	SELDATE	☐	RECPOISELDATE	RECADATE	DATS	8	0	Key Date for Data Selection
141	PRNDATE	☐	RECPOIPRNDATE	RECADATE	DATS	8	0	Print Date
142	.INCLUDE	☐				0	0	General Data for the Business Object
143	IDENTKEY	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
144	IDENT	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
145	XIDENT	☐	RECAXIDENT	TEXT80	CHAR	80	0	Object ID, for Example, Business Entity 1000/123
146	XOBJTYPE	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
147	XLOBJTYPE	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
148	BUSTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
149	BUSKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
150	.INCLUDE	☐				0	0	Sender (Company Code Data)
151	.INCLU-_SE	☐				0	0	Company Code Data
152	BUKRS_SE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
153	BUTXT_SE	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
154	ORT01_SE	☐	ORT01	TEXT25	CHAR	25	0	City
155	LAND1_SE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
156	WAERS_SE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
157	SPRAS_SE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
158	KTOPL_SE	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
159	WAABW_SE	☐	WAABW_001	NUM02	NUMC	2	0	Maximum exchange rate deviation in percent
160	PERIV_SE	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
161	KOKFI_SE	☐	KOKFI	KOKFI	CHAR	1	0	Allocation Indicator
162	RCOMP_SE	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
163	ADRNR_SE	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
164	STCEG_SE	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
165	FIKRS_SE	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
166	TXJCD_SE	☐	TXJCD_NSTX	TXJCD	CHAR	15	0	Jurisdiction for tax calculation - tax jurisdiction code	*
167	.INCLUDE	☐				0	0	Recipient
168	.INCLU-_RC	☐				0	0	Business Partner: General Data
169	PARTNER_RC	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
170	PARTN_CAT_RC	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
171	SEARCHTERM1_RC	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
172	SEARCHTERM2_RC	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
173	FIRSTNAME_RC	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
174	LASTNAME_RC	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
175	NAME1_RC	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
176	NAME2_RC	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
177	NAME3_RC	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
178	NAME4_RC	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
179	NAMEGROUP1_RC	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
180	NAMEGROUP2_RC	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
181	XNAME_RC	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
182	XPARTNER_RC	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
183	XSALUTATION_RC	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
184	XADDRESS_RC	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
185	LINE0_RC	☐	LINES	LINES	CHAR	80	0	Address line
186	LINE1_RC	☐	LINES	LINES	CHAR	80	0	Address line
187	LINE2_RC	☐	LINES	LINES	CHAR	80	0	Address line
188	LINE3_RC	☐	LINES	LINES	CHAR	80	0	Address line
189	LINE4_RC	☐	LINES	LINES	CHAR	80	0	Address line
190	LINE5_RC	☐	LINES	LINES	CHAR	80	0	Address line
191	LINE6_RC	☐	LINES	LINES	CHAR	80	0	Address line
192	LINE7_RC	☐	LINES	LINES	CHAR	80	0	Address line
193	LINE8_RC	☐	LINES	LINES	CHAR	80	0	Address line
194	LINE9_RC	☐	LINES	LINES	CHAR	80	0	Address line
195	ADDRCATE_RC	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
196	ADDRNUMBER_RC	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
197	PERSNUMBER_RC	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
198	SMTP_ADDR_RC	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
199	TEL_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
200	TEL_NUMBER_RC	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
201	TEL_EXTENS_RC	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
202	TEL_NUMBER_LONG_RC	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
203	FAX_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
204	FAX_NUMBER_RC	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
205	FAX_EXTENS_RC	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
206	FAX_NUMBER_LONG_RC	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
207	INTRENO_RC	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
208	ROLE_RC	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
209	XROLE_RC	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
210	SUBROLE_RC	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
211	XSUBROLE_RC	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
212	ROLECATE_RC	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
213	APPL_RC	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
214	VALIDFROM_RC	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
215	VALIDTO_RC	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
216	ADDRTYPE_RC	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
217	.INCLUDE	☐				0	0	Clerk
218	.INCLU-_CL	☐				0	0	Business Partner: General Data
219	PARTNER_CL	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
220	PARTN_CAT_CL	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
221	SEARCHTERM1_CL	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
222	SEARCHTERM2_CL	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
223	FIRSTNAME_CL	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
224	LASTNAME_CL	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
225	NAME1_CL	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
226	NAME2_CL	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
227	NAME3_CL	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
228	NAME4_CL	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
229	NAMEGROUP1_CL	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
230	NAMEGROUP2_CL	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
231	XNAME_CL	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
232	XPARTNER_CL	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
233	XSALUTATION_CL	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
234	XADDRESS_CL	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
235	LINE0_CL	☐	LINES	LINES	CHAR	80	0	Address line
236	LINE1_CL	☐	LINES	LINES	CHAR	80	0	Address line
237	LINE2_CL	☐	LINES	LINES	CHAR	80	0	Address line
238	LINE3_CL	☐	LINES	LINES	CHAR	80	0	Address line
239	LINE4_CL	☐	LINES	LINES	CHAR	80	0	Address line
240	LINE5_CL	☐	LINES	LINES	CHAR	80	0	Address line
241	LINE6_CL	☐	LINES	LINES	CHAR	80	0	Address line
242	LINE7_CL	☐	LINES	LINES	CHAR	80	0	Address line
243	LINE8_CL	☐	LINES	LINES	CHAR	80	0	Address line
244	LINE9_CL	☐	LINES	LINES	CHAR	80	0	Address line
245	ADDRCATE_CL	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
246	ADDRNUMBER_CL	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
247	PERSNUMBER_CL	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
248	SMTP_ADDR_CL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
249	TEL_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
250	TEL_NUMBER_CL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
251	TEL_EXTENS_CL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
252	TEL_NUMBER_LONG_CL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
253	FAX_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
254	FAX_NUMBER_CL	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
255	FAX_EXTENS_CL	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
256	FAX_NUMBER_LONG_CL	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
257	INTRENO_CL	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
258	ROLE_CL	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
259	XROLE_CL	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
260	SUBROLE_CL	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
261	XSUBROLE_CL	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
262	ROLECATE_CL	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
263	APPL_CL	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
264	VALIDFROM_CL	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
265	VALIDTO_CL	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
266	ADDRTYPE_CL	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
267	.INCLUDE	☐				0	0	Further Partner 1
268	.INCLU-_P1	☐				0	0	Business Partner: General Data
269	PARTNER_P1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
270	PARTN_CAT_P1	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
271	SEARCHTERM1_P1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
272	SEARCHTERM2_P1	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
273	FIRSTNAME_P1	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
274	LASTNAME_P1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
275	NAME1_P1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
276	NAME2_P1	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
277	NAME3_P1	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
278	NAME4_P1	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
279	NAMEGROUP1_P1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
280	NAMEGROUP2_P1	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
281	XNAME_P1	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
282	XPARTNER_P1	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
283	XSALUTATION_P1	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
284	XADDRESS_P1	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
285	LINE0_P1	☐	LINES	LINES	CHAR	80	0	Address line
286	LINE1_P1	☐	LINES	LINES	CHAR	80	0	Address line
287	LINE2_P1	☐	LINES	LINES	CHAR	80	0	Address line
288	LINE3_P1	☐	LINES	LINES	CHAR	80	0	Address line
289	LINE4_P1	☐	LINES	LINES	CHAR	80	0	Address line
290	LINE5_P1	☐	LINES	LINES	CHAR	80	0	Address line
291	LINE6_P1	☐	LINES	LINES	CHAR	80	0	Address line
292	LINE7_P1	☐	LINES	LINES	CHAR	80	0	Address line
293	LINE8_P1	☐	LINES	LINES	CHAR	80	0	Address line
294	LINE9_P1	☐	LINES	LINES	CHAR	80	0	Address line
295	ADDRCATE_P1	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
296	ADDRNUMBER_P1	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
297	PERSNUMBER_P1	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
298	SMTP_ADDR_P1	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
299	TEL_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
300	TEL_NUMBER_P1	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
301	TEL_EXTENS_P1	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
302	TEL_NUMBER_LONG_P1	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
303	FAX_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
304	FAX_NUMBER_P1	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
305	FAX_EXTENS_P1	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
306	FAX_NUMBER_LONG_P1	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
307	INTRENO_P1	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
308	ROLE_P1	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
309	XROLE_P1	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
310	SUBROLE_P1	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
311	XSUBROLE_P1	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
312	ROLECATE_P1	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
313	APPL_P1	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
314	VALIDFROM_P1	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
315	VALIDTO_P1	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
316	ADDRTYPE_P1	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
317	.INCLUDE	☐				0	0	Further Partner 2
318	.INCLU-_P2	☐				0	0	Business Partner: General Data
319	PARTNER_P2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
320	PARTN_CAT_P2	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
321	SEARCHTERM1_P2	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
322	SEARCHTERM2_P2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
323	FIRSTNAME_P2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
324	LASTNAME_P2	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
325	NAME1_P2	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
326	NAME2_P2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
327	NAME3_P2	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
328	NAME4_P2	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
329	NAMEGROUP1_P2	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
330	NAMEGROUP2_P2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
331	XNAME_P2	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
332	XPARTNER_P2	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
333	XSALUTATION_P2	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
334	XADDRESS_P2	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
335	LINE0_P2	☐	LINES	LINES	CHAR	80	0	Address line
336	LINE1_P2	☐	LINES	LINES	CHAR	80	0	Address line
337	LINE2_P2	☐	LINES	LINES	CHAR	80	0	Address line
338	LINE3_P2	☐	LINES	LINES	CHAR	80	0	Address line
339	LINE4_P2	☐	LINES	LINES	CHAR	80	0	Address line
340	LINE5_P2	☐	LINES	LINES	CHAR	80	0	Address line
341	LINE6_P2	☐	LINES	LINES	CHAR	80	0	Address line
342	LINE7_P2	☐	LINES	LINES	CHAR	80	0	Address line
343	LINE8_P2	☐	LINES	LINES	CHAR	80	0	Address line
344	LINE9_P2	☐	LINES	LINES	CHAR	80	0	Address line
345	ADDRCATE_P2	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
346	ADDRNUMBER_P2	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
347	PERSNUMBER_P2	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
348	SMTP_ADDR_P2	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
349	TEL_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
350	TEL_NUMBER_P2	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
351	TEL_EXTENS_P2	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
352	TEL_NUMBER_LONG_P2	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
353	FAX_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
354	FAX_NUMBER_P2	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
355	FAX_EXTENS_P2	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
356	FAX_NUMBER_LONG_P2	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
357	INTRENO_P2	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
358	ROLE_P2	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
359	XROLE_P2	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
360	SUBROLE_P2	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
361	XSUBROLE_P2	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
362	ROLECATE_P2	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
363	APPL_P2	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
364	VALIDFROM_P2	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
365	VALIDTO_P2	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
366	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_RO	BUKRS	T001	BUKRS	KEY	1	CN
2	RECP_OI_DOC_RO	CONDK	TIVXCPTRACONS	CONSLEVEL
3	RECP_OI_DOC_RO	CURRENCY	TCURC	WAERS	KEY	1	CN
4	RECP_OI_DOC_RO	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
5	RECP_OI_DOC_RO	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
6	RECP_OI_DOC_RO	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
7	RECP_OI_DOC_RO	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	RECP_OI_DOC_RO	RLGESCH	TIV38	RLGESCH	KEY	1	CN
9	RECP_OI_DOC_RO	RLRA	TIVAJRLRA	RLRA	REF	C	CN
10	RECP_OI_DOC_RO	RLRAAGE	TIVAJRLRAAGE	RLRAAGE	REF	C	CN
11	RECP_OI_DOC_RO	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
12	RECP_OI_DOC_RO	RLRALABEL	TIVAJRLRALABEL	RLRALABEL	REF	C	CN
13	RECP_OI_DOC_RO	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
14	RECP_OI_DOC_RO	RLRASIZ	TIVAJRLRASIZ	RLRASIZ	REF	C	CN
15	RECP_OI_DOC_RO	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
16	RECP_OI_DOC_RO	SGEBT	TIV12	SGEBT	KEY	1	CN
17	RECP_OI_DOC_RO	SNUNR	TIV01	SNUNR	REF	1	CN
18	RECP_OI_DOC_RO	SSTCKBIS	TIV37	SSTOCKW
19	RECP_OI_DOC_RO	SSTOCKW	TIV37	SSTOCKW	KEY	1	C
20	RECP_OI_DOC_RO	SUBROLE_CL	TIVBPSUBROLE	SUBROLE	REF	C	CN
21	RECP_OI_DOC_RO	SUBROLE_P1	TIVBPSUBROLE	SUBROLE	REF	C	CN
22	RECP_OI_DOC_RO	SUBROLE_P2	TIVBPSUBROLE	SUBROLE	REF	C	CN
23	RECP_OI_DOC_RO	SUBROLE_RC	TIVBPSUBROLE	SUBROLE	REF	C	CN
24	RECP_OI_DOC_RO	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
25	RECP_OI_DOC_RO	VPTCURRENCY	TCURC	WAERS

History

Last changed by/on	SAP	20140121
SAP Release Created in	110