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

History

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