SAP ABAP Table CRMT_BUPA_IL_HEADER_SEARCH_CHM (Business Partner Header Search for CHM)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CHM (Application Component) Channel Management
⤷ CRM_CHMIL (Package) Interaction Layer for Channel Management
⤷ CRM-CHM (Application Component) Channel Management
⤷ CRM_CHMIL (Package) Interaction Layer for Channel Management
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BUPA_IL_HEADER_SEARCH_CHM | Table Relationship Diagram |
Short Description | Business Partner Header Search for CHM |
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 | Search Structure of Search Object BuilHeaderSearch | |||||
2 | .INCLUDE | 0 | 0 | BuPa Search: criteria for SEARCH_BY_BP_GENERAL (serv. class) | |||||
3 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
4 | BPEXT | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
5 | SORT1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
6 | SORT2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
7 | SOURCE | BU_SOURCE | BU_SOURCE | CHAR | 4 | 0 | Data Origin Types | * | |
8 | XDELE | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
9 | XBLCK | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
10 | CONTACT | BU_CONTACT | BU_CONTACT | CHAR | 1 | 0 | Business Partner: Contact Permission | ||
11 | NOT_RELEASED | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
12 | NAME_ORG1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
13 | NAME_ORG2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
14 | NAME_ORG3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
15 | NAME_ORG4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
16 | LEGAL_ORG | BU_LEGAL_ORG | BU_LEGAL_ORG | CHAR | 2 | 0 | Legal Entity of Organization | * | |
17 | BIRTHNAME | BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
18 | TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | * | |
19 | TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | * | |
20 | NICKNAME | BU_NICKNAM | BU_NAME | CHAR | 40 | 0 | Nickname of Business Partner (Person) | ||
21 | BIRTHDATE | BU_BIRTHDT | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
22 | MC_NAME1 | BU_NAME1 | BU_NAME | CHAR | 40 | 0 | Name field 1 (name1/last name) | ||
23 | MC_NAME2 | BU_NAME2 | BU_NAME | CHAR | 40 | 0 | Name field 2 (name2/first name) | ||
24 | CREATION_USER | BU_CRUSR | USNAM | CHAR | 12 | 0 | User who created the object | ||
25 | CREATION_DATE | BU_CRDAT | DATUM | DATS | 8 | 0 | Date on which the object was created | ||
26 | CHANGE_USER | BU_CHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
27 | CHANGE_DATE | BU_CHDAT | DATUM | DATS | 8 | 0 | Date when object was last changed | ||
28 | PARTNER_GUID | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
29 | AUGRP | BU_AUGRP | BU_AUGRP | CHAR | 4 | 0 | Authorization Group | * | |
30 | .INCLUDE | 0 | 0 | Search Structure for Communication Data (BP Header Search) | |||||
31 | TELEPHONE | AD_TELNRCL | CHAR30 | CHAR | 30 | 0 | Telephone number for determining caller | ||
32 | COUNTRY_FOR_TEL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
33 | FAX | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
34 | COUNTRY_FOR_FAX | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
35 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | |||
36 | URL | AD_URI2 | CHAR50 | CHAR | 50 | 0 | URI address search field | ||
37 | .INCLUDE | 0 | 0 | Structure for Search for BP address in CRM (lowercase) | |||||
38 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
39 | CITY2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
40 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
41 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
42 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
43 | REGION_IN_COUNTRY | CRMT_BU_REGION_IN_COUNTRY | CHAR7 | CHAR | 7 | 0 | Region by Country (for account address search) | ||
44 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
45 | HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
46 | STDADDR_ONLY | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
47 | .INCLUDE | 0 | 0 | Structure for Turkey Localization fields | |||||
48 | COUNTY | AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
49 | TOWNSHIP | AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
50 | .INCLUDE | 0 | 0 | BP Header Search: search by Roles | |||||
51 | ROLE | BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
52 | ROLECATEGORY | BU_PARTNERROLECAT | BU_ROLECAT | CHAR | 6 | 0 | BP Role Category | * | |
53 | EXCLUDEDROLE | BU_ROLE | BU_RLTYP | CHAR | 6 | 0 | BP role | * | |
54 | LIFECYCLESTAGE | BU_PARTNERROLE | BU_ROLE | CHAR | 6 | 0 | BP Role | * | |
55 | MAX_HIT | BU_MAXSEL | INT4 | 10 | 0 | Maximum number of selected entries | |||
56 | NO_TREX | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
57 | CATEGORY | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
58 | ALL_ADDRESS_VERSION | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
59 | FUZZY_SEARCH | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
60 | .INCLUDE | 0 | 0 | Search Structure Include CRM Part | |||||
61 | CUSTOMER_NO | CRMT_BSP_CUSTOMER_NUMBER | KUNNR | CHAR | 10 | 0 | ERP Customer Number of a Business Partner | * | |
62 | .INCLUDE | 0 | 0 | CRM BP Fragment Structure of the Sales Classification | |||||
63 | IS_COMPETITOR | CRMT_BU_IS_COMPETITOR | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is competitor | ||
64 | IS_PROSPECT | CRMT_BU_IS_PROSPECT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is a prospect | ||
65 | IS_CONSUMER | CRMT_BU_IS_CONSUMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is consumer | ||
66 | IS_CUSTOMER | CRMT_BU_IS_CUSTOMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is customer | ||
67 | CUSTOMER_SINCE | CRMT_CUSTOMER_SINCE | DATUM | DATS | 8 | 0 | Customer Since Date | ||
68 | IS_COD_CUSTOMER | CRMT_BU_IS_COD_CUSTOMER | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Business partner is cash on delivery customer | ||
69 | INDUSTRY | CRMT_INDUSTRY | CRM_INDUSTRY | CHAR | 4 | 0 | Industry Sector | CRMC_INDUSTRY | |
70 | IS_RENTED | CRMT_BU_IS_RENTED | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Rented Address | ||
71 | ACCOUNT_GROUP | CRMT_BU_ACCOUNT_GROUP | CRM_BU_ACCOUNT_GROUP | CHAR | 4 | 0 | R/3 Account Group | CRMC_T077D | |
72 | NIELSEN_ID | CRMT_BU_NIELSEN_ID | CRM_BU_NIELSEN_ID | CHAR | 2 | 0 | Nielsen ID | CRMC_NIELSEN | |
73 | CLASSIFIC | CRMT_BU_CUST_CLASSIFIC | CRM_BU_CUST_CLASSIFIC | CHAR | 2 | 0 | Customer Classification | CRMC_CLASSIF | |
74 | ATTRIBUTE | CRMT_BU_KATR1 | CRM_BU_KATR1 | CHAR | 2 | 0 | Attribute 1 | CRMC_ATTR01 | |
75 | ATTRIB_2 | CRMT_BU_KATR2 | CRM_BU_KATR2 | CHAR | 2 | 0 | Attribute 2 | CRMC_ATTR02 | |
76 | ATTRIB_3 | CRMT_BU_KATR3 | CRM_BU_KATR3 | CHAR | 2 | 0 | Attribute 3 | CRMC_ATTR03 | |
77 | ATTRIB_4 | CRMT_BU_KATR4 | CRM_BU_KATR4 | CHAR | 2 | 0 | Attribute 4 | CRMC_ATTR04 | |
78 | ATTRIB_5 | CRMT_BU_KATR5 | CRM_BU_KATR5 | CHAR | 2 | 0 | Attribute 5 | CRMC_ATTR05 | |
79 | ATTRIB_6 | CRMT_BU_KATR6 | CRM_BU_KATR6 | CHAR | 3 | 0 | Attribute 6 | CRMC_ATTR06 | |
80 | ATTRIB_7 | CRMT_BU_KATR7 | CRM_BU_KATR7 | CHAR | 3 | 0 | Attribute 7 | CRMC_ATTR07 | |
81 | ATTRIB_8 | CRMT_BU_KATR8 | CRM_BU_KATR8 | CHAR | 3 | 0 | Attribute 8 | CRMC_ATTR08 | |
82 | ATTRIB_9 | CRMT_BU_KATR9 | CRM_BU_KATR9 | CHAR | 3 | 0 | Attribute 9 | CRMC_ATTR09 | |
83 | ATTRIB_10 | CRMT_BU_KATR10 | CRM_BU_KATR10 | CHAR | 3 | 0 | Attribute 10 | CRMC_ATTR10 | |
84 | .INCLUDE | 0 | 0 | Search Criteria for BuilHeaderSearch | |||||
85 | OWNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
86 | OWNERLASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
87 | OWNERFIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
88 | CPLASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
89 | CPFIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
90 | VALID_DATE | BU_VALDT_SEARCH | DATUM | DATS | 8 | 0 | Selection Date for Search Helps | ||
91 | COMM_TYPE | AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | * | |
92 | RESP_AREA | CRMT_RESPONS_AREA | CRM_RESPONS_AREA | CHAR | 2 | 0 | Belonging to (Me, My Department, My Group) | ||
93 | ACCT_TEAM_FIRST_NAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
94 | ACCT_TEAM_LAST_NAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
95 | MARKETINGATTR | CRMT_BUPA_IL_MARKATTR_SEARCH | CRMT_BUPA_IL_MARKATTR_SEARCH | CHAR | 150 | 0 | Generic Search for Marketing Attributes | ||
96 | CLASS_ACCOUNT | CRMT_BUPA_IL_CLASS_SEARCH | CRMT_BUPA_IL_CLASS_SEARCH | CHAR | 130 | 0 | Generic Search for Classification | ||
97 | NO_EMP_FILTER | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
98 | USERNAME | SYUNAME | SYCHAR12 | CHAR | 12 | 0 | User Name | ||
99 | .INCLUDE | 0 | 0 | Business Partner: Search with ID | |||||
100 | IDTYPE | BU_ID_TYPE | BU_ID_TYPE | CHAR | 6 | 0 | Identification Type | * | |
101 | IDTYPE_DESCRIPTION | COMT_BU_ID_TYPE_DESCIPTION | BU_TEXT40 | CHAR | 40 | 0 | Identification Type | ||
102 | IDNUMBER | BU_ID_NUMBER | CHAR60 | CHAR | 60 | 0 | Identification Number | ||
103 | .INCLUDE | 0 | 0 | Relationship Category and Relationship Partner | |||||
104 | REL_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
105 | REL_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
106 | RELTYP | BU_RELTYP | BU_RELTYP | CHAR | 6 | 0 | Business Partner Relationship Category | * | |
107 | XRF | BU_XRF | XFELD | CHAR | 1 | 0 | Business partner role definition instead of BP relationship | ||
108 | .INCLUDE | 0 | 0 | Search Structure for Relationship Data (BP Header Search) | |||||
109 | RS_REL_TYP_DIRECTED | CRMT_BUPA_IL_RELTYP_SEARCH | CRMT_BUPA_IL_RELTYP_SEARCH | CHAR | 8 | 0 | Business Partner Relationship Category Including Direction | ||
110 | XDIRECTION | BU_XDIRECT | XFELD | CHAR | 1 | 0 | One-Way Business Partner Relationship Category | ||
111 | RS_REL_TYP | BU_RELTYP | BU_RELTYP | CHAR | 6 | 0 | Business Partner Relationship Category | * | |
112 | RS_PARTNER | COMT_BSP_REL_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Partner ID of Relationship | * | |
113 | RS_NAME1 | COMT_BSP_BP_NAME1 | BU_NAME | CHAR | 40 | 0 | Name 1 / Last Name (Search Help Field 1) | ||
114 | RS_NAME2 | COMT_BSP_BP_NAME2 | BU_NAME | CHAR | 40 | 0 | Name 2 / First Name (Search Help Field 2) | ||
115 | RS_ONLY_VALID | CRMT_BUPA_IL_FLAG_SET | CRM_BUPA_IL_FLAG_SET | CHAR | 1 | 0 | Specifies whether a flag is set or not set | ||
116 | .INCLUDE | 0 | 0 | Search Filter Key / Value Entries | |||||
117 | FILTER_KEY | CRMT_BUPA_IL_FILTER_KEY | CHAR4 | CHAR | 4 | 0 | Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
118 | FILTER_VALUE | CRMT_BUPA_IL_FILTER_VALUE | SYSUUID_C | CHAR | 32 | 0 | Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH | ||
119 | .INCLUDE | 0 | 0 | Search by Territory Management Criteria | |||||
120 | TERRITORY_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
121 | TERR_DESCRIPTION | CRMT_TERRITORY_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Territory Description | ||
122 | .INCLUDE | 0 | 0 | Search by qualification / responsibility | |||||
123 | QUALIFICATION | CHM_SEARCH_QUALIFICATION | CHM_SEARCH_QUALIFICATION | CHAR | 13 | 0 | CHM - Qualification Search (<QUALIFICATION>; <PROFICIENCY>) | ||
124 | RESPONSIBILITY | CHM_SEARCH_RESPONSIBILITY | CHM_SEARCH_RESPONSIBILITY | CHAR | 61 | 0 | CHM # Responsibility Search (<CIRTERIA>;<VALUE>) | ||
125 | .INCLUDE | 0 | 0 | Search Criteria for Marketing Permission | |||||
126 | MKTPERMCHANNEL | CRMT_BU_MKTPERM_CHAN | CRMT_BU_MKTPERM_CHAN | CHAR | 3 | 0 | Communication Channel | * | |
127 | MKTPERMCONSENT | CRMT_BU_MKTPERM_PERMISSION | CRMT_BU_MKTPERM_PERMISSION | NUMC | 3 | 0 | Consent | ||
128 | .INCLUDE | 0 | 0 | EEW Extension of BUT000 (Contains CI) | |||||
129 | BP_EEW_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
130 | .INCLUDE | 0 | 0 | ||||||
131 | .INCLUDE | 0 | 0 | AXT Extension for BuilHeader search structure | |||||
132 | BP_AXT_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
133 | .INCLUDE | 0 | 0 | BuilHeader search structure: Bank data | |||||
134 | BANK_KEY | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
135 | BANK_ACCT | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
136 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
137 | .INCLUDE | 0 | 0 | Internal Structure for Sales and Distribution Area | |||||
138 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
139 | CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
140 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
141 | ACCOUNT_STATUS | CRMT_BUPA_SEARCH_STATUS | CRMT_BUPA_SEARCH_STATUS | CHAR | 1 | 0 | Account and Contact Search Status | ||
142 | .INCLUDE | 0 | 0 | Structure for Partner Determination via CM Relations | |||||
143 | CP_PARTNER_ID | CRMT_CHM_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Channel Partner ID | * | |
144 | MY_PARTNERS | CRMT_CHM_MY_PARTNERS | CHAR | 1 | 0 | My Channel Partners | |||
145 | CP_CLASSIFICATION | CHM_SEARCH_CLASSIFICATION | CHM_SEARCH_CLASSIFICATION | CHAR | 9 | 0 | CHM - Classification Search ( <TYPE>;<PROGRAM>) | ||
146 | CP_STATUS | CHM_PARTNER_STATUS | CHM_PARTNER_STATUS | CHAR | 4 | 0 | Channel Management - Channel Partner Status | * | |
147 | SEARCH_OBJECT | CRMT_CHM_PM_SEARCH_OBJECT | CRM_PM_SEARCH_TYPE | CHAR | 1 | 0 | CHM Partner Management Search Object | ||
148 | IS_SEARCH_HELP | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag |
Foreign Keys
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 510 |