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

History

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