SAP ABAP Table RECP_OI_DOC_BU (Document Data: Building)

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_BU	Table Relationship Diagram
Short Description	Document Data: Building

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	Building + Additional Fields (VIBDBU)
2	.INCLUDE	☐				0	0	Building (VIBDBU)
3	.INCLUDE	☐				0	0	Building
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	Building: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
9	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
10	.INCLUDE	☐				0	0	Building: 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	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
29	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
30	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
31	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
32	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
33	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
34	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
35	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
36	BBAUW13	☐	BBAUWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
37	BBAUWX	☐	BBAUWX	RECACURR	CURR	15	2	Building Value
38	BBAUWAKT	☐	BBAUWAKTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
39	BBAUWAKTX	☐	BBAUWAKTX	RECACURR	CURR	15	2	Current Building Value
40	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
41	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
42	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
43	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
44	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
45	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
46	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
47	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
48	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
49	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
50	BEINHEITW	☐	BEINHEITWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
51	BEINHEITWX	☐	BEINHEITWX	RECACURR	CURR	15	2	Assessed Value of Building
52	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
53	BVERSWRT	☐	BVERSWRTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
54	BVERSWRTX	☐	BVERSWRTX	RECACURR	CURR	15	2	Insurable Value Amount
55	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
56	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
57	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
58	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
59	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
60	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
61	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
62	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
63	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
64	JUNUTZA	☐	REBDJUNUTZAOBS	CHAR1	CHAR	1	0	OBSOLETE: Main Usage Type
65	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
66	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
67	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
68	JANLHIE	☐	REBDJANLHIEOBS	CHAR1	CHAR	1	0	OBSOLETE: Asset Assignment Also Applies for Subord. Building
69	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
70	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
71	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
72	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
73	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
74	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
75	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC
76	.INCLUDE	☐				0	0
77	.INCLU--AP	☐				0	0	Country specific fields (CI) for Switzerland - BU
78	.INCLUDE	☐				0	0	Building Customer fields
79	OBJCOND	☐	REXCCHBUCOND	REXCCHBUCOND	NUMC	4	0	Code of Building Status	TIVXCCHCOND
80	OBJCAT	☐	REXCCHBUCATEGORY	REXCCHBUCATEGORY	NUMC	4	0	Building Category Code	TIVXCCHKAT
81	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
82	AREAVALUE	☐	REXCCHBUAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Building in Square Meters
83	HEATINGTYPE	☐	REXCCHBUHEATINGTYPE	REXCCHBUHEATINGTYPE	NUMC	4	0	Code of Heating Type	TIVXCCHHEAT
84	ENERGYHEAT	☐	REXCCHBUENERGYSOURCEH	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Heating	TIVXCCHGENSRC
85	ENERGYWATER	☐	REXCCHBUENERGYSOURCEW	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Hot Water	TIVXCCHGENSRC
86	HOTWATERSUPPLY	☐	REXCCHBUHOTWATER	RECABOOL	CHAR	1	0	Central Hot Water Supply
87	POWERCONSUM	☐	REXCCHBUPOWERCONSUMPTION	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Power Consumption of Building (in kWh)
88	GLAZING	☐	REXCCHBUGLAZING	TEXT15	CHAR	15	0	Glazing Type
89	ADMINNO	☐	REXCCHBUADMINNO	REXCCHBUADMINNO	CHAR	12	0	Administrative Building Number
90	ADMINXGETXT	☐	REXCCHBUADMINXBU	RECAXLDESCRIPTION	CHAR	60	0	Building Name
91	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
92	BANZGECH	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
93	SSTCKBISCH	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
94	SLIFTBISCH	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
95	AUGESCHCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
96	.INCLU--AP	☐				0	0	Country specific fields for India - BU
97	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
98	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
99	.INCLU--AP	☐				0	0	Localization Japan: Additional fields Building
100	.INCLUDE	☐				0	0	Country Specific Fields for Japan
101	REPKOCH	☐	REXCJPREPKOCH	REXCJPREPKOCH	CHAR	1	0	Kind of Change
102	BDCONSTR	☐	REXCJPBDCONSTR	REXCJPBDCONST	CHAR	1	0	Construction Status
103	BDFIREPREV	☐	REXCJPBDFIREPREV	CHAR8	CHAR	8	0	Fire Fighting Method Number
104	BDOTHOW	☐	REXCJPBDOTHOW	INT4	INT4	10	0	Number of Another Owners in the Same Building
105	BDOWNSHIP	☐	REXCJPBDOWNSHIP	REXCJPBDOWNSH	CHAR	1	0	Building Ownership Status
106	KOCHDATE	☐	REXCJPKOCHDATE	RECADATE	DATS	8	0	Date of Change in Kind of Change
107	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal - Building
108	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Building
109	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
110	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
111	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
112	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
113	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
114	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
115	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
116	XGEBART	☐	XGEBART	XTEXT50	CHAR	50	0	Type of building
117	XGEBZUST	☐	XGEBZUST	XTEXT50	CHAR	50	0	Description of condition of building
118	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
119	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
120	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
121	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
122	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
123	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
124	XDAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
125	XFAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
126	XADDRESS	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
127	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
128	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
129	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
130	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
131	XSTOCKO	☐	REBDXSTOCKO	XKBEZ	CHAR	15	0	Top Floor (Floor Name)
132	XSTOCKL	☐	REBDXSTOCKL	XKBEZ	CHAR	15	0	Elevator to (Floor Name)
133	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
134	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
135	XMUSGFUNCTION	☐	REBDXMUSGFUNCTION	RECAXMDESCRIPTION	CHAR	30	0	Name of Function of Object (Medium)
136	XJERBBAUK	☐	XTEXT15	TEXT15	CHAR	15	0	Name
137	XJERBBAUL	☐	XTEXT30	TEXT30	CHAR	30	0	Name
138	.INCLUDE	☐				0	0	Object Address
139	.INCLU-_OB	☐				0	0	Address
140	XADDRESS_OB	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
141	CITY1_OB	☐	AD_CITY1	TEXT40	CHAR	40	0	City
142	CITY2_OB	☐	AD_CITY2	TEXT40	CHAR	40	0	District
143	POST_CODE1_OB	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
144	STREET_OB	☐	AD_STREET	TEXT60	CHAR	60	0	Street
145	HOUSE_NUM1_OB	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
146	COUNTRY_OB	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
147	REGION_OB	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
148	ADRZUS_OB	☐	REBDXOBJECT	TEXT35	CHAR	35	0	Object Description
149	ADRNR_OB	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
150	ADRNR_ORI_OB	☐	REBDJADRORIG	REBDJDATORIG	CHAR	1	0	Address Origin ID
151	OBJNR_HI_OB	☐	REBDSOBJNRHI	CHAR13	CHAR	13	0	Number of the Superordinate Address Object
152	.INCLUDE	☐				0	0	General Output Parameters
153	TEMPLATE	☐	RECPOITEMPLATE	TEXT64	CHAR	64	0	Template for Printing with Office Application
154	LANGU	☐	RECPOILANGU	SPRAS	LANG	1	0	Language for Document Creation	*
155	SELDATE	☐	RECPOISELDATE	RECADATE	DATS	8	0	Key Date for Data Selection
156	PRNDATE	☐	RECPOIPRNDATE	RECADATE	DATS	8	0	Print Date
157	.INCLUDE	☐				0	0	General Data for the Business Object
158	IDENTKEY	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
159	IDENT	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
160	XIDENT	☐	RECAXIDENT	TEXT80	CHAR	80	0	Object ID, for Example, Business Entity 1000/123
161	XOBJTYPE	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
162	XLOBJTYPE	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
163	BUSTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
164	BUSKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
165	.INCLUDE	☐				0	0	Sender (Company Code Data)
166	.INCLU-_SE	☐				0	0	Company Code Data
167	BUKRS_SE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
168	BUTXT_SE	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
169	ORT01_SE	☐	ORT01	TEXT25	CHAR	25	0	City
170	LAND1_SE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
171	WAERS_SE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
172	SPRAS_SE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
173	KTOPL_SE	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
174	WAABW_SE	☐	WAABW_001	NUM02	NUMC	2	0	Maximum exchange rate deviation in percent
175	PERIV_SE	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
176	KOKFI_SE	☐	KOKFI	KOKFI	CHAR	1	0	Allocation Indicator
177	RCOMP_SE	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
178	ADRNR_SE	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
179	STCEG_SE	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
180	FIKRS_SE	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
181	TXJCD_SE	☐	TXJCD_NSTX	TXJCD	CHAR	15	0	Jurisdiction for tax calculation - tax jurisdiction code	*
182	.INCLUDE	☐				0	0	Recipient
183	.INCLU-_RC	☐				0	0	Business Partner: General Data
184	PARTNER_RC	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
185	PARTN_CAT_RC	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
186	SEARCHTERM1_RC	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
187	SEARCHTERM2_RC	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
188	FIRSTNAME_RC	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
189	LASTNAME_RC	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
190	NAME1_RC	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
191	NAME2_RC	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
192	NAME3_RC	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
193	NAME4_RC	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
194	NAMEGROUP1_RC	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
195	NAMEGROUP2_RC	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
196	XNAME_RC	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
197	XPARTNER_RC	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
198	XSALUTATION_RC	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
199	XADDRESS_RC	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
200	LINE0_RC	☐	LINES	LINES	CHAR	80	0	Address line
201	LINE1_RC	☐	LINES	LINES	CHAR	80	0	Address line
202	LINE2_RC	☐	LINES	LINES	CHAR	80	0	Address line
203	LINE3_RC	☐	LINES	LINES	CHAR	80	0	Address line
204	LINE4_RC	☐	LINES	LINES	CHAR	80	0	Address line
205	LINE5_RC	☐	LINES	LINES	CHAR	80	0	Address line
206	LINE6_RC	☐	LINES	LINES	CHAR	80	0	Address line
207	LINE7_RC	☐	LINES	LINES	CHAR	80	0	Address line
208	LINE8_RC	☐	LINES	LINES	CHAR	80	0	Address line
209	LINE9_RC	☐	LINES	LINES	CHAR	80	0	Address line
210	ADDRCATE_RC	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
211	ADDRNUMBER_RC	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
212	PERSNUMBER_RC	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
213	SMTP_ADDR_RC	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
214	TEL_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
215	TEL_NUMBER_RC	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
216	TEL_EXTENS_RC	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
217	TEL_NUMBER_LONG_RC	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
218	FAX_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
219	FAX_NUMBER_RC	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
220	FAX_EXTENS_RC	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
221	FAX_NUMBER_LONG_RC	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
222	INTRENO_RC	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
223	ROLE_RC	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
224	XROLE_RC	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
225	SUBROLE_RC	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
226	XSUBROLE_RC	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
227	ROLECATE_RC	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
228	APPL_RC	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
229	VALIDFROM_RC	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
230	VALIDTO_RC	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
231	ADDRTYPE_RC	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
232	.INCLUDE	☐				0	0	Clerk
233	.INCLU-_CL	☐				0	0	Business Partner: General Data
234	PARTNER_CL	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
235	PARTN_CAT_CL	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
236	SEARCHTERM1_CL	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
237	SEARCHTERM2_CL	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
238	FIRSTNAME_CL	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
239	LASTNAME_CL	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
240	NAME1_CL	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
241	NAME2_CL	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
242	NAME3_CL	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
243	NAME4_CL	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
244	NAMEGROUP1_CL	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
245	NAMEGROUP2_CL	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
246	XNAME_CL	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
247	XPARTNER_CL	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
248	XSALUTATION_CL	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
249	XADDRESS_CL	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
250	LINE0_CL	☐	LINES	LINES	CHAR	80	0	Address line
251	LINE1_CL	☐	LINES	LINES	CHAR	80	0	Address line
252	LINE2_CL	☐	LINES	LINES	CHAR	80	0	Address line
253	LINE3_CL	☐	LINES	LINES	CHAR	80	0	Address line
254	LINE4_CL	☐	LINES	LINES	CHAR	80	0	Address line
255	LINE5_CL	☐	LINES	LINES	CHAR	80	0	Address line
256	LINE6_CL	☐	LINES	LINES	CHAR	80	0	Address line
257	LINE7_CL	☐	LINES	LINES	CHAR	80	0	Address line
258	LINE8_CL	☐	LINES	LINES	CHAR	80	0	Address line
259	LINE9_CL	☐	LINES	LINES	CHAR	80	0	Address line
260	ADDRCATE_CL	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
261	ADDRNUMBER_CL	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
262	PERSNUMBER_CL	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
263	SMTP_ADDR_CL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
264	TEL_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
265	TEL_NUMBER_CL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
266	TEL_EXTENS_CL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
267	TEL_NUMBER_LONG_CL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
268	FAX_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
269	FAX_NUMBER_CL	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
270	FAX_EXTENS_CL	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
271	FAX_NUMBER_LONG_CL	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
272	INTRENO_CL	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
273	ROLE_CL	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
274	XROLE_CL	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
275	SUBROLE_CL	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
276	XSUBROLE_CL	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
277	ROLECATE_CL	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
278	APPL_CL	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
279	VALIDFROM_CL	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
280	VALIDTO_CL	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
281	ADDRTYPE_CL	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
282	.INCLUDE	☐				0	0	Further Partner 1
283	.INCLU-_P1	☐				0	0	Business Partner: General Data
284	PARTNER_P1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
285	PARTN_CAT_P1	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
286	SEARCHTERM1_P1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
287	SEARCHTERM2_P1	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
288	FIRSTNAME_P1	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
289	LASTNAME_P1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
290	NAME1_P1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
291	NAME2_P1	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
292	NAME3_P1	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
293	NAME4_P1	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
294	NAMEGROUP1_P1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
295	NAMEGROUP2_P1	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
296	XNAME_P1	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
297	XPARTNER_P1	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
298	XSALUTATION_P1	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
299	XADDRESS_P1	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
300	LINE0_P1	☐	LINES	LINES	CHAR	80	0	Address line
301	LINE1_P1	☐	LINES	LINES	CHAR	80	0	Address line
302	LINE2_P1	☐	LINES	LINES	CHAR	80	0	Address line
303	LINE3_P1	☐	LINES	LINES	CHAR	80	0	Address line
304	LINE4_P1	☐	LINES	LINES	CHAR	80	0	Address line
305	LINE5_P1	☐	LINES	LINES	CHAR	80	0	Address line
306	LINE6_P1	☐	LINES	LINES	CHAR	80	0	Address line
307	LINE7_P1	☐	LINES	LINES	CHAR	80	0	Address line
308	LINE8_P1	☐	LINES	LINES	CHAR	80	0	Address line
309	LINE9_P1	☐	LINES	LINES	CHAR	80	0	Address line
310	ADDRCATE_P1	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
311	ADDRNUMBER_P1	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
312	PERSNUMBER_P1	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
313	SMTP_ADDR_P1	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
314	TEL_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
315	TEL_NUMBER_P1	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
316	TEL_EXTENS_P1	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
317	TEL_NUMBER_LONG_P1	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
318	FAX_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
319	FAX_NUMBER_P1	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
320	FAX_EXTENS_P1	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
321	FAX_NUMBER_LONG_P1	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
322	INTRENO_P1	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
323	ROLE_P1	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
324	XROLE_P1	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
325	SUBROLE_P1	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
326	XSUBROLE_P1	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
327	ROLECATE_P1	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
328	APPL_P1	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
329	VALIDFROM_P1	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
330	VALIDTO_P1	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
331	ADDRTYPE_P1	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
332	.INCLUDE	☐				0	0	Further Partner 2
333	.INCLU-_P2	☐				0	0	Business Partner: General Data
334	PARTNER_P2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
335	PARTN_CAT_P2	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
336	SEARCHTERM1_P2	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
337	SEARCHTERM2_P2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
338	FIRSTNAME_P2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
339	LASTNAME_P2	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
340	NAME1_P2	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
341	NAME2_P2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
342	NAME3_P2	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
343	NAME4_P2	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
344	NAMEGROUP1_P2	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
345	NAMEGROUP2_P2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
346	XNAME_P2	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
347	XPARTNER_P2	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
348	XSALUTATION_P2	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
349	XADDRESS_P2	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
350	LINE0_P2	☐	LINES	LINES	CHAR	80	0	Address line
351	LINE1_P2	☐	LINES	LINES	CHAR	80	0	Address line
352	LINE2_P2	☐	LINES	LINES	CHAR	80	0	Address line
353	LINE3_P2	☐	LINES	LINES	CHAR	80	0	Address line
354	LINE4_P2	☐	LINES	LINES	CHAR	80	0	Address line
355	LINE5_P2	☐	LINES	LINES	CHAR	80	0	Address line
356	LINE6_P2	☐	LINES	LINES	CHAR	80	0	Address line
357	LINE7_P2	☐	LINES	LINES	CHAR	80	0	Address line
358	LINE8_P2	☐	LINES	LINES	CHAR	80	0	Address line
359	LINE9_P2	☐	LINES	LINES	CHAR	80	0	Address line
360	ADDRCATE_P2	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
361	ADDRNUMBER_P2	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
362	PERSNUMBER_P2	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
363	SMTP_ADDR_P2	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
364	TEL_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
365	TEL_NUMBER_P2	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
366	TEL_EXTENS_P2	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
367	TEL_NUMBER_LONG_P2	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
368	FAX_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
369	FAX_NUMBER_P2	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
370	FAX_EXTENS_P2	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
371	FAX_NUMBER_LONG_P2	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
372	INTRENO_P2	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
373	ROLE_P2	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
374	XROLE_P2	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
375	SUBROLE_P2	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
376	XSUBROLE_P2	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
377	ROLECATE_P2	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
378	APPL_P2	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
379	VALIDFROM_P2	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
380	VALIDTO_P2	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
381	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_BU	BUKRS	T001	BUKRS	KEY	1	CN
2	RECP_OI_DOC_BU	CONDK	TIVXCPTRACONS	CONSLEVEL
3	RECP_OI_DOC_BU	CURRENCY	TCURC	WAERS
4	RECP_OI_DOC_BU	ENERGYHEAT	TIVXCCHGENSRC	ENERGYSRC	KEY
5	RECP_OI_DOC_BU	ENERGYWATER	TIVXCCHGENSRC	ENERGYSRC	KEY
6	RECP_OI_DOC_BU	GEMEINDE	TIVG1	GEMEINDE
7	RECP_OI_DOC_BU	HEATINGTYPE	TIVXCCHHEAT	HEATINGTYPE	KEY
8	RECP_OI_DOC_BU	JERBBAU	TDO9	SOBJERBBAU
9	RECP_OI_DOC_BU	OBJCAT	TIVXCCHKAT	BCATEGORY	KEY
10	RECP_OI_DOC_BU	OBJCOND	TIVXCCHCOND	BCOND	KEY
11	RECP_OI_DOC_BU	REINS	T006	MSEHI	REF	C	CN
12	RECP_OI_DOC_BU	RESPONSIBLE	USR02	BNAME	REF	1	CN
13	RECP_OI_DOC_BU	RGEBART	TIV5A	SOBJART
14	RECP_OI_DOC_BU	RGEBZUST	TIV83	RZUSTAND
15	RECP_OI_DOC_BU	RLRA	TIVAJRLRA	RLRA	REF	C	CN
16	RECP_OI_DOC_BU	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
17	RECP_OI_DOC_BU	SUBROLE_CL	TIVBPSUBROLE	SUBROLE	REF	C	CN
18	RECP_OI_DOC_BU	SUBROLE_P1	TIVBPSUBROLE	SUBROLE	REF	C	CN
19	RECP_OI_DOC_BU	SUBROLE_P2	TIVBPSUBROLE	SUBROLE	REF	C	CN
20	RECP_OI_DOC_BU	SUBROLE_RC	TIVBPSUBROLE	SUBROLE	REF	C	CN
21	RECP_OI_DOC_BU	SUNUTZA	TIV36	SUNART
22	RECP_OI_DOC_BU	TXJCD	TTXJ	TXJCD	REF	C	CN
23	RECP_OI_DOC_BU	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
24	RECP_OI_DOC_BU	USGFUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN
25	RECP_OI_DOC_BU	WAERS	TCURC	WAERS	REF	C	CN

History

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