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