SAP ABAP Table CRMT_BSP_PHACON_SEAREQ (Search request Pharma - Contact person)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH-BP (Application Component) Business Partner
     ⤷ CRM_BSP_MODEL_IL_PHARMA (Package) Model Implementation: Pharma

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_PHACON_SEAREQ	Table Relationship Diagram
Short Description	Search request Pharma - Contact person

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	Pharma Search Data
2	.INCLUDE	☐				0	0	CRM Pharma. BP Group / Subgroup
3	BPGROUP	☐	CRMPHAT_BP_GROUP	CRMPHA_BP_GROUP	CHAR	4	0	Group	CRMPHAC_BP_GRP
4	BPSUBGROUP	☐	CRMPHAT_BP_SUBGROUP	CRMPHA_BP_SUBGROUP	CHAR	4	0	Subgroup	CRMPHAC_BP_SGR
5	NANOBRICK	☐	CRMPHAT_BRICK_NUMBER_NANOBRICK	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
6	.INCLUDE	☐				0	0	CRM Pharma.: RPM Segments
7	BRICK_NUMBER	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
8	.INCLUDE	☐				0	0	Pharma search request - Specialization
9	SPEC_TYPE	☐	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	*
10	SPEC_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
11	ADL_QUAL	☐	CRMPHAT_BSP_ADL_QUAL	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Additional Qualification	*
12	ADLQUAL_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
13	SPEC_POSITION	☐	CRMPHAT_BSP_POSITION	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Position	*
14	POS_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
15	FUNCTION	☐	CRMPHAT_BSP_FUNCTION	CRMPHA_BP_SPEC_KEY	CHAR	5	0	Pharma BSP: Function	*
16	FUN_DESC	☐	CRMPHAT_BSP_SPEC_DESC	TEXT40	CHAR	40	0	Description
17	.INCLUDE	☐				0	0	Pharma : BSP search request for DEA schedule
18	DEA_SCHEDULE	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key
19	.INCLUDE	☐				0	0	CRM BSP: Contact Partner Search (Request)
20	PARTNER1	☐	CRMT_COMPANY	BU_PARTNER	CHAR	10	0	Account ID	*
21	PARTNER2	☐	CRMT_CONTACT	BU_PARTNER	CHAR	10	0	Contact Person ID	*
22	.INCLUDE	☐				0	0	Contact Person Search: Address
23	NAME_FIRST	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
24	NAME_LAST	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
25	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
26	ROOMNUM_C	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
27	SORT1_P	☐	CRMT_BSP_COP_SORT1	CHAR20	CHAR	20	0	Search Term A Person
28	SORT2_P	☐	CRMT_BSP_COP_SORT2	CHAR20	CHAR	20	0	Search Term B Person
29	NAME1	☐	CRMT_BSP_NAME1	BU_NAME	CHAR	40	0	Name 1 (Search Help Field 1)
30	NAME2	☐	CRMT_BSP_NAME2	BU_NAME	CHAR	40	0	Name 2 (Search Help Field 2)
31	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
32	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
33	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
35	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
36	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
37	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
38	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
39	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
40	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
42	SORT1	☐	CRMT_BSP_ACC_SORT1	CHAR20	CHAR	20	0	Search Term A
43	SORT2	☐	CRMT_BSP_ACC_SORT2	CHAR20	CHAR	20	0	Search Term B
44	PARTNER2_USER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name

Foreign Keys

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

History

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