SAP ABAP Table CRMT_BUPA_IL_PHA_HEADER_SEARCH (Pharma Advanced 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_HEADER_SEARCH |
|
| Short Description | Pharma Advanced 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 | |
0 | 0 | Search Structure of Search Object BuilHeaderSearch | |||||
| 2 | |
0 | 0 | BuPa Search: criteria for SEARCH_BY_BP_GENERAL (serv. class) | |||||
| 3 | |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
| 4 | |
BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
| 5 | |
BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
| 6 | |
BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
| 7 | |
BU_SOURCE | BU_SOURCE | CHAR | 4 | 0 | Data Origin Types | * | |
| 8 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 9 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 10 | |
BU_CONTACT | BU_CONTACT | CHAR | 1 | 0 | Business Partner: Contact Permission | ||
| 11 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 12 | |
BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
| 13 | |
BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
| 14 | |
BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
| 15 | |
BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
| 16 | |
BU_LEGAL_ORG | BU_LEGAL_ORG | CHAR | 2 | 0 | Legal Entity of Organization | * | |
| 17 | |
BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
| 18 | |
AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | * | |
| 19 | |
AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | * | |
| 20 | |
BU_NICKNAM | BU_NAME | CHAR | 40 | 0 | Nickname of Business Partner (Person) | ||
| 21 | |
BU_BIRTHDT | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
| 22 | |
BU_NAME1 | BU_NAME | CHAR | 40 | 0 | Name field 1 (name1/last name) | ||
| 23 | |
BU_NAME2 | BU_NAME | CHAR | 40 | 0 | Name field 2 (name2/first name) | ||
| 24 | |
BU_CRUSR | USNAM | CHAR | 12 | 0 | User who created the object | ||
| 25 | |
BU_CRDAT | DATUM | DATS | 8 | 0 | Date on which the object was created | ||
| 26 | |
BU_CHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
| 27 | |
BU_CHDAT | DATUM | DATS | 8 | 0 | Date when object was last changed | ||
| 28 | |
BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
| 29 | |
BU_AUGRP | BU_AUGRP | CHAR | 4 | 0 | Authorization Group | * | |
| 30 | |
0 | 0 | Search Structure for Communication Data (BP Header Search) | |||||
| 31 | |
AD_TELNRCL | CHAR30 | CHAR | 30 | 0 | Telephone number for determining caller | ||
| 32 | |
AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
| 33 | |
AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
| 34 | |
AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
| 35 | |
AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
| 36 | |
AD_URI2 | CHAR50 | CHAR | 50 | 0 | URI address search field | ||
| 37 | |
0 | 0 | Structure for Search for BP address in CRM (lowercase) | |||||
| 38 | |
AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
| 39 | |
AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
| 40 | |
AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
| 41 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 42 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 43 | |
CRMT_BU_REGION_IN_COUNTRY | CHAR7 | CHAR | 7 | 0 | Region by Country (for account address search) | ||
| 44 | |
AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
| 45 | |
AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
| 46 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 47 | |
0 | 0 | Structure for Turkey Localization fields | |||||
| 48 | |
AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
| 49 | |
AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
| 50 | |
0 | 0 | BP Header Search: search by Roles | |||||
| 51 | |
BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
| 52 | |
BU_PARTNERROLECAT | BU_ROLECAT | CHAR | 6 | 0 | BP Role Category | * | |
| 53 | |
BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
| 54 | |
BU_PARTNERROLE | BU_ROLE | CHAR | 6 | 0 | BP Role | * | |
| 55 | |
BU_MAXSEL | INT4 | 10 | 0 | Maximum number of selected entries | |||
| 56 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 57 | |
BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
| 58 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 59 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 60 | |
0 | 0 | Search Structure Include CRM Part | |||||
| 61 | |
CRMT_BSP_CUSTOMER_NUMBER | KUNNR | CHAR | 10 | 0 | ERP Customer Number of a Business Partner | * | |
| 62 | |
0 | 0 | CRM BP Fragment Structure of the Sales Classification | |||||
| 63 | |
CRMT_BU_IS_COMPETITOR | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is competitor | ||
| 64 | |
CRMT_BU_IS_PROSPECT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is a prospect | ||
| 65 | |
CRMT_BU_IS_CONSUMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is consumer | ||
| 66 | |
CRMT_BU_IS_CUSTOMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is customer | ||
| 67 | |
CRMT_CUSTOMER_SINCE | DATUM | DATS | 8 | 0 | Customer Since Date | ||
| 68 | |
CRMT_BU_IS_COD_CUSTOMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is cash on delivery customer | ||
| 69 | |
CRMT_INDUSTRY | CRM_INDUSTRY | CHAR | 4 | 0 | Industry Sector | CRMC_INDUSTRY | |
| 70 | |
CRMT_BU_IS_RENTED | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Rented Address | ||
| 71 | |
CRMT_BU_ACCOUNT_GROUP | CRM_BU_ACCOUNT_GROUP | CHAR | 4 | 0 | R/3 Account Group | CRMC_T077D | |
| 72 | |
CRMT_BU_NIELSEN_ID | CRM_BU_NIELSEN_ID | CHAR | 2 | 0 | Nielsen ID | CRMC_NIELSEN | |
| 73 | |
CRMT_BU_CUST_CLASSIFIC | CRM_BU_CUST_CLASSIFIC | CHAR | 2 | 0 | Customer Classification | CRMC_CLASSIF | |
| 74 | |
CRMT_BU_KATR1 | CRM_BU_KATR1 | CHAR | 2 | 0 | Attribute 1 | CRMC_ATTR01 | |
| 75 | |
CRMT_BU_KATR2 | CRM_BU_KATR2 | CHAR | 2 | 0 | Attribute 2 | CRMC_ATTR02 | |
| 76 | |
CRMT_BU_KATR3 | CRM_BU_KATR3 | CHAR | 2 | 0 | Attribute 3 | CRMC_ATTR03 | |
| 77 | |
CRMT_BU_KATR4 | CRM_BU_KATR4 | CHAR | 2 | 0 | Attribute 4 | CRMC_ATTR04 | |
| 78 | |
CRMT_BU_KATR5 | CRM_BU_KATR5 | CHAR | 2 | 0 | Attribute 5 | CRMC_ATTR05 | |
| 79 | |
CRMT_BU_KATR6 | CRM_BU_KATR6 | CHAR | 3 | 0 | Attribute 6 | CRMC_ATTR06 | |
| 80 | |
CRMT_BU_KATR7 | CRM_BU_KATR7 | CHAR | 3 | 0 | Attribute 7 | CRMC_ATTR07 | |
| 81 | |
CRMT_BU_KATR8 | CRM_BU_KATR8 | CHAR | 3 | 0 | Attribute 8 | CRMC_ATTR08 | |
| 82 | |
CRMT_BU_KATR9 | CRM_BU_KATR9 | CHAR | 3 | 0 | Attribute 9 | CRMC_ATTR09 | |
| 83 | |
CRMT_BU_KATR10 | CRM_BU_KATR10 | CHAR | 3 | 0 | Attribute 10 | CRMC_ATTR10 | |
| 84 | |
0 | 0 | Search Criteria for BuilHeaderSearch | |||||
| 85 | |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
| 86 | |
BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
| 87 | |
BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
| 88 | |
BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
| 89 | |
BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
| 90 | |
BU_VALDT_SEARCH | DATUM | DATS | 8 | 0 | Selection Date for Search Helps | ||
| 91 | |
AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | * | |
| 92 | |
CRMT_RESPONS_AREA | CRM_RESPONS_AREA | CHAR | 2 | 0 | Belonging to (Me, My Department, My Group) | ||
| 93 | |
BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
| 94 | |
BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
| 95 | |
CRMT_BUPA_IL_MARKATTR_SEARCH | CRMT_BUPA_IL_MARKATTR_SEARCH | CHAR | 150 | 0 | Generic Search for Marketing Attributes | ||
| 96 | |
CRMT_BUPA_IL_CLASS_SEARCH | CRMT_BUPA_IL_CLASS_SEARCH | CHAR | 130 | 0 | Generic Search for Classification | ||
| 97 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 98 | |
SYUNAME | SYCHAR12 | CHAR | 12 | 0 | User Name | ||
| 99 | |
0 | 0 | Business Partner: Search with ID | |||||
| 100 | |
BU_ID_TYPE | BU_ID_TYPE | CHAR | 6 | 0 | Identification Type | * | |
| 101 | |
COMT_BU_ID_TYPE_DESCIPTION | BU_TEXT40 | CHAR | 40 | 0 | Identification Type | ||
| 102 | |
BU_ID_NUMBER | CHAR60 | CHAR | 60 | 0 | Identification Number | ||
| 103 | |
0 | 0 | Relationship Category and Relationship Partner | |||||
| 104 | |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
| 105 | |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
| 106 | |
BU_RELTYP | BU_RELTYP | CHAR | 6 | 0 | Business Partner Relationship Category | * | |
| 107 | |
BU_XRF | XFELD | CHAR | 1 | 0 | Business partner role definition instead of BP relationship | ||
| 108 | |
0 | 0 | Search Structure for Relationship Data (BP Header Search) | |||||
| 109 | |
CRMT_BUPA_IL_RELTYP_SEARCH | CRMT_BUPA_IL_RELTYP_SEARCH | CHAR | 8 | 0 | Business Partner Relationship Category Including Direction | ||
| 110 | |
BU_XDIRECT | XFELD | CHAR | 1 | 0 | One-Way Business Partner Relationship Category | ||
| 111 | |
BU_RELTYP | BU_RELTYP | CHAR | 6 | 0 | Business Partner Relationship Category | * | |
| 112 | |
COMT_BSP_REL_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Partner ID of Relationship | * | |
| 113 | |
COMT_BSP_BP_NAME1 | BU_NAME | CHAR | 40 | 0 | Name 1 / Last Name (Search Help Field 1) | ||
| 114 | |
COMT_BSP_BP_NAME2 | BU_NAME | CHAR | 40 | 0 | Name 2 / First Name (Search Help Field 2) | ||
| 115 | |
CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
| 116 | |
0 | 0 | Search Filter Key / Value Entries | |||||
| 117 | |
CRMT_BUPA_IL_FILTER_KEY | CHAR4 | CHAR | 4 | 0 | Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
| 118 | |
CRMT_BUPA_IL_FILTER_VALUE | SYSUUID_C | CHAR | 32 | 0 | Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
| 119 | |
0 | 0 | Search by Territory Management Criteria | |||||
| 120 | |
CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
| 121 | |
CRMT_TERRITORY_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Territory Description | ||
| 122 | |
0 | 0 | Search by qualification / responsibility | |||||
| 123 | |
CHM_SEARCH_QUALIFICATION | CHM_SEARCH_QUALIFICATION | CHAR | 13 | 0 | CHM - Qualification Search (<QUALIFICATION>; <PROFICIENCY>) | ||
| 124 | |
CHM_SEARCH_RESPONSIBILITY | CHM_SEARCH_RESPONSIBILITY | CHAR | 61 | 0 | CHM # Responsibility Search (<CIRTERIA>;<VALUE>) | ||
| 125 | |
0 | 0 | Search Criteria for Marketing Permission | |||||
| 126 | |
CRMT_BU_MKTPERM_CHAN | CRMT_BU_MKTPERM_CHAN | CHAR | 3 | 0 | Communication Channel | * | |
| 127 | |
CRMT_BU_MKTPERM_PERMISSION | CRMT_BU_MKTPERM_PERMISSION | NUMC | 3 | 0 | Consent | ||
| 128 | |
0 | 0 | EEW Extension of BUT000 (Contains CI) | |||||
| 129 | |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
| 130 | |
0 | 0 | ||||||
| 131 | |
0 | 0 | AXT Extension for BuilHeader search structure | |||||
| 132 | |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
| 133 | |
0 | 0 | BuilHeader search structure: Bank data | |||||
| 134 | |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
| 135 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 136 | |
IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
| 137 | |
0 | 0 | Internal Structure for Sales and Distribution Area | |||||
| 138 | |
CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
| 139 | |
CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
| 140 | |
CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
| 141 | |
CRMT_BUPA_SEARCH_STATUS | CRMT_BUPA_SEARCH_STATUS | CHAR | 1 | 0 | Account and Contact Search Status | ||
| 142 | |
0 | 0 | Pharma Search Data | |||||
| 143 | |
0 | 0 | CRM Pharma. BP Group / Subgroup | |||||
| 144 | |
CRMPHAT_BP_GROUP | CRMPHA_BP_GROUP | CHAR | 4 | 0 | Group | CRMPHAC_BP_GRP | |
| 145 | |
CRMPHAT_BP_SUBGROUP | CRMPHA_BP_SUBGROUP | CHAR | 4 | 0 | Subgroup | CRMPHAC_BP_SGR | |
| 146 | |
CRMPHAT_BRICK_NUMBER_NANOBRICK | CRMPHA_BRICK_NUMBER | CHAR | 10 | 0 | CRM Pharma. BP : Market Segmentation | ||
| 147 | |
0 | 0 | CRM Pharma.: RPM Segments | |||||
| 148 | |
CRMPHAT_BRICK_NUMBER | CRMPHA_BRICK_NUMBER | CHAR | 10 | 0 | CRM Pharma. BP : Market Segmentation | ||
| 149 | |
0 | 0 | Pharma search request - Specialization | |||||
| 150 | |
CRMPHAT_BP_SPEC_KEY | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | CRM Pharma/Healthcare BP: Qualification Key | * | |
| 151 | |
CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
| 152 | |
CRMPHAT_BSP_ADL_QUAL | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Additional Qualification | * | |
| 153 | |
CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
| 154 | |
CRMPHAT_BSP_POSITION | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Position | * | |
| 155 | |
CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
| 156 | |
CRMPHAT_BSP_FUNCTION | CRMPHA_BP_SPEC_KEY | CHAR | 5 | 0 | Pharma BSP: Function | * | |
| 157 | |
CRMPHAT_BSP_SPEC_DESC | TEXT40 | CHAR | 40 | 0 | Description | ||
| 158 | |
0 | 0 | Pharma : BSP search request for DEA schedule | |||||
| 159 | |
CRMPHAT_DEA_SCHEDULE_KEY | CRMPHARM_DEA_SCHEDULE | CHAR | 2 | 0 | DEA drug schedule key |
Foreign Keys
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in | 510 |