SAP ABAP Table CRMT_BUPA_IL_PHA_CONT_SEARCH (Pharma Contact Advance Search)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-IPH-BP (Application Component) Business Partner
⤷ CRM_BUPA_PHARMA_BOL (Package) Pharma specific BP BOL implementation
⤷ 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_CONT_SEARCH | Table Relationship Diagram |
Short Description | Pharma Contact Advance 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 | Structure of Search Object 'BuilContactPersonSearch' | |||||
2 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Contact from BUT000 | |||||
3 | CONP_NUMBER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
4 | BIRTHDATE | BU_BIRTHDT | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
5 | SOURCE | BU_SOURCE | BU_SOURCE | CHAR | 4 | 0 | Data Origin Types | * | |
6 | CREATION_USER | BU_CRUSR | USNAM | CHAR | 12 | 0 | User who created the object | ||
7 | CREATION_DATE | BU_CRDAT | DATUM | DATS | 8 | 0 | Date on which the object was created | ||
8 | CHANGE_USER | BU_CHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
9 | CHANGE_DATE | BU_CHDAT | DATUM | DATS | 8 | 0 | Date when object was last changed | ||
10 | NICKNAME | BU_NICKNAM | BU_NAME | CHAR | 40 | 0 | Nickname of Business Partner (Person) | ||
11 | BIRTHNAME | BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
12 | TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | * | |
13 | TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | * | |
14 | BPEXT | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
15 | CONTACT | BU_CONTACT | BU_CONTACT | CHAR | 1 | 0 | Business Partner: Contact Permission | ||
16 | FIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
17 | LASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
18 | SORT1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
19 | SORT2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
20 | XDELE | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
21 | MAX_HIT | INT2 | INT2 | INT2 | 5 | 0 | 2 byte integer (signed) | ||
22 | NO_TREX | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
23 | NO_EMP_FILTER | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
24 | FUZZY_SEARCH | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
25 | WITH_ACCOUNTS | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
26 | USERNAME | SYUNAME | SYCHAR12 | CHAR | 12 | 0 | User Name | ||
27 | ALL_ADDRESS_VERSION | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
28 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Account | |||||
29 | BP_NUMBER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
30 | ACCNAME | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
31 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Communication Data | |||||
32 | TELEPHONE | AD_TELNRCL | CHAR30 | CHAR | 30 | 0 | Telephone number for determining caller | ||
33 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | |||
34 | COUNTRY_FOR_TEL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
35 | FAX | AD_FAXNRCL | CHAR30 | CHAR | 30 | 0 | Fax number for finding sender | ||
36 | .INCLUDE | 0 | 0 | Structure for Search for BP address in CRM (lowercase) | |||||
37 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
38 | CITY2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
39 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
40 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
41 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
42 | REGION_IN_COUNTRY | CRMT_BU_REGION_IN_COUNTRY | CHAR7 | CHAR | 7 | 0 | Region by Country (for account address search) | ||
43 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
44 | HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
45 | STDADDR_ONLY | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
46 | .INCLUDE | 0 | 0 | Structure for Turkey Localization fields | |||||
47 | COUNTY | AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
48 | TOWNSHIP | AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
49 | .INCLUDE | 0 | 0 | BP Contact Search: search by Roles | |||||
50 | ROLE | BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
51 | ROLECATEGORY | BU_PARTNERROLECAT | BU_ROLECAT | CHAR | 6 | 0 | BP Role Category | * | |
52 | EXCLUDEDROLE | BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
53 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Copntacts from BUT051 | |||||
54 | PAFKT | BU_PAFKT | BU_PAFKT | CHAR | 4 | 0 | Function of partner | * | |
55 | ABTNR | BU_ABTNR | BU_ABTNR | CHAR | 4 | 0 | Department | * | |
56 | .INCLUDE | 0 | 0 | Search Criteria for Marketing Attributes | |||||
57 | MARKETINGATTR | CRMT_BUPA_IL_MARKATTR_SEARCH | CRMT_BUPA_IL_MARKATTR_SEARCH | CHAR | 150 | 0 | Generic Search for Marketing Attributes | ||
58 | .INCLUDE | 0 | 0 | Search Filter Key / Value Entries | |||||
59 | FILTER_KEY | CRMT_BUPA_IL_FILTER_KEY | CHAR4 | CHAR | 4 | 0 | Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
60 | FILTER_VALUE | CRMT_BUPA_IL_FILTER_VALUE | SYSUUID_C | CHAR | 32 | 0 | Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
61 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Attributes at the Relationship | |||||
62 | SALESEMP | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
63 | SALESEMPLASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
64 | SALESEMPFIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
65 | .INCLUDE | 0 | 0 | Contact Search: Criteria for Employee Responsible | |||||
66 | OWNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
67 | OWNERNAME | BU_EMPLO | BU_EMPLO | CHAR | 35 | 0 | Name of Employer of a Natural Person | ||
68 | OWNERLASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
69 | OWNERFIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
70 | .INCLUDE | 0 | 0 | Search by Territory Management Criteria | |||||
71 | TERRITORY_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
72 | TERR_DESCRIPTION | CRMT_TERRITORY_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Territory Description | ||
73 | RESP_AREA | CRMT_RESPONS_AREA | CRM_RESPONS_AREA | CHAR | 2 | 0 | Belonging to (Me, My Department, My Group) | ||
74 | .INCLUDE | 0 | 0 | Search Criteria for Marketing Permission | |||||
75 | MKTPERMCHANNEL | CRMT_BU_MKTPERM_CHAN | CRMT_BU_MKTPERM_CHAN | CHAR | 3 | 0 | Communication Channel | * | |
76 | MKTPERMCONSENT | CRMT_BU_MKTPERM_PERMISSION | CRMT_BU_MKTPERM_PERMISSION | NUMC | 3 | 0 | Consent | ||
77 | .INCLUDE | 0 | 0 | EEW Extension of BUT000 (Contains CI) | |||||
78 | BP_EEW_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
79 | .INCLUDE | 0 | 0 | ||||||
80 | .INCLUDE | 0 | 0 | AXT Extension for BuilHeader search structure | |||||
81 | BP_AXT_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
82 | CONTACT_STATUS | CRMT_BUPA_SEARCH_STATUS | CRMT_BUPA_SEARCH_STATUS | CHAR | 1 | 0 | Account and Contact Search Status | ||
83 | ACCOUNT_STATUS | CRMT_BUPA_SEARCH_STATUS | CRMT_BUPA_SEARCH_STATUS | CHAR | 1 | 0 | Account and Contact Search Status | ||
84 | .INCLUDE | 0 | 0 | Pharma Search Data | |||||
85 | .INCLUDE | 0 | 0 | CRM Pharma. BP Group / Subgroup | |||||
86 | BPGROUP | CRMPHAT_BP_GROUP | CRMPHA_BP_GROUP | CHAR | 4 | 0 | Group | CRMPHAC_BP_GRP | |
87 | BPSUBGROUP | CRMPHAT_BP_SUBGROUP | CRMPHA_BP_SUBGROUP | CHAR | 4 | 0 | Subgroup | CRMPHAC_BP_SGR | |
88 | NANOBRICK | CRMPHAT_BRICK_NUMBER_NANOBRICK | CRMPHA_BRICK_NUMBER | CHAR | 10 | 0 | CRM Pharma. BP : Market Segmentation | ||
89 | .INCLUDE | 0 | 0 | CRM Pharma.: RPM Segments | |||||
90 | BRICK_NUMBER | CRMPHAT_BRICK_NUMBER | CRMPHA_BRICK_NUMBER | CHAR | 10 | 0 | CRM Pharma. BP : Market Segmentation | ||
91 | .INCLUDE | 0 | 0 | Pharma search request - Specialization | |||||
92 | SPEC_TYPE | CRMPHAT_BP_SPEC_KEY | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | CRM Pharma/Healthcare BP: Qualification Key | * | |
93 | SPEC_DESC | CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
94 | ADL_QUAL | CRMPHAT_BSP_ADL_QUAL | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Additional Qualification | * | |
95 | ADLQUAL_DESC | CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
96 | SPEC_POSITION | CRMPHAT_BSP_POSITION | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Position | * | |
97 | POS_DESC | CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
98 | FUNCTION | CRMPHAT_BSP_FUNCTION | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Function | * | |
99 | FUN_DESC | CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
100 | .INCLUDE | 0 | 0 | Pharma : BSP search request for DEA schedule | |||||
101 | DEA_SCHEDULE | CRMPHAT_DEA_SCHEDULE_KEY | CRMPHARM_DEA_SCHEDULE | CHAR | 2 | 0 | DEA drug schedule key | ||
102 | .INCLUDE | 0 | 0 | Business Partner: Search with ID | |||||
103 | IDTYPE | BU_ID_TYPE | BU_ID_TYPE | CHAR | 6 | 0 | Identification Type | * | |
104 | IDTYPE_DESCRIPTION | COMT_BU_ID_TYPE_DESCIPTION | BU_TEXT40 | CHAR | 40 | 0 | Identification Type | ||
105 | IDNUMBER | BU_ID_NUMBER | CHAR60 | CHAR | 60 | 0 | Identification Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BUPA_IL_PHA_CONT_SEARCH | BPGROUP | CRMPHAC_BP_GRP | BPGROUP | KEY | 1 | CN |
2 | CRMT_BUPA_IL_PHA_CONT_SEARCH | BPSUBGROUP | CRMPHAC_BP_SGR | BPSUBGROUP | KEY | 1 | CN |
3 | CRMT_BUPA_IL_PHA_CONT_SEARCH | COUNTRY | T005 | LAND1 | REF | 1 | CN |
4 | CRMT_BUPA_IL_PHA_CONT_SEARCH | REGION | T005S | BLAND | REF | C | CN |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 510 |