SAP ABAP Table BUPA_BPBYELMNTS_QU_SYNC (Query to retrieve a list of business partner records based o)

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_BPBYELMNTS_QU_SYNC	Table Relationship Diagram
Short Description	Query to retrieve a list of business partner records based o

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	BPBYELMNTSQU	☐	BUPA_BPBYELMNTSQU		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	BUSINESS_PARTNER_CRMSELECTION	☐	BUPA_BPELMNTQU		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	BUSINESS_PARTNER_CATEGORY_CODE	☐	CRMSEF_BUSINESS_PARTNER_CATEGO		CHAR	1	0	Proxy Data Element (generated)
19	BP_COMMON_KEY_WORDS_TEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
20	BP_COMMON_ADDIT_KEYWORDSTEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
21	BUSINESS_PARTNER_COMMON_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
22	BP_COMMON_ADDITIONAL_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
23	BUSINESS_PARTNER_COMMON_TYPE_C	☐	CRMSEF_BUSINESS_PARTNER_TYPE_1		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	LIST_ID	☐			CHAR	60	0
26	LIST_VERSION_ID	☐			CHAR	15	0
27	LIST_AGENCY_ID	☐			CHAR	60	0
28	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
29	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
30	CONTENT	☐	CRMSEF_BUSINESS_PARTNER_TYPE_C		CHAR	4	0	Data type for Business Partner Type
31	BUSINESS_PARTNER_COMMON_AUTHOR	☐	CRMSEF_AUTHORIZATION_GROUP_CO1		STRU	0	0
32	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
33	LIST_ID	☐			CHAR	60	0
34	LIST_VERSION_ID	☐			CHAR	15	0
35	LIST_AGENCY_ID	☐			CHAR	60	0
36	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
37	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
38	CONTENT	☐	CRMSEF_AUTHORIZATION_GROUP_COD		CHAR	4	0	Data type for Authorization Group
39	BP_LIFE_CYCLE_STATUSCODE	☐	CRMSEF_BUSINESS_PARTNER_LIFE_C		CHAR	2	0	Proxy Data Element (generated)
40	BP_ADDRESS_COUNTRY_CODE	☐	CRMSEF_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
41	BP_ADDRESS_REGION_CODE	☐	CRMSEF_REGION_CODE		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	LIST_ID	☐			CHAR	60	0
44	LIST_VERSION_ID	☐			CHAR	15	0
45	LIST_AGENCY_ID	☐			CHAR	60	0
46	AGENCY_SCHEME_ID	☐			CHAR	60	0
47	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
48	CONTENT	☐	CRMSEF_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (Generated)
49	BP_ADDRESS_CITY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
50	BP_ADDRESS_STREET_NAME	☐	CRMSEF_STREET_NAME		CHAR	60	0	Proxy Data Element (generated)
51	NORMALISED_PHONE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
52	NORMALISED_FACSIMILE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
53	BUSINESS_PARTNER_EMAIL_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
54	BUSINESS_PARTNER_WEB_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
55	BUSINESS_PARTNER_ROLE_PARTY_BU	☐	CRMSEF_BUSINESSPARTNER_PARTY_1		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	LIST_ID	☐			CHAR	60	0
58	LIST_VERSION_ID	☐			CHAR	15	0
59	LIST_AGENCY_ID	☐			CHAR	60	0
60	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
61	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
62	CONTENT	☐	CRMSEF_BUSINESSPARTNER_PARTY_B		CHAR	6	0	Proxy Data Element (generated)
63	BUSINESS_PARTNER_ROLE_CODE	☐	BUPA_BUSINESS_PARTNER_ROLE_TAB		TTYP	0	0
64	BP_RELATIONSHIP_BPINTERNALID	☐	CRMSEF_BUSINESS_PARTNER_INTERN		CHAR	10	0	Definite proprietary identifier for a business partner
65	RELATIONSHIP_ROLE_CODE	☐	CRMSEF_BUSINESS_PARTNER_RELAT1		STRU	0	0
66	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
67	LIST_VERSION_ID	☐			CHAR	15	0
68	LIST_AGENCY_ID	☐			CHAR	60	0
69	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
70	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
71	CONTENT	☐	CRMSEF_BUSINESS_PARTNER_RELATI		CHAR	8	0	Proxy Data Element (generated)
72	CONTACT_PERSON_GIVEN_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
73	CONTACT_PERSON_FAMILY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
74	EMPLOYEE_RESPONSIBLE_GIVN_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
75	EMPLOYEE_RESPONS_FAMILY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
76	BP_IDENTIFI_PARTYIDEN_TYPECODE	☐	CRMSEF_PARTY_IDENTIFIER_TYPE_1		STRU	0	0
77	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
78	LIST_ID	☐			CHAR	60	0
79	LIST_VERSION_ID	☐			CHAR	15	0
80	LIST_AGENCY_ID	☐			CHAR	60	0
81	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
82	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
83	CONTENT	☐	CRMSEF_PARTY_IDENTIFIER_TYPE_C		CHAR	6	0	Proxy Data Element (generated)
84	BP_IDENTIFICATION_BPID	☐	CRMSEF_BUSINESS_PARTNER_ID		CHAR	60	0	Definite identifier for a business partner
85	BP_CLASSIFICATION_PROPERTYREF	☐	CRMSEF_PROPERTY_REFERENCE		STRU	0	0
86	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
87	ID	☐	CRMSEF_PROPERTY_ID		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	SCHEME_AGENCY_ID	☐			CHAR	60	0
90	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
91	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
92	CONTENT	☐	CRMSEF_PROPERTY_ID_CONTENT		CHAR	40	0	Proxy Data Element (generated)
93	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
94	PROPERTY_DEFINITION_CLASS_REF	☐	CRMSEF_PROPERTY_DEFINITION_CLA		STRU	0	0
95	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
96	ID	☐	CRMSEF_PROPERTY_DEFINITION_CL2		STRU	0	0
97	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
98	SCHEME_AGENCY_ID	☐			CHAR	60	0
99	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
100	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
101	CONTENT	☐	CRMSEF_PROPERTY_DEFINITION_CL1		CHAR	72	0	Proxy Data Element (generated)
102	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
103	BP_CLASSIFICATION_VALUEGROUP	☐	CRMSEF_PROPERTY_VALUATION__TAB		TTYP	0	0
104	BP_ASSIGNED_MARKETNG_ATTRIBUTE	☐	CRMSEF_PROPERTY_VALUATION		STRU	0	0
105	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
106	PROPERTY_REFERENCE	☐	CRMSEF_PROPERTY_REFERENCE		STRU	0	0
107	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
108	ID	☐	CRMSEF_PROPERTY_ID		STRU	0	0
109	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
110	SCHEME_AGENCY_ID	☐			CHAR	60	0
111	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
112	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
113	CONTENT	☐	CRMSEF_PROPERTY_ID_CONTENT		CHAR	40	0	Proxy Data Element (generated)
114	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
115	PROPERTY_DEFINITION_CLASS_REF	☐	CRMSEF_PROPERTY_DEFINITION_CLA		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	ID	☐	CRMSEF_PROPERTY_DEFINITION_CL2		STRU	0	0
118	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
119	SCHEME_AGENCY_ID	☐			CHAR	60	0
120	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
121	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
122	CONTENT	☐	CRMSEF_PROPERTY_DEFINITION_CL1		CHAR	72	0	Proxy Data Element (generated)
123	VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
124	VALUE_GROUP	☐	CRMSEF_PROPERTY_VALUATION__TAB		TTYP	0	0
125	ACTION_CODE	☐	CRMSEF_ACTION_CODE		CHAR	2	0	Proxy Data Element (generated)
126	BP_MARKETNG_NIELSEN_REGIONCODE	☐	CRMSEF_NIELSEN_REGION_CODE		STRU	0	0
127	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
128	LIST_ID	☐			CHAR	60	0
129	LIST_VERSION_ID	☐			CHAR	15	0
130	LIST_AGENCY_ID	☐			CHAR	60	0
131	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
132	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
133	CONTENT	☐	CRMSEF_NIELSEN_REGION_CODE_CON		CHAR	2	0	Proxy Data Element (generated)
134	BP_MARKETNG_ABC_CLASSIFICCODE	☐	CRMSEF_CUSTOMER_ABCCLASSIFICA1		STRU	0	0
135	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
136	LIST_ID	☐			CHAR	60	0
137	LIST_VERSION_ID	☐			CHAR	15	0
138	LIST_AGENCY_ID	☐			CHAR	60	0
139	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
140	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
141	CONTENT	☐	CRMSEF_CUSTOMER_ABCCLASSIFICAT		CHAR	1	0	Proxy Data Element (generated)
142	BP_MARKETNG_ADDR_RENTEDINDIC	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
143	BUSINESS_PARTNER_CRMSELECTION3	☐	BUPA_BPCRMSEL_BY_ADDR_STEE_TAB		TTYP	0	0
144	BUSINESS_PARTNER_CRMSELECTION2	☐	BUPA_BPCRMSEL_BY_COMM_BIRT_TAB		TTYP	0	0
145	BUSINESS_PARTNER_CRMSELECTION1	☐	BUPA_BPCRMSEL_BY_POADDR_HO_TAB		TTYP	0	0
146	BUSINESS_PARTNER_CRMSELECTION4	☐	BUPA_BPCRMSEL_BY_BPID_TAB		TTYP	0	0

History

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