SAP ABAP Table CRMS_ICM_BP_IL_HEADER_SEARCH (ICM BP search attributes)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-IPS-ICM-BP (Application Component) Business Partners
     CRM_ICM_BOL_BP (Package) CRM ICM: BOL Objects for Business partner
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_ICM_BP_IL_HEADER_SEARCH   Table Relationship Diagram
Short Description ICM BP search attributes    
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   ICM BP Search Attributes  
2 MARST BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner *
3 GENDER CRM_ICM_BU_GENDER BU_SEXID CHAR 1   0   Gender  
4 NATIO BU_NATIO LAND1 CHAR 3   0   Nationality *
5 BIRTHNM BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
6 NAMEMID BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
7 NAME CRM_ICM_BU_NAME BU_NAME CHAR 40   0   Business Partner Name  
8 OTHERNAME CRM_ICM_BU_FURTHER_NAME BU_NAME CHAR 40   0   Other Name  
9 RELIGION KONFE KONFE CHAR 2   0   Religious Denomination Key *
10 RELI_GRP_ID CRM_ICM_RELI_GRPID CRM_ICM_RELI_GRPID CHAR 3   0   Religion ID  
11 ETHNICITY_ID CRM_ICM_ETH_ID CRM_ICM_ETH_ID CHAR 3   0   Ethnicity ID  
12 BIRTH_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
13 UNKNOWN_PERSON CRM_ICM_BP_FLAG FLAG CHAR 1   0   ICM BP Flag  
14 ICM_PROF_STATUS CRM_ICM_BP_PROF_STATUS CRM_ICM_BP_PROF_STATUS NUMC 2   0   Status  
15 ICM_PROF_CLASS_ID CRM_ICM_BP_PROF_CAT_SC_ID CRM_ICM_BP_PROF_CHAR40 CHAR 40   0   ICM Business Partner Profiles category model  
16 ICM_PROF_OB_DATE CRM_ICM_BP_PROF_OB_DATE CRM_ICM_DATE DATS 8   0   Observation Date  
17 .INCLUDE       0   0   ICM BP AID Search Attributes  
18 ICM_AID_NAME CRM_ICM_BP_AID_NAME TEXT80 CHAR 80   0   ICM BP Alternative Identity - Name (Other name or Last name)  
19 ICM_AID_FIRST_NAME CRM_ICM_BP_AID_NAME TEXT80 CHAR 80   0   ICM BP Alternative Identity - Name (Other name or Last name)  
20 ICM_AID_MIDDLE_NAME CRM_ICM_BP_AID_NAME TEXT80 CHAR 80   0   ICM BP Alternative Identity - Name (Other name or Last name)  
21 ICM_AID_GENDER BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
22 ICM_AID_BIRTH_DATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
23 ICM_AID_BIRTH_COUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule *
24 ICM_AID_NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
25 ICM_AID_BIRTH_NAME CRM_ICM_BP_AID_NAME TEXT80 CHAR 80   0   ICM BP Alternative Identity - Name (Other name or Last name)  
26 ICM_AID_OBSERVATION_DATE CRM_ICM_BP_AID_DATE DATUM DATS 8   0   ICM BP Alternative Identity - Observation Date  
27 .INCLUDE       0   0   ICM BP Description Search Attributes  
28 OBSERVATION_DATE CRMT_ICM_OBSERVATION_DATE DATUM DATS 8   0   Observation Date  
29 STATUS CRMT_ICM_STATUS CRM_ICM_BP_AID_STATUS CHAR 1   0   Status  
30 HAIR_COLOR CRMT_ICM_HAIR_COLOR CRMT_ICM_GENKEY CHAR 3   0   Hair Color *
31 EYE_COLOR CRMT_ICM_EYE_COLOR CRMT_ICM_GENKEY CHAR 3   0   Eye Color *
32 FAC_HAIR_STYLE CRMT_ICM_FACIAL_HAIR_STYLE CRMT_ICM_GENKEY CHAR 3   0   Facial Hair Style *
33 SKIN CRMT_ICM_SKIN CRMT_ICM_GENKEY CHAR 3   0   Skin *
34 BUILD CRMT_ICM_BUILD CRMT_ICM_GENKEY CHAR 3   0   Build *
35 GLASSES_STYLE CRMT_ICM_GLASSES_STYLE CRMT_ICM_GENKEY CHAR 3   0   Glasses Style *
36 GENDER_DESC CRMT_ICM_GENDER CRMT_ICM_GENKEY CHAR 3   0   Gender *
37 VOICE_TYPE CRMT_ICM_VOICE_TYPE CRMT_ICM_GENKEY CHAR 3   0   Voice Type *
38 VOICE_STYLE CRMT_ICM_VOICE_STYLE CRMT_ICM_GENKEY CHAR 3   0   Voice Style *
39 VOICE_ACCENT CRMT_ICM_VOICE_ACCENT CRMT_ICM_GENKEY CHAR 3   0   Voice Accent *
40 SHOE_SIZE CRMT_ICM_SHOE_SIZE MENG13 QUAN 13   3   Shoe Size  
41 SHOE_SIZE_UNIT CRMT_ICM_SHOE_SIZE_UNIT MEINS UNIT 3   0   Shoe Size Unit T006
42 AGE CRMT_ICM_AGE_MAX MENG13 QUAN 13   3   Age (max.)  
43 AGE_MIN CRMT_ICM_AGE_MIN MENG13 QUAN 13   3   Age (min.)  
44 AGE_MAX CRMT_ICM_AGE_MAX MENG13 QUAN 13   3   Age (max.)  
45 AGE_UNIT CRMT_ICM_AGE_UNIT MEINS UNIT 3   0   Age Unit T006
46 HEIGHT CRMT_ICM_HEIGHT_MAX MENG13 QUAN 13   3   Height (max.)  
47 HEIGHT_MIN CRMT_ICM_HEIGHT_MIN MENG13 QUAN 13   3   Height (min.)  
48 HEIGHT_MAX CRMT_ICM_HEIGHT_MAX MENG13 QUAN 13   3   Height (max.)  
49 HEIGHT_UNIT CRMT_ICM_HEIGHT_UNIT MEINS UNIT 3   0   Height Unit T006
50 WEIGHT CRMT_ICM_WEIGHT_MAX MENG13 QUAN 13   3   Weight (max.)  
51 WEIGHT_MIN CRMT_ICM_WEIGHT_MIN MENG13 QUAN 13   3   Weight (min.)  
52 WEIGHT_MAX CRMT_ICM_WEIGHT_MAX MENG13 QUAN 13   3   Weight (max.)  
53 WEIGHT_UNIT CRMT_ICM_WEIGHT_UNIT MEINS UNIT 3   0   Weight Unit T006
54 .INCLUDE       0   0   Extensibility include for ICM BP: Description of Person  
55 CRM_ICM_BP_DESC DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
56 .INCLUDE       0   0   ICM BP Header Extension (Easy Enhancement structure)  
57 CRM_ICM_BP_HEAD DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
58 .INCLUDE       0   0   Search Structure of Search Object BuilHeaderSearch  
59 .INCLUDE       0   0   BuPa Search: criteria for SEARCH_BY_BP_GENERAL (serv. class)  
60 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
61 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
62 SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
63 SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
64 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types *
65 XDELE CRMT_BUPA_IL_FLAG_SET CRM_BUPA_IL_FLAG_SET CHAR 1   0   Specifies whether a flag is set or not set  
66 XBLCK CRMT_BUPA_IL_FLAG_SET CRM_BUPA_IL_FLAG_SET CHAR 1   0   Specifies whether a flag is set or not set  
67 CONTACT BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
68 NOT_RELEASED CRMT_BUPA_IL_FLAG_SET CRM_BUPA_IL_FLAG_SET CHAR 1   0   Specifies whether a flag is set or not set  
69 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
70 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
71 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
72 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
73 LEGAL_ORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
74 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
75 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
76 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
77 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
78 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
79 MC_NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
80 MC_NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
81 CREATION_USER BU_CRUSR USNAM CHAR 12   0   User who created the object  
82 CREATION_DATE BU_CRDAT DATUM DATS 8   0   Date on which the object was created  
83 CHANGE_USER BU_CHUSR USNAM CHAR 12   0   Last user to change object  
84 CHANGE_DATE BU_CHDAT DATUM DATS 8   0   Date when object was last changed  
85 PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
86 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
87 .INCLUDE       0   0   Search Structure for Communication Data (BP Header Search)  
88 TELEPHONE AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
89 COUNTRY_FOR_TEL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
90 FAX AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
91 COUNTRY_FOR_FAX AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
92 EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
93 URL AD_URI2 CHAR50 CHAR 50   0   URI address search field  
94 .INCLUDE       0   0   Structure for Search for BP address in CRM (lowercase)  
95 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
96 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
97 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
98 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
99 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
100 REGION_IN_COUNTRY CRMT_BU_REGION_IN_COUNTRY CHAR7 CHAR 7   0   Region by Country (for account address search)  
101 STREET AD_STREET TEXT60 CHAR 60   0   Street  
102 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
103 STDADDR_ONLY CRMT_BUPA_IL_FLAG_SET CRM_BUPA_IL_FLAG_SET CHAR 1   0   Specifies whether a flag is set or not set  
104 .INCLUDE       0   0   Structure for Turkey Localization fields  
105 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
106 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
107 .INCLUDE       0   0   BP Header Search: search by Roles  
108 ROLE BU_ROLE BU_RLTYP CHAR 6   0   BP role *
109 ROLECATEGORY BU_PARTNERROLECAT BU_ROLECAT CHAR 6   0   BP Role Category *
110 EXCLUDEDROLE BU_ROLE BU_RLTYP CHAR 6   0   BP role *
111 LIFECYCLESTAGE BU_PARTNERROLE BU_ROLE CHAR 6   0   BP Role *
112 MAX_HIT BU_MAXSEL   INT4 10   0   Maximum number of selected entries  
113 NO_TREX CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
114 CATEGORY BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
115 ALL_ADDRESS_VERSION CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
116 FUZZY_SEARCH CRMT_BUPA_IL_FLAG_SET CRM_BUPA_IL_FLAG_SET CHAR 1   0   Specifies whether a flag is set or not set  
117 .INCLUDE       0   0   Search Structure Include CRM Part  
118 CUSTOMER_NO CRMT_BSP_CUSTOMER_NUMBER KUNNR CHAR 10   0   ERP Customer Number of a Business Partner *
119 .INCLUDE       0   0   CRM BP Fragment Structure of the Sales Classification  
120 IS_COMPETITOR CRMT_BU_IS_COMPETITOR CRM_BOOLEAN CHAR 1   0   Indicator: Business partner is competitor  
121 IS_PROSPECT CRMT_BU_IS_PROSPECT CRM_BOOLEAN CHAR 1   0   Indicator: Business partner is a prospect  
122 IS_CONSUMER CRMT_BU_IS_CONSUMER CRM_BOOLEAN CHAR 1   0   Indicator: Business partner is consumer  
123 IS_CUSTOMER CRMT_BU_IS_CUSTOMER CRM_BOOLEAN CHAR 1   0   Indicator: Business partner is customer  
124 CUSTOMER_SINCE CRMT_CUSTOMER_SINCE DATUM DATS 8   0   Customer Since Date  
125 IS_COD_CUSTOMER CRMT_BU_IS_COD_CUSTOMER CRM_BOOLEAN CHAR 1   0   Indicator: Business partner is cash on delivery customer  
126 INDUSTRY CRMT_INDUSTRY CRM_INDUSTRY CHAR 4   0   Industry Sector CRMC_INDUSTRY
127 IS_RENTED CRMT_BU_IS_RENTED CRM_BOOLEAN CHAR 1   0   Indicator: Rented Address  
128 ACCOUNT_GROUP CRMT_BU_ACCOUNT_GROUP CRM_BU_ACCOUNT_GROUP CHAR 4   0   R/3 Account Group CRMC_T077D
129 NIELSEN_ID CRMT_BU_NIELSEN_ID CRM_BU_NIELSEN_ID CHAR 2   0   Nielsen ID CRMC_NIELSEN
130 CLASSIFIC CRMT_BU_CUST_CLASSIFIC CRM_BU_CUST_CLASSIFIC CHAR 2   0   Customer Classification CRMC_CLASSIF
131 ATTRIBUTE CRMT_BU_KATR1 CRM_BU_KATR1 CHAR 2   0   Attribute 1 CRMC_ATTR01
132 ATTRIB_2 CRMT_BU_KATR2 CRM_BU_KATR2 CHAR 2   0   Attribute 2 CRMC_ATTR02
133 ATTRIB_3 CRMT_BU_KATR3 CRM_BU_KATR3 CHAR 2   0   Attribute 3 CRMC_ATTR03
134 ATTRIB_4 CRMT_BU_KATR4 CRM_BU_KATR4 CHAR 2   0   Attribute 4 CRMC_ATTR04
135 ATTRIB_5 CRMT_BU_KATR5 CRM_BU_KATR5 CHAR 2   0   Attribute 5 CRMC_ATTR05
136 ATTRIB_6 CRMT_BU_KATR6 CRM_BU_KATR6 CHAR 3   0   Attribute 6 CRMC_ATTR06
137 ATTRIB_7 CRMT_BU_KATR7 CRM_BU_KATR7 CHAR 3   0   Attribute 7 CRMC_ATTR07
138 ATTRIB_8 CRMT_BU_KATR8 CRM_BU_KATR8 CHAR 3   0   Attribute 8 CRMC_ATTR08
139 ATTRIB_9 CRMT_BU_KATR9 CRM_BU_KATR9 CHAR 3   0   Attribute 9 CRMC_ATTR09
140 ATTRIB_10 CRMT_BU_KATR10 CRM_BU_KATR10 CHAR 3   0   Attribute 10 CRMC_ATTR10
141 .INCLUDE       0   0   Search Criteria for BuilHeaderSearch  
142 OWNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
143 OWNERLASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
144 OWNERFIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
145 CPLASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
146 CPFIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
147 VALID_DATE BU_VALDT_SEARCH DATUM DATS 8   0   Selection Date for Search Helps  
148 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
149 RESP_AREA CRMT_RESPONS_AREA CRM_RESPONS_AREA CHAR 2   0   Belonging to (Me, My Department, My Group)  
150 ACCT_TEAM_FIRST_NAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
151 ACCT_TEAM_LAST_NAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
152 MARKETINGATTR CRMT_BUPA_IL_MARKATTR_SEARCH CRMT_BUPA_IL_MARKATTR_SEARCH CHAR 150   0   Generic Search for Marketing Attributes  
153 CLASS_ACCOUNT CRMT_BUPA_IL_CLASS_SEARCH CRMT_BUPA_IL_CLASS_SEARCH CHAR 130   0   Generic Search for Classification  
154 NO_EMP_FILTER CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
155 USERNAME SYUNAME SYCHAR12 CHAR 12   0   User Name  
156 .INCLUDE       0   0   Business Partner: Search with ID  
157 IDTYPE BU_ID_TYPE BU_ID_TYPE CHAR 6   0   Identification Type *
158 IDTYPE_DESCRIPTION COMT_BU_ID_TYPE_DESCIPTION BU_TEXT40 CHAR 40   0   Identification Type  
159 IDNUMBER BU_ID_NUMBER CHAR60 CHAR 60   0   Identification Number  
160 .INCLUDE       0   0   Relationship Category and Relationship Partner  
161 REL_PARTNER1 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
162 REL_PARTNER2 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
163 RELTYP BU_RELTYP BU_RELTYP CHAR 6   0   Business Partner Relationship Category *
164 XRF BU_XRF XFELD CHAR 1   0   Business partner role definition instead of BP relationship  
165 .INCLUDE       0   0   Search Structure for Relationship Data (BP Header Search)  
166 RS_REL_TYP_DIRECTED CRMT_BUPA_IL_RELTYP_SEARCH CRMT_BUPA_IL_RELTYP_SEARCH CHAR 8   0   Business Partner Relationship Category Including Direction  
167 XDIRECTION BU_XDIRECT XFELD CHAR 1   0   One-Way Business Partner Relationship Category  
168 RS_REL_TYP BU_RELTYP BU_RELTYP CHAR 6   0   Business Partner Relationship Category *
169 RS_PARTNER COMT_BSP_REL_PARTNER BU_PARTNER CHAR 10   0   Partner ID of Relationship *
170 RS_NAME1 COMT_BSP_BP_NAME1 BU_NAME CHAR 40   0   Name 1 / Last Name (Search Help Field 1)  
171 RS_NAME2 COMT_BSP_BP_NAME2 BU_NAME CHAR 40   0   Name 2 / First Name (Search Help Field 2)  
172 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  
173 .INCLUDE       0   0   Search Filter Key / Value Entries  
174 FILTER_KEY CRMT_BUPA_IL_FILTER_KEY CHAR4 CHAR 4   0   Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH  
175 FILTER_VALUE CRMT_BUPA_IL_FILTER_VALUE SYSUUID_C CHAR 32   0   Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH  
176 .INCLUDE       0   0   Search by Territory Management Criteria  
177 TERRITORY_ID CRMT_TERRITORY_ID CRM_TERRITORY_ID CHAR 30   0   Territory ID  
178 TERR_DESCRIPTION CRMT_TERRITORY_DESCRIPTION TEXT40 CHAR 40   0   Territory Description  
179 .INCLUDE       0   0   Search by qualification / responsibility  
180 QUALIFICATION CHM_SEARCH_QUALIFICATION CHM_SEARCH_QUALIFICATION CHAR 13   0   CHM - Qualification Search (<QUALIFICATION>; <PROFICIENCY>)  
181 RESPONSIBILITY CHM_SEARCH_RESPONSIBILITY CHM_SEARCH_RESPONSIBILITY CHAR 61   0   CHM # Responsibility Search (<CIRTERIA>;<VALUE>)  
182 .INCLUDE       0   0   Search Criteria for Marketing Permission  
183 MKTPERMCHANNEL CRMT_BU_MKTPERM_CHAN CRMT_BU_MKTPERM_CHAN CHAR 3   0   Communication Channel *
184 MKTPERMCONSENT CRMT_BU_MKTPERM_PERMISSION CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent  
185 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
186 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
187 .INCLUDE       0   0    
188 .INCLUDE       0   0   AXT Extension for BuilHeader search structure  
189 BP_AXT_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
190 .INCLUDE       0   0   BuilHeader search structure: Bank data  
191 BANK_KEY BANKK BANKK CHAR 15   0   Bank Keys  
192 BANK_ACCT BANKN BANKN CHAR 18   0   Bank account number  
193 IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
194 .INCLUDE       0   0   Internal Structure for Sales and Distribution Area  
195 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
196 CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
197 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
198 ACCOUNT_STATUS CRMT_BUPA_SEARCH_STATUS CRMT_BUPA_SEARCH_STATUS CHAR 1   0   Account and Contact Search Status  
199 .INCLUDE       0   0   ICM Combined Search Attributes  
200 LOCATION_COMB CRM_ICM_IL_REL_LOC_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Locations  
201 CASE_COMB CRM_ICM_IL_REL_CMG_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Cases  
202 LEAD_COMB CRM_ICM_IL_REL_LEAD_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Leads  
203 INCIDENT_COMB CRM_ICM_IL_REL_INC_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Incidents  
204 BP_COMB CRM_ICM_IL_REL_BP_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Business Partners  
205 OBJECT_COMB CRM_ICM_IL_REL_OBJ_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Objects  
206 OPERATION_COMB CRM_ICM_IL_REL_ACT_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search for Related Activities  
207 STAFF_UNITS_COMB CRM_ICM_IL_REL_SFU_SEARCH CRM_ICM_IL_REL_COMB_SEARCH CHAR 130   0   ICM Combined Search Field for Staff and Units  
208 REL_TYPE_ID CRM_ICM_REL_TYPE_ID   CHAR 4   0   CRM ICM Relationship Type ID  
209 REL_VALID_FROM CRM_ICM_REL_DATE SYDATS DATS 8   0   ICM Relationship: Dates  
210 REL_VALID_TO CRM_ICM_REL_DATE SYDATS DATS 8   0   ICM Relationship: Dates  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMS_ICM_BP_IL_HEADER_SEARCH ACCOUNT_GROUP CRMC_T077D ACCOUNT_GROUP REF C CN
2 CRMS_ICM_BP_IL_HEADER_SEARCH AGE_UNIT T006 MSEHI REF 1 CN
3 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIBUTE CRMC_ATTR01 ATTRIBUTE REF C CN
4 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_10 CRMC_ATTR10 ATTRIB_10 REF C CN
5 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_2 CRMC_ATTR02 ATTRIB_2 REF C CN
6 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_3 CRMC_ATTR03 ATTRIB_3 REF C CN
7 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_4 CRMC_ATTR04 ATTRIB_4 REF C CN
8 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_5 CRMC_ATTR05 ATTRIB_5 REF C CN
9 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_6 CRMC_ATTR06 ATTRIB_6 REF C CN
10 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_7 CRMC_ATTR07 ATTRIB_7 REF C CN
11 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_8 CRMC_ATTR08 ATTRIB_8 REF C CN
12 CRMS_ICM_BP_IL_HEADER_SEARCH ATTRIB_9 CRMC_ATTR09 ATTRIB_9 REF C CN
13 CRMS_ICM_BP_IL_HEADER_SEARCH CLASSIFIC CRMC_CLASSIF CLASSIFIC REF C CN
14 CRMS_ICM_BP_IL_HEADER_SEARCH COUNTRY T005 LAND1 REF 1 CN
15 CRMS_ICM_BP_IL_HEADER_SEARCH HEIGHT_UNIT T006 MSEHI REF 1 CN
16 CRMS_ICM_BP_IL_HEADER_SEARCH INDUSTRY CRMC_INDUSTRY INDUSTRY REF C CN
17 CRMS_ICM_BP_IL_HEADER_SEARCH NIELSEN_ID CRMC_NIELSEN NIELSEN_ID REF C CN
18 CRMS_ICM_BP_IL_HEADER_SEARCH REGION T005S BLAND REF C CN
19 CRMS_ICM_BP_IL_HEADER_SEARCH SHOE_SIZE_UNIT T006 MSEHI REF 1 CN
20 CRMS_ICM_BP_IL_HEADER_SEARCH WEIGHT_UNIT T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20141013 
SAP Release Created in 700