SAP ABAP Table CRMPHA_SEARCH (SAP BP Screen Structure for Locator Search Screens)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH-BP (Application Component) Business Partner
     ⤷ CRMPHA_BUPA (Package) SAP Pharmaceuticals Enhancement Business Partner BAPIs

Basic Data

Table Category	INTTAB	Structure
Structure	CRMPHA_SEARCH	Table Relationship Diagram
Short Description	SAP BP Screen Structure for Locator Search Screens

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	SAP BP Screen Structure for Locator Search Screens
2	.INCLUDE	☐				0	0	Screen Structure for Search Fields
3	.INCLUDE	☐				0	0	Screen Structure for Search Fields: All Partner Categories
4	PARTNER_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	SEARCH1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
6	SEARCH2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
7	EXTERNAL_NUMBER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
8	CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
9	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
10	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
11	PARTNER_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
12	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
13	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
15	CITY_MC	☐	AD_CITY1	TEXT40	CHAR	40	0	City
16	STREET_MC	☐	AD_STREET	TEXT60	CHAR	60	0	Street
17	COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
18	TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
19	COUNTY_MC	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
20	TOWNSHIP_MC	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
21	IDTYPE	☐	BU_IDENT_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
22	IDNUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
23	.INCLU--AP	☐				0	0	CRM BP Screen Structure for Search Fields: All Partner Cats.
24	CUSTOMER_NUMBER	☐	CRMT_BU_MAP_CUSTOMER_NUMBER	KUNNR	CHAR	10	0	ERP Customer Number of a Business Partner	*
25	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Persons
26	FIRST_NAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
27	LAST_NAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
28	BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
29	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
30	.INCLU--AP	☐				0	0	CRM BP Screen Structure for Search Fields: Persons
31	CONTACT_NUMBER	☐			CHAR	10	0
32	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Organization
33	ORG_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
34	ORG_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
35	ORG_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
36	ORG_NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
37	LOCATION1	☐	BU_LOCATION1STR	CHAR7	CHAR	7	0	Business partner: International location number part 1 (DI)
38	LOCATION2	☐	BU_LOCATION2STR	CHAR5	CHAR	5	0	Business partner: International location number part 2 (DI)
39	LOCATION3	☐	BU_LOCATION3STR	CHAR1	CHAR	1	0	Business partner: International location number part 3 (DI)
40	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Group
41	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
42	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
43	NAME1	☐	PARTNER_NAME1	BU_NAME	CHAR	40	0	Partner name1
44	NAME2	☐	PARTNER_NAME2	BU_NAME	CHAR	40	0	Partner Name2
45	.INCLUDE	☐				0	0	Screen Structure for Search Fields
46	PARTNER_NUMBER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
47	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Persons
48	BP_RPM	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
49	BP_NANOBRICK	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
50	BP_GROUP	☐	CRMPHAT_BP_GROUP	CRMPHA_BP_GROUP	CHAR	4	0	Group
51	BP_SUBGROUP	☐	CRMPHAT_BP_SUBGROUP	CRMPHA_BP_SUBGROUP	CHAR	4	0	Subgroup
52	BP_SPEC_TYPE	☐	CRMPHAT_BP_SPEC_TYPE	CRMPHA_BP_SPEC_TYPE	CHAR	5	0	CRM Pharma. BP: Qualification Category
53	BP_SPEC_KEY_DI	☐	CRMPHAT_BP_SPEC_KEY_01	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Branch of Study Key	*
54	BP_SPEC_KEY_AQ	☐	CRMPHAT_BP_SPEC_KEY_02	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Additional Qualification Key	*
55	BP_SPEC_KEY_PO	☐	CRMPHAT_BP_SPEC_KEY_03	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma BP: Position Key	*
56	BP_SPEC_KEY_FU	☐	CRMPHAT_BP_SPEC_KEY_04	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma. BP: Function Key	*
57	BP_DISCIPLINE	☐	CRMPHAT_SPEC_DESC	TEXT40	CHAR	40	0	CRM Pharma/Healthcare BP: Description of Qualification
58	BP_ADD_QUAL	☐	CRMPHAT_SPEC_DESC	TEXT40	CHAR	40	0	CRM Pharma/Healthcare BP: Description of Qualification
59	BP_POSITION	☐	CRMPHAT_SPEC_DESC	TEXT40	CHAR	40	0	CRM Pharma/Healthcare BP: Description of Qualification
60	BP_FUNCTION	☐	CRMPHAT_SPEC_DESC	TEXT40	CHAR	40	0	CRM Pharma/Healthcare BP: Description of Qualification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMPHA_SEARCH	COUNTRY	T005	LAND1	REF	C	CN

History

Last changed by/on	SAP	20131122
SAP Release Created in	300