SAP ABAP Table CRM_RELATION (Proxy Structure (Generated))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-IF (Application Component) Data Exchange CRM Online <-> R/3
     ⤷ CRM_BUPA_MDM (Package) Business Partner (CRM-specific) Master Data Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_RELATION	Table Relationship Diagram
Short Description	Proxy Structure (Generated)

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	RELATION_HEADER	☐	RELATION_HEADER		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	OBJECT_TYPE	☐			CHAR	32	0
5	OBJECT_INSTANCE	☐	RELATION_INSTANCE		STRU	0	0
6	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
7	PARTNER1	☐	OBJECT_IDENTIFICATION		STRU	0	0
8	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
9	PARTY_ID	☐	PARTY_ID_TAB		TTYP	0	0
10	PARTNER2	☐	OBJECT_IDENTIFICATION		STRU	0	0
11	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
12	PARTY_ID	☐	PARTY_ID_TAB		TTYP	0	0
13	RELATION_CATEGORY_CODE	☐			CHAR	6	0
14	VALIDITY_END_DATE	☐			DATS	8	0
15	RELATION_DIFFERENTIATION_KEY	☐	DIFFERENTIATION_KEY		STRU	0	0
16	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
17	KEY_TYPE_CODE	☐			CHAR	10	0
18	KEY_COMPONENT	☐	DIFFERENTIATION_KEY_KEY_C_TAB1		TTYP	0	0
19	ADMINISTRATION_INFORMATION	☐	CHANGE_HISTORY		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	CHANGE_RECORD	☐	CHANGE_RECORD_TAB		TTYP	0	0
22	RELATION_INFORMATION	☐	RELATION_INFORMATION		STRU	0	0
23	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
24	GENERAL_INFORMATION	☐	RELATION_GENERAL_INFORMATION		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	TASK_CODE	☐	PARTY_TASK_CODE		CHAR	1	0	Change Indicator Role (I = Insert, D=Delete etc. )
27	GENERAL_DATA	☐	RELATION_GENERAL_DATA		STRU	0	0
28	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
29	VALIDITY_START_DATE	☐	PARTY_DATE		STRU	0	0
30	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
31	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
32	VALUE	☐	GDT_DATE		DATS	8	0	Proxy Data Element (Generated)
33	RELATION_TYPE_CODE	☐	PARTY_TYPE_CODE		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
36	VALUE	☐	PARTY_TYPE_CODE_CONTENT		CHAR	4	0	Type Code within the Business Partner interface
37	DEFAULT_RELATION_INDICATOR	☐	PARTY_INDICATOR		STRU	0	0
38	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
39	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
40	VALUE	☐			CHAR	5	0
41	ADDRESS_INFORMATION	☐	RELATION_ADDRESS_INFORMATION		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	COMPLETE_DATA_INDICATOR	☐			CHAR	1	0
44	ADDRESS	☐	RELATION_ADDRESS_TAB		TTYP	0	0
45	CONTACT	☐	RELATION_CONTACT		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	CENTRAL_INFORMATION	☐	RELATION_CONTACT_CENTRAL_INFO		STRU	0	0
48	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
49	CENTRAL_DATA	☐	RELATION_CONTACT_CENTRAL_DATA		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	FUNCTIONAL_TITLE_NAME	☐	PARTY_NAME		STRU	0	0
52	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
53	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
54	VALUE	☐	PARTY_NAME_CONTENT		CHAR	40	0	Object name within business partner data
55	FUNCTION_TYPE_CODE	☐	PARTY_TYPE_CODE		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
58	VALUE	☐	PARTY_TYPE_CODE_CONTENT		CHAR	4	0	Type Code within the Business Partner interface
59	DEPARTMENT_NAME	☐	PARTY_NAME		STRU	0	0
60	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
61	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
62	VALUE	☐	PARTY_NAME_CONTENT		CHAR	40	0	Object name within business partner data
63	DEPARTMENT_CODE	☐	TYPE_STRING_MIN0MAX4		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
66	VALUE	☐	TYPE_STRING_MIN0MAX4CONTENT		CHAR	4	0	Proxy Data Element (generated)
67	AUTHORITY_CODE	☐	PERSON_AUTHORITY_CODE		STRU	0	0
68	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
69	UPDATE_INDICATOR	☐			CHAR	5	0
70	VALUE	☐	PERSON_AUTHORITY_CODE_CONTENT		CHAR	1	0	Partner's Power of Attorney
71	VIPCODE	☐	TYPE_STRING_MIN0MAX1		STRU	0	0
72	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
73	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
74	VALUE	☐	TYPE_STRING_MIN0MAX1CONTENT		CHAR	1	0	Proxy Data Element (generated)
75	COMMENTS	☐	TYPE_STRING_MIN0MAX40		STRU	0	0
76	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
77	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
78	VALUE	☐	TYPE_STRING_MIN0MAX40CONTENT		CHAR	40	0	Proxy Data Element (generated)
79	TELEPHONE_NUMBER	☐	PARTY_PHONE_NUMBER		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
82	VALUE	☐	PARTY_PHONE_NUMBER_CONTENT		CHAR	30	0	Telephone no.: dialling code+number
83	TELEPHONE_EXTENSION_ID	☐	PARTY_PHONE_EXTENSION_ID		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
86	VALUE	☐	PARTY_PHONE_EXTENSION_IDCONTE		CHAR	10	0	Telephone no.: Extension
87	FACSIMILE_NUMBER	☐	PARTY_PHONE_NUMBER		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
90	VALUE	☐	PARTY_PHONE_NUMBER_CONTENT		CHAR	30	0	Telephone no.: dialling code+number
91	FACSIMILE_EXTENSION_ID	☐	PARTY_PHONE_EXTENSION_ID		STRU	0	0
92	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
93	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
94	VALUE	☐	PARTY_PHONE_EXTENSION_IDCONTE		CHAR	10	0	Telephone no.: Extension
95	EMAIL_ADDRESS	☐	PARTY_EMAIL_ADDRESS		STRU	0	0
96	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
97	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
98	VALUE	☐	PARTY_EMAIL_ADDRESS_CONTENT		CHAR	241	0	E-Mail Address
99	COMPANY_INTEREST	☐	RELATION_COMPANY_INTEREST		STRU	0	0
100	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
101	COMPANY_INTEREST_DATA	☐	RELATION_COMPANY_INTEREST_DATA		STRU	0	0
102	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
103	PARTICIPATION_PERCENT	☐	PARTY_PARTICIPATION_PERCENT		STRU	0	0
104	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
105	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
106	VALUE	☐	PARTY_PARTICIPATION_PERCENT_C		DEC	10	7	Percentage of the interest held by a corporate group parent
107	PARTICIPATION_AMOUNT	☐	PARTY_PARTICIPATION_AMOUNT		STRU	0	0
108	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
109	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
110	VALUE	☐	PARTY_PARTICIPATION_AMOUNT_CO		DEC	13	2	Amount of Capital Interest
111	CURRENCY_CODE	☐	PARTY_CURRENCY_CODE		STRU	0	0
112	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
113	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
114	VALUE	☐	PARTY_CURRENCY_CODE_CONTENT		CHAR	5	0	Currency Code
115	COMPANY_CONTROL_INDICATOR	☐	PARTY_INDICATOR		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	UPDATE_INDICATOR	☐	UPDATE_INDICATOR		CHAR	5	0	Indicator whether an element carries an updated value or not
118	VALUE	☐			CHAR	5	0
119	BUSINESS_HOUR_INFORMATION	☐	OBJECT_BUSINESS_HOUR_INFORMAT		STRU	0	0
120	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
121	COMPLETE_DATA_INDICATOR	☐			CHAR	5	0
122	BUSINESS_HOUR	☐	OBJECT_BUSINESS_HOUR_TAB		TTYP	0	0
123	CRMRELATION_INFORMATION	☐	CRMRELATION_INFORMATION		STRU	0	0
124	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
125	RELATION_SALES_AREA_INFORMATI	☐	RELATION_SALES_AREA_INFORM_TAB		TTYP	0	0

History

Last changed by/on	SAP	20131122
SAP Release Created in	400