SAP ABAP Table CRMT_BUPA_IL_PHA_EMP_SEARCH (Pharma Employee Adv. Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH-BP (Application Component) Business Partner
     ⤷ CRM_BUPA_PHARMA_BOL (Package) Pharma specific BP BOL implementation

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUPA_IL_PHA_EMP_SEARCH	Table Relationship Diagram
Short Description	Pharma Employee Adv. Search

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	.INCLUDE	☐				0	0	IL: Structure of Search Object 'BuilEmpSearch'
2	.INCLUDE	☐				0	0	Emp Search: criteria for SEARCH_BY_BP_GENERAL (serv. class)
3	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	MC_NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
5	MC_NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
6	SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
7	SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
8	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
9	.INCLUDE	☐				0	0	BP Emp Search: search by Roles
10	ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
11	ROLECATEGORY	☐	BU_PARTNERROLECAT	BU_ROLECAT	CHAR	6	0	BP Role Category	*
12	.INCLUDE	☐				0	0	Search Structure for Communication Data (BP Header Search)
13	TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
14	COUNTRY_FOR_TEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
15	FAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
16	COUNTRY_FOR_FAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
17	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
18	URL	☐	AD_URI2	CHAR50	CHAR	50	0	URI address search field
19	.INCLUDE	☐				0	0	Structure for Search for BP address in CRM (lowercase)
20	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
22	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	REGION_IN_COUNTRY	☐	CRMT_BU_REGION_IN_COUNTRY	CHAR7	CHAR	7	0	Region by Country (for account address search)
26	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
27	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
28	STDADDR_ONLY	☐	CRMT_BUPA_IL_FLAG_SET	CRM_BUPA_IL_FLAG_SET	CHAR	1	0	Specifies whether a flag is set or not set
29	.INCLUDE	☐				0	0	Structure for Turkey Localization fields
30	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
31	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
32	MAX_HIT	☐	BU_MAXSEL		INT4	10	0	Maximum number of selected entries
33	NO_TREX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
34	FUZZY_SEARCH	☐	CRMT_BUPA_IL_FLAG_SET	CRM_BUPA_IL_FLAG_SET	CHAR	1	0	Specifies whether a flag is set or not set
35	CATEGORY	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
36	ALL_ADDRESS_VERSION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
37	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
38	USERNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
39	ALSO_INVALID	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
40	.INCLUDE	☐				0	0	Search attributes for chm responsibility attributes
41	CRITERIA1	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
42	CRIT_VALUE1	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
43	CRITERIA2	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
44	CRIT_VALUE2	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
45	CRITERIA3	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
46	CRIT_VALUE3	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
47	CRITERIA4	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
48	CRIT_VALUE4	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
49	CRITERIA5	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
50	CRIT_VALUE5	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
51	.INCLUDE	☐				0	0	Search Filter Key / Value Entries
52	FILTER_KEY	☐	CRMT_BUPA_IL_FILTER_KEY	CHAR4	CHAR	4	0	Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH
53	FILTER_VALUE	☐	CRMT_BUPA_IL_FILTER_VALUE	SYSUUID_C	CHAR	32	0	Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH
54	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
55	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0	AXT Extension for BuilHeader search structure
58	BP_AXT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
59	.INCLUDE	☐				0	0	Pharma Search Data
60	.INCLUDE	☐				0	0	CRM Pharma. BP Group / Subgroup
61	BPGROUP	☐	CRMPHAT_BP_GROUP	CRMPHA_BP_GROUP	CHAR	4	0	Group	CRMPHAC_BP_GRP
62	BPSUBGROUP	☐	CRMPHAT_BP_SUBGROUP	CRMPHA_BP_SUBGROUP	CHAR	4	0	Subgroup	CRMPHAC_BP_SGR
63	NANOBRICK	☐	CRMPHAT_BRICK_NUMBER_NANOBRICK	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
64	.INCLUDE	☐				0	0	CRM Pharma.: RPM Segments
65	BRICK_NUMBER	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
66	.INCLUDE	☐				0	0	Pharma search request - Specialization
67	SPEC_TYPE	☐	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	*
68	SPEC_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
69	ADL_QUAL	☐	CRMPHAT_BSP_ADL_QUAL	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Additional Qualification	*
70	ADLQUAL_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
71	SPEC_POSITION	☐	CRMPHAT_BSP_POSITION	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Position	*
72	POS_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
73	FUNCTION	☐	CRMPHAT_BSP_FUNCTION	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Function	*
74	FUN_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
75	.INCLUDE	☐				0	0	Pharma : BSP search request for DEA schedule
76	DEA_SCHEDULE	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUPA_IL_PHA_EMP_SEARCH	BPGROUP	CRMPHAC_BP_GRP	BPGROUP	KEY	1	CN
2	CRMT_BUPA_IL_PHA_EMP_SEARCH	BPSUBGROUP	CRMPHAC_BP_SGR	BPSUBGROUP	KEY	1	CN
3	CRMT_BUPA_IL_PHA_EMP_SEARCH	COUNTRY	T005	LAND1	REF	1	CN
4	CRMT_BUPA_IL_PHA_EMP_SEARCH	REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in	510