SAP ABAP Table BUPA_BPBYELMNTSQU (Business Partner Query Message, Selection by various Element)

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_BPBYELMNTSQU	Table Relationship Diagram
Short Description	Business Partner Query Message, Selection by various Element

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

History

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