SAP ABAP Table BUPA_RESPYBP_ELMNTS_QU_SYNC (Find channel partners partners based on their basic data, cl)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_XI_PROXY (Package) Generated Proxies for Customer

Basic Data

Table Category	INTTAB	Structure
Structure	BUPA_RESPYBP_ELMNTS_QU_SYNC	Table Relationship Diagram
Short Description	Find channel partners partners based on their basic data, cl

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	RESPYBPELMNTSQU	☐	BUPA_RESPYBPELMNTSQU2		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	PROCESSING_CONDITIONS	☐	CRMSEF_QUERY_PROCESSING_CONDIT		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	QUERY_HITS_MAX_NUMBER_VALUE	☐	CRMSEF_NUMBER_VALUE		INT4	10	0	Proxy Data Element (Generated)
7	QUERY_HITS_UNLIMITED_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
8	LAST_RETURNED_OBJECT_ID	☐	CRMSEF_OBJECT_ID		STRU	0	0
9	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
10	SCHEME_ID	☐			CHAR	60	0
11	SCHEME_VERSION_ID	☐			CHAR	15	0
12	SCHEME_AGENCY_ID	☐			CHAR	60	0
13	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
14	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
15	CONTENT	☐	CRMSEF_OBJECT_ID_CONTENT		CHAR	100	0	Proxy Data Element (generated)
16	RESPONSIBILITY_BUSINESS_PARTNR	☐	BUPA_RESPYBPELMNTRESPYQU_SEL		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	SINGLE_RESP_PARAM_PROPERTYID	☐	CRMSEF_PROPERTY_ID		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	SCHEME_AGENCY_ID	☐			CHAR	60	0
21	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
22	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
23	CONTENT	☐	CRMSEF_PROPERTY_ID_CONTENT		CHAR	40	0	Proxy Data Element (generated)
24	SINGLE_RESP_PARAM_PARAMVALUE	☐	CRMSEF_OBJECT_PROPERTY_VALUE		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
27	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
28	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
29	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
30	QUANTITY	☐	CRMSEF_QUANTITY		STRU	0	0
31	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
32	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
33	CONTENT	☐	CRMSEF_QUANTITY_CONTENT		DEC	31	14	QUANTITY is the non-monetary numerical declaration of a quan
34	DECIMAL_VALUE	☐	CRMSEF_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)
35	FLOAT_VALUE	☐	CRMSEF_FLOAT_VALUE		FLTP	16	16	Proxy Data Element (generated)
36	INTEGER_VALUE	☐	CRMSEF_INTEGER_VALUE		INT4	10	0	Proxy Data Element (generated)
37	DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
38	TIME	☐	CRMSEF_TIME		TIMS	6	0	Proxy Data Element (Generated)
39	DATE_TIME	☐	CRMSEF_DATE_TIME		STRU	0	0
40	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
41	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
42	DAYLIGHT_SAVING_TIME_INDICATOR	☐			CHAR	5	0
43	CONTENT	☐			STRG	0	0
44	NAME	☐	CRMSEF_REGIONDEPENDENTLANGUAGE		STRU	0	0
45	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
46	LANGUAGE_CODE	☐	CRMSEF_REGIONDEPENDENT_LANGUAG		CHAR	9	0	Proxy Data Element (generated)
47	CONTENT	☐			STRG	0	0
48	INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
49	MEASURE	☐	CRMSEF_MEASURE		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
52	CONTENT	☐	CRMSEF_MEASURE_CONTENT		DEC	31	14	Measure is a physical indication of Measurements including t
53	CODE	☐	CRMSEF_CODE		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	LIST_ID	☐			CHAR	60	0
56	LIST_VERSION_ID	☐			CHAR	15	0
57	LIST_AGENCY_ID	☐			CHAR	60	0
58	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
59	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
60	CONTENT	☐			STRG	0	0
61	IDENTIFIER	☐	CRMSEF_IDENTIFIER		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	SCHEME_ID	☐			CHAR	60	0
64	SCHEME_VERSION_ID	☐			CHAR	15	0
65	SCHEME_AGENCY_ID	☐			CHAR	60	0
66	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
67	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
68	CONTENT	☐			STRG	0	0
69	URI	☐	CRMSEF_URI		STRU	0	0
70	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
71	SCHEME_ID	☐			CHAR	60	0
72	CONTENT	☐			STRG	0	0
73	BINARY_OBJECT	☐	CRMSEF_BINARY_OBJECT		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	MIME_CODE	☐	CRMSEF_MIMECODE		STRG	0	0	Proxy Data Element (generated)
76	CHARACTER_SET_CODE	☐	CRMSEF_CHARACTER_SET_CODE		STRG	0	0	A CharacterSetCode is the coded representation
77	FORMAT	☐			STRG	0	0
78	FILE_NAME	☐			STRG	0	0
79	URI	☐			STRG	0	0
80	CONTENT	☐			RSTR	0	0
81	DURATION	☐	CRMSEF_DURATION		STRG	0	0	Proxy Data Element (generated)
82	PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
83	RATIO	☐	CRMSEF_RATIO		DEC	31	14	Ratio is the relationship between two quantities, which is e
84	TEXT	☐	CRMSEF_TEXT		STRU	0	0
85	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
86	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
87	CONTENT	☐			STRG	0	0
88	BP_COMMON_KEY_WORDS_TEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
89	BP_COMMON_ADDIT_KEYWORDSTEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
90	BUSINESS_PARTNER_COMMON_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
91	BP_COMMON_ADDITIONAL_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
92	BP_LIFE_CYCLE_STATUSCODE	☐	CRMSEF_BUSINESS_PARTNER_LIFE_C		CHAR	2	0	Proxy Data Element (generated)
93	BP_ADDRESS_COUNTRY_CODE	☐	CRMSEF_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
94	BP_ADDRESS_REGION_CODE	☐	CRMSEF_REGION_CODE		STRU	0	0
95	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
96	LIST_ID	☐			CHAR	60	0
97	LIST_VERSION_ID	☐			CHAR	15	0
98	LIST_AGENCY_ID	☐			CHAR	60	0
99	AGENCY_SCHEME_ID	☐			CHAR	60	0
100	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
101	CONTENT	☐	CRMSEF_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (Generated)
102	BP_ADDRESS_CITY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
103	BP_ADDRESS_STREETNAME	☐	CRMSEF_STREET_NAME		CHAR	60	0	Proxy Data Element (generated)
104	NORMALISED_PHONE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
105	NORMALISED_FACSIMILE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
106	BUSINESS_PARTNER_EMAIL_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
107	BUSINESS_PARTNER_WEB_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
108	BUSINESS_PARTNER_ROLE_PARTY_BU	☐	CRMSEF_BUSINESSPARTNER_PARTY_1		STRU	0	0
109	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
110	LIST_ID	☐			CHAR	60	0
111	LIST_VERSION_ID	☐			CHAR	15	0
112	LIST_AGENCY_ID	☐			CHAR	60	0
113	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
114	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
115	CONTENT	☐	CRMSEF_BUSINESSPARTNER_PARTY_B		CHAR	6	0	Proxy Data Element (generated)
116	BUSINESS_PARTNER_ROLE_CODE	☐	BUPA_BUSINESS_PARTNER_ROLE_TAB		TTYP	0	0
117	BP_RELATIONSHIP_BPINTERNALID	☐	CRMSEF_BUSINESS_PARTNER_INTERN		CHAR	10	0	Definite proprietary identifier for a business partner
118	RELATIONSHIP_ROLE_CODE	☐	CRMSEF_BUSINESS_PARTNER_RELAT1		STRU	0	0
119	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
120	LIST_VERSION_ID	☐			CHAR	15	0
121	LIST_AGENCY_ID	☐			CHAR	60	0
122	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
123	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
124	CONTENT	☐	CRMSEF_BUSINESS_PARTNER_RELATI		CHAR	8	0	Proxy Data Element (generated)
125	CONTACT_PERSON_GIVEN_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
126	CONTACT_PERSON_FAMILY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
127	EMPLOYEE_RESPONSIBLE_GIVN_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
128	EMPLOYEE_RESPONS_FAMILY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
129	COMPETENCY_ID	☐	CRMSEF_NOSC_COMPETENCY_ID		CHAR	8	0	Proxy Data Element (generated)
130	COMPETENCY_RATING_CODE	☐	CRMSEF_NOSC_COMPETENCY_RATING		CHAR	4	0	Proxy Data Element (generated)
131	BP_CLASSIFICATION_PROPERTYREF	☐	CRMSEF_PROPERTY_REFERENCE		STRU	0	0
132	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
133	ID	☐	CRMSEF_PROPERTY_ID		STRU	0	0
134	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
135	SCHEME_AGENCY_ID	☐			CHAR	60	0
136	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
137	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
138	CONTENT	☐	CRMSEF_PROPERTY_ID_CONTENT		CHAR	40	0	Proxy Data Element (generated)
139	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
140	PROPERTY_DEFINITION_CLASS_REF	☐	CRMSEF_PROPERTY_DEFINITION_CLA		STRU	0	0
141	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
142	ID	☐	CRMSEF_PROPERTY_DEFINITION_CL2		STRU	0	0
143	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
144	SCHEME_AGENCY_ID	☐			CHAR	60	0
145	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
146	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
147	CONTENT	☐	CRMSEF_PROPERTY_DEFINITION_CL1		CHAR	72	0	Proxy Data Element (generated)
148	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
149	BP_CLASSIFICATION_VALUEGROUP	☐	CRMSEF_PROPERTY_VALUATION__TAB		TTYP	0	0
150	BUSINESS_PARTNER_CRMSELECTION1	☐	BUPA_BPCRMSEL_BY_BPID_TAB		TTYP	0	0
151	BUSINESS_PARTNER_CRMSELECTION3	☐	BUPA_BPCRMSEL_BY_ADDR_STEE_TAB		TTYP	0	0
152	BUSINESS_PARTNER_CRMSELECTION2	☐	BUPA_BPCRMSEL_BY_COMM_BIRT_TAB		TTYP	0	0
153	BUSINESS_PARTNER_CRMSELECTION	☐	BUPA_BPCRMSEL_BY_POADDR_HO_TAB		TTYP	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	700