SAP ABAP Table BUPA_WRKAGEMPETS_IDEMP_QU_SYNC (Find employee by name, workplace address, company and/or use)

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_WRKAGEMPETS_IDEMP_QU_SYNC	Table Relationship Diagram
Short Description	Find employee by name, workplace address, company and/or use

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	WRKAGMEMPELMNTIDEMBSDTQU	☐	BUPA_WRKAGMEMPELMNTIDEMBSDTQU2		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	EMPLELMBYWRKAGTQU_SELWKAG	☐	BUPA_EMPLELMBYWRKAGTQU_SELWKAG		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	ID	☐	CRMSEF_NOSC_WORK_AGREEMENT_ID		CHAR	40	0	Proxy Data Element (generated)
19	IDENTITY_USER_ACCOUNT_ID	☐	CRMSEF_USER_ACCOUNT_ID		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	SCHEME_AGENCY_ID	☐			CHAR	60	0
22	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
23	CONTENT	☐	CRMSEF_USER_ACCOUNT_ID_CONTENT		CHAR	255	0	Proxy Data Element (generated)
24	BUSINESS_PARTNER_INTERNAL_ID	☐	CRMSEF_BUSINESS_PARTNER_INTERN		CHAR	10	0	Definite proprietary identifier for a business partner
25	BUSINESS_PARTNER_COMMON_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
26	BP_COMMON_ADDITIONAL_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
27	BP_COMMON_KEY_WORDS_TEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
28	BP_COMMON_ADDIT_KEYWORDSTEXT	☐	CRMSEF_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (generated)
29	BP_ADDRESS_COUNTRY_CODE	☐	CRMSEF_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
30	BP_ADDRESS_REGION_CODE	☐	CRMSEF_REGION_CODE		STRU	0	0
31	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
32	LIST_ID	☐			CHAR	60	0
33	LIST_VERSION_ID	☐			CHAR	15	0
34	LIST_AGENCY_ID	☐			CHAR	60	0
35	AGENCY_SCHEME_ID	☐			CHAR	60	0
36	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
37	CONTENT	☐	CRMSEF_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (Generated)
38	BP_ADDRESS_CITY_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
39	BP_ADDRESS_STREET_NAME	☐	CRMSEF_STREET_NAME		CHAR	60	0	Proxy Data Element (generated)
40	NORMALISED_PHONE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
41	NORMALISED_FACSIMILE_NUMBER	☐	CRMSEF_LANGUAGEINDEPENDENT_SH1		CHAR	40	0	Proxy Data Element (generated)
42	BUSINESS_PARTNER_EMAIL_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
43	BUSINESS_PARTNER_WEB_URI	☐	CRMSEF_WEB_URI		STRG	0	0	Proxy Data Element (Generated)
44	BUSINESS_PARTNER_ROLE_PARTY_BU	☐	CRMSEF_BUSINESSPARTNER_PARTY_1		STRU	0	0
45	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
46	LIST_ID	☐			CHAR	60	0
47	LIST_VERSION_ID	☐			CHAR	15	0
48	LIST_AGENCY_ID	☐			CHAR	60	0
49	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
50	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
51	CONTENT	☐	CRMSEF_BUSINESSPARTNER_PARTY_B		CHAR	6	0	Proxy Data Element (generated)
52	BUSINESS_PARTNER_ROLE_CODE	☐	CRMSEF_BUSINESS_PARTNER_ROLE_1		STRU	0	0
53	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
54	LIST_ID	☐			CHAR	60	0
55	LIST_AGENCY_ID	☐			CHAR	60	0
56	LIST_VERSION_ID	☐			CHAR	15	0
57	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
58	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
59	CONTENT	☐	CRMSEF_BUSINESS_PARTNER_ROLE_C		CHAR	6	0	Proxy Data Element (generated)
60	EMPLOYEE_SELECTION_BY_PSTLCODE	☐	BUPA_BPCRMSEL_BY_ADDR_STEE_TAB		TTYP	0	0
61	EMPLOYEE_SELECTION_BY_BIRTHDAT	☐	BUPA_BPCRMSEL_BY_COMM_BIRT_TAB		TTYP	0	0
62	EMPLOYEE_SELECTION_BY_HOUSEID	☐	BUPA_BPCRMSEL_BY_POADDR_HO_TAB		TTYP	0	0
63	EMPLOYEE_SELECTION_BY_ID	☐	BUPA_BPCRMSEL_BY_BPID_TAB		TTYP	0	0

History

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