SAP ABAP Table RECP_OI_DOC_CN (Document Data: Contract)

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

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	Real Estate Contract and Additional Fields
2	.INCLUDE	☐				0	0	Real Estate Contract
3	.INCLUDE	☐				0	0	Real Estate Contract
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	RE Contract: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	RECNNR	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
9	.INCLUDE	☐				0	0	RE Contract: Non-Key Fields
10	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
11	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
12	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
13	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
14	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
15	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
16	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
17	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
18	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
19	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
20	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
21	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
22	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
23	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
24	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
25	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	TIV26
26	RECNBEG	☐	RECNCNBEG	RECADATE	DATS	8	0	Date of contract start
27	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
28	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
29	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
30	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
31	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
32	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
33	RECNNRCOLLECT	☐	RECNNUMBERCOLLECT	RECNNUMBER	CHAR	13	0	Number of Real Estate Main Contract
34	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	*
35	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
36	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
37	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
38	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
39	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
40	RECNDPO	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
41	RECNEND1ST	☐	RECNCNEND1ST	RECADATE	DATS	8	0	Date of First Contract End
42	RECNNOTPER	☐	RECNNTPER	RECADATE	DATS	8	0	Contract Notice Per
43	RECNNOTRECEIPT	☐	RECNNTRECEIPT	RECADATE	DATS	8	0	Date of receipt of notice
44	RECNNOTREASON	☐	RECNNTREASON	RECNNTREASON	NUMC	2	0	Reason for Notice	TIVCNNTRE
45	RECNDAKTKU	☐	RECNNTACTIVATEDON	RECADATE	DATS	8	0	Notice: Date of Activation
46	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
47	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
48	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
49	BENOCN	☐	RECNBENOCN	REBDBENO	CHAR	8	0	Business Entity That Belongs to Contract	*
50	TRANSPOSSFROM	☐	RECNTRANSPOSSFROM	RECADATEBEG	DATS	8	0	Transfer of Possession: Start Date
51	TRANSPOSSTO	☐	RECNTRANSPOSSTO	RECADATEEND	DATS	8	0	Transfer of Possession: End Date
52	HASMULTIASSIGN	☐	REBDHASMULTIASSIGN	RECABOOL	CHAR	1	0	Multiple Assignment of Object to Group Allowed
53	POSSDATEFROM	☐	REBDPOSSDATEFROM	RECADATE	DATS	8	0	Date From Which the Object Is Made Available for Use
54	POSSDATETO	☐	REBDPOSSDATETO	RECADATE	DATS	8	0	Date Up to Which the Object Is Used
55	.INCLUDE	☐				0	0
56	.INCLU--AP	☐				0	0	Country Specific Fields for Spain
57	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Contract
58	SECDEPRELEVANT	☐	REXCESCDREL	XFELD	CHAR	1	0	Relevant to Security Deposit
59	NOTADJSDCN	☐	REXCESCDNOTADJ	RECABOOL	CHAR	1	0	No Data Update in Security Deposit Contract
60	XRECNNRCOL	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
61	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
62	XRECNTYPE	☐	XMVARTM	XMBEZ	CHAR	30	0	Description of type of RE contract type
63	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
64	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
65	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
66	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
67	XTENANCYLAW	☐	XMIETR	XTEXT50	CHAR	50	0	Tenancy law long text
68	XCOLLECT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
69	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
70	XINDUSTRY	☐	RECNINDUSTRY	TEXT20	CHAR	20	0	Industry Name
71	XTRANSPOSSPERIOD	☐	RECNXTRANSPOSSPERIOD	RECAXMDESCRIPTION	CHAR	30	0	Productive Holdings: Time Period
72	.INCLUDE	☐				0	0	General Output Parameters
73	TEMPLATE	☐	RECPOITEMPLATE	TEXT64	CHAR	64	0	Template for Printing with Office Application
74	LANGU	☐	RECPOILANGU	SPRAS	LANG	1	0	Language for Document Creation	*
75	SELDATE	☐	RECPOISELDATE	RECADATE	DATS	8	0	Key Date for Data Selection
76	PRNDATE	☐	RECPOIPRNDATE	RECADATE	DATS	8	0	Print Date
77	.INCLUDE	☐				0	0	General Data for the Business Object
78	IDENTKEY	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
79	IDENT	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
80	XIDENT	☐	RECAXIDENT	TEXT80	CHAR	80	0	Object ID, for Example, Business Entity 1000/123
81	XOBJTYPE	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
82	XLOBJTYPE	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
83	BUSTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
84	BUSKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
85	.INCLUDE	☐				0	0	Sender (Company Code Data)
86	.INCLU-_SE	☐				0	0	Company Code Data
87	BUKRS_SE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
88	BUTXT_SE	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
89	ORT01_SE	☐	ORT01	TEXT25	CHAR	25	0	City
90	LAND1_SE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
91	WAERS_SE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
92	SPRAS_SE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
93	KTOPL_SE	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
94	WAABW_SE	☐	WAABW_001	NUM02	NUMC	2	0	Maximum exchange rate deviation in percent
95	PERIV_SE	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
96	KOKFI_SE	☐	KOKFI	KOKFI	CHAR	1	0	Allocation Indicator
97	RCOMP_SE	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
98	ADRNR_SE	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
99	STCEG_SE	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
100	FIKRS_SE	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
101	TXJCD_SE	☐	TXJCD_NSTX	TXJCD	CHAR	15	0	Jurisdiction for tax calculation - tax jurisdiction code	*
102	.INCLUDE	☐				0	0	Recipient
103	.INCLU-_RC	☐				0	0	Business Partner: General Data
104	PARTNER_RC	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
105	PARTN_CAT_RC	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
106	SEARCHTERM1_RC	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
107	SEARCHTERM2_RC	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
108	FIRSTNAME_RC	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
109	LASTNAME_RC	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
110	NAME1_RC	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
111	NAME2_RC	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
112	NAME3_RC	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
113	NAME4_RC	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
114	NAMEGROUP1_RC	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
115	NAMEGROUP2_RC	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
116	XNAME_RC	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
117	XPARTNER_RC	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
118	XSALUTATION_RC	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
119	XADDRESS_RC	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
120	LINE0_RC	☐	LINES	LINES	CHAR	80	0	Address line
121	LINE1_RC	☐	LINES	LINES	CHAR	80	0	Address line
122	LINE2_RC	☐	LINES	LINES	CHAR	80	0	Address line
123	LINE3_RC	☐	LINES	LINES	CHAR	80	0	Address line
124	LINE4_RC	☐	LINES	LINES	CHAR	80	0	Address line
125	LINE5_RC	☐	LINES	LINES	CHAR	80	0	Address line
126	LINE6_RC	☐	LINES	LINES	CHAR	80	0	Address line
127	LINE7_RC	☐	LINES	LINES	CHAR	80	0	Address line
128	LINE8_RC	☐	LINES	LINES	CHAR	80	0	Address line
129	LINE9_RC	☐	LINES	LINES	CHAR	80	0	Address line
130	ADDRCATE_RC	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
131	ADDRNUMBER_RC	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
132	PERSNUMBER_RC	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
133	SMTP_ADDR_RC	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
134	TEL_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
135	TEL_NUMBER_RC	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
136	TEL_EXTENS_RC	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
137	TEL_NUMBER_LONG_RC	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
138	FAX_COUNTRY_RC	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
139	FAX_NUMBER_RC	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
140	FAX_EXTENS_RC	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
141	FAX_NUMBER_LONG_RC	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
142	INTRENO_RC	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
143	ROLE_RC	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
144	XROLE_RC	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
145	SUBROLE_RC	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
146	XSUBROLE_RC	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
147	ROLECATE_RC	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
148	APPL_RC	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
149	VALIDFROM_RC	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
150	VALIDTO_RC	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
151	ADDRTYPE_RC	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
152	.INCLUDE	☐				0	0	Clerk
153	.INCLU-_CL	☐				0	0	Business Partner: General Data
154	PARTNER_CL	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
155	PARTN_CAT_CL	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
156	SEARCHTERM1_CL	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
157	SEARCHTERM2_CL	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
158	FIRSTNAME_CL	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
159	LASTNAME_CL	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
160	NAME1_CL	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
161	NAME2_CL	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
162	NAME3_CL	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
163	NAME4_CL	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
164	NAMEGROUP1_CL	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
165	NAMEGROUP2_CL	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
166	XNAME_CL	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
167	XPARTNER_CL	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
168	XSALUTATION_CL	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
169	XADDRESS_CL	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
170	LINE0_CL	☐	LINES	LINES	CHAR	80	0	Address line
171	LINE1_CL	☐	LINES	LINES	CHAR	80	0	Address line
172	LINE2_CL	☐	LINES	LINES	CHAR	80	0	Address line
173	LINE3_CL	☐	LINES	LINES	CHAR	80	0	Address line
174	LINE4_CL	☐	LINES	LINES	CHAR	80	0	Address line
175	LINE5_CL	☐	LINES	LINES	CHAR	80	0	Address line
176	LINE6_CL	☐	LINES	LINES	CHAR	80	0	Address line
177	LINE7_CL	☐	LINES	LINES	CHAR	80	0	Address line
178	LINE8_CL	☐	LINES	LINES	CHAR	80	0	Address line
179	LINE9_CL	☐	LINES	LINES	CHAR	80	0	Address line
180	ADDRCATE_CL	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
181	ADDRNUMBER_CL	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
182	PERSNUMBER_CL	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
183	SMTP_ADDR_CL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
184	TEL_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
185	TEL_NUMBER_CL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
186	TEL_EXTENS_CL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
187	TEL_NUMBER_LONG_CL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
188	FAX_COUNTRY_CL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
189	FAX_NUMBER_CL	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
190	FAX_EXTENS_CL	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
191	FAX_NUMBER_LONG_CL	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
192	INTRENO_CL	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
193	ROLE_CL	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
194	XROLE_CL	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
195	SUBROLE_CL	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
196	XSUBROLE_CL	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
197	ROLECATE_CL	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
198	APPL_CL	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
199	VALIDFROM_CL	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
200	VALIDTO_CL	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
201	ADDRTYPE_CL	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
202	.INCLUDE	☐				0	0	Further Partner 1
203	.INCLU-_P1	☐				0	0	Business Partner: General Data
204	PARTNER_P1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
205	PARTN_CAT_P1	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
206	SEARCHTERM1_P1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
207	SEARCHTERM2_P1	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
208	FIRSTNAME_P1	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
209	LASTNAME_P1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
210	NAME1_P1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
211	NAME2_P1	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
212	NAME3_P1	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
213	NAME4_P1	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
214	NAMEGROUP1_P1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
215	NAMEGROUP2_P1	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
216	XNAME_P1	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
217	XPARTNER_P1	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
218	XSALUTATION_P1	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
219	XADDRESS_P1	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
220	LINE0_P1	☐	LINES	LINES	CHAR	80	0	Address line
221	LINE1_P1	☐	LINES	LINES	CHAR	80	0	Address line
222	LINE2_P1	☐	LINES	LINES	CHAR	80	0	Address line
223	LINE3_P1	☐	LINES	LINES	CHAR	80	0	Address line
224	LINE4_P1	☐	LINES	LINES	CHAR	80	0	Address line
225	LINE5_P1	☐	LINES	LINES	CHAR	80	0	Address line
226	LINE6_P1	☐	LINES	LINES	CHAR	80	0	Address line
227	LINE7_P1	☐	LINES	LINES	CHAR	80	0	Address line
228	LINE8_P1	☐	LINES	LINES	CHAR	80	0	Address line
229	LINE9_P1	☐	LINES	LINES	CHAR	80	0	Address line
230	ADDRCATE_P1	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
231	ADDRNUMBER_P1	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
232	PERSNUMBER_P1	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
233	SMTP_ADDR_P1	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
234	TEL_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
235	TEL_NUMBER_P1	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
236	TEL_EXTENS_P1	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
237	TEL_NUMBER_LONG_P1	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
238	FAX_COUNTRY_P1	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
239	FAX_NUMBER_P1	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
240	FAX_EXTENS_P1	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
241	FAX_NUMBER_LONG_P1	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
242	INTRENO_P1	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
243	ROLE_P1	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
244	XROLE_P1	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
245	SUBROLE_P1	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
246	XSUBROLE_P1	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
247	ROLECATE_P1	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
248	APPL_P1	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
249	VALIDFROM_P1	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
250	VALIDTO_P1	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
251	ADDRTYPE_P1	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
252	.INCLUDE	☐				0	0	Further Partner 2
253	.INCLU-_P2	☐				0	0	Business Partner: General Data
254	PARTNER_P2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
255	PARTN_CAT_P2	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
256	SEARCHTERM1_P2	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
257	SEARCHTERM2_P2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
258	FIRSTNAME_P2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
259	LASTNAME_P2	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
260	NAME1_P2	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
261	NAME2_P2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
262	NAME3_P2	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
263	NAME4_P2	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
264	NAMEGROUP1_P2	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
265	NAMEGROUP2_P2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
266	XNAME_P2	☐	REBPXNAME	BU_TEXT50	CHAR	50	0	Short Name of Business Partner
267	XPARTNER_P2	☐	REBPXPARTNER	TEXT80	CHAR	80	0	Name/Address of Business Partner
268	XSALUTATION_P2	☐	REBPXSALUTATION	CHAR80	CHAR	80	0	Salutation for Business Partner
269	XADDRESS_P2	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
270	LINE0_P2	☐	LINES	LINES	CHAR	80	0	Address line
271	LINE1_P2	☐	LINES	LINES	CHAR	80	0	Address line
272	LINE2_P2	☐	LINES	LINES	CHAR	80	0	Address line
273	LINE3_P2	☐	LINES	LINES	CHAR	80	0	Address line
274	LINE4_P2	☐	LINES	LINES	CHAR	80	0	Address line
275	LINE5_P2	☐	LINES	LINES	CHAR	80	0	Address line
276	LINE6_P2	☐	LINES	LINES	CHAR	80	0	Address line
277	LINE7_P2	☐	LINES	LINES	CHAR	80	0	Address line
278	LINE8_P2	☐	LINES	LINES	CHAR	80	0	Address line
279	LINE9_P2	☐	LINES	LINES	CHAR	80	0	Address line
280	ADDRCATE_P2	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
281	ADDRNUMBER_P2	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
282	PERSNUMBER_P2	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
283	SMTP_ADDR_P2	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
284	TEL_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
285	TEL_NUMBER_P2	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
286	TEL_EXTENS_P2	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
287	TEL_NUMBER_LONG_P2	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
288	FAX_COUNTRY_P2	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
289	FAX_NUMBER_P2	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
290	FAX_EXTENS_P2	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
291	FAX_NUMBER_LONG_P2	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
292	INTRENO_P2	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
293	ROLE_P2	☐	REBPROLE	BU_ROLE	CHAR	6	0	Business Partner: Role	*
294	XROLE_P2	☐	REBPXROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Business Partner Role
295	SUBROLE_P2	☐	REBPSUBROLE	REBPSUBROLE	CHAR	4	0	Business Partner: Role Type	TIVBPSUBROLE
296	XSUBROLE_P2	☐	REBPXSUBROLE	RECAXMDESCRIPTION	CHAR	30	0	Name of Role Type
297	ROLECATE_P2	☐	REBPROLECATE	REBPROLECATE	CHAR	1	0	Category of Role Category
298	APPL_P2	☐	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	*
299	VALIDFROM_P2	☐	REBPVALIDFROM	RECADATEBEG	DATS	8	0	Date of Start of Relationship
300	VALIDTO_P2	☐	REBPVALIDTO	RECADATEEND	DATS	8	0	Date of End of Relationship
301	ADDRTYPE_P2	☐	REBPADDRTYPE	BU_ADRKIND	CHAR	10	0	Address Type	*
302	.INCLU--AP	☐				0	0	Rental Object Information
303	.INCLUDE	☐				0	0	Rental Object Customer fields
304	.INCLUDE	☐				0	0	Rental Object Customer fields
305	.INCLUDE	☐				0	0	Rental Object Customer fields
306	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
307	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
308	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
309	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
310	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
311	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
312	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
313	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
314	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
315	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
316	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
317	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
318	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
319	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
320	XKITCHEN	☐	REXCCHXROKITCHEN	RECAXLDESCRIPTION	CHAR	60	0	Description of Cooking Facilities
321	XFLOOR	☐	REXCCHXROFLOOR	RECAXLDESCRIPTION	CHAR	60	0	Description of Floor
322	XCONDITION	☐	REXCCHXROCOND	RECAXLDESCRIPTION	CHAR	60	0	Description of Dwelling Status
323	XUSAGETYPE	☐	REXCCHXROUSAGETYPE	RECAXLDESCRIPTION	CHAR	60	0	Description of Usage Type
324	XADDRESS_RO	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_OI_DOC_CN	BUKRS	T001	BUKRS	KEY	1	CN
2	RECP_OI_DOC_CN	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
3	RECP_OI_DOC_CN	RECNBUKRSCOLLECT	T001	BUKRS
4	RECP_OI_DOC_CN	RECNNOTREASON	TIVCNNTRE	NTREASON	REF	C	CN
5	RECP_OI_DOC_CN	RECNTLAW	TIV03	SMIETR	KEY	1	CN
6	RECP_OI_DOC_CN	RECNTYPE	TIV26	SMVART	KEY	1	CN
7	RECP_OI_DOC_CN	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	RECP_OI_DOC_CN	SUBROLE_CL	TIVBPSUBROLE	SUBROLE	REF	C	CN
9	RECP_OI_DOC_CN	SUBROLE_P1	TIVBPSUBROLE	SUBROLE	REF	C	CN
10	RECP_OI_DOC_CN	SUBROLE_P2	TIVBPSUBROLE	SUBROLE	REF	C	CN
11	RECP_OI_DOC_CN	SUBROLE_RC	TIVBPSUBROLE	SUBROLE	REF	C	CN
12	RECP_OI_DOC_CN	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

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