SAP ABAP Table CRMS_ICM_BP_SEARCH_ENH (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_SEARCH_ENH	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	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
2	GENDER	☐	CRM_ICM_BU_GENDER	BU_SEXID	CHAR	1	0	Gender
3	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
4	BIRTHNM	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
5	NAMEMID	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
6	NAME	☐	CRM_ICM_BU_NAME	BU_NAME	CHAR	40	0	Business Partner Name
7	OTHERNAME	☐	CRM_ICM_BU_FURTHER_NAME	BU_NAME	CHAR	40	0	Other Name
8	RELIGION	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
9	RELI_GRP_ID	☐	CRM_ICM_RELI_GRPID	CRM_ICM_RELI_GRPID	CHAR	3	0	Religion ID
10	ETHNICITY_ID	☐	CRM_ICM_ETH_ID	CRM_ICM_ETH_ID	CHAR	3	0	Ethnicity ID
11	BIRTH_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	UNKNOWN_PERSON	☐	CRM_ICM_BP_FLAG	FLAG	CHAR	1	0	ICM BP Flag
13	ICM_PROF_STATUS	☐	CRM_ICM_BP_PROF_STATUS	CRM_ICM_BP_PROF_STATUS	NUMC	2	0	Status
14	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
15	ICM_PROF_OB_DATE	☐	CRM_ICM_BP_PROF_OB_DATE	CRM_ICM_DATE	DATS	8	0	Observation Date
16	.INCLUDE	☐				0	0	ICM BP AID Search Attributes
17	ICM_AID_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
18	ICM_AID_FIRST_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
19	ICM_AID_MIDDLE_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
20	ICM_AID_GENDER	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
21	ICM_AID_BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
22	ICM_AID_BIRTH_COUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
23	ICM_AID_NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
24	ICM_AID_BIRTH_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
25	ICM_AID_OBSERVATION_DATE	☐	CRM_ICM_BP_AID_DATE	DATUM	DATS	8	0	ICM BP Alternative Identity - Observation Date
26	.INCLUDE	☐				0	0	ICM BP Description Search Attributes
27	OBSERVATION_DATE	☐	CRMT_ICM_OBSERVATION_DATE	DATUM	DATS	8	0	Observation Date
28	STATUS	☐	CRMT_ICM_STATUS	CRM_ICM_BP_AID_STATUS	CHAR	1	0	Status
29	HAIR_COLOR	☐	CRMT_ICM_HAIR_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Hair Color	*
30	EYE_COLOR	☐	CRMT_ICM_EYE_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Eye Color	*
31	FAC_HAIR_STYLE	☐	CRMT_ICM_FACIAL_HAIR_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Facial Hair Style	*
32	SKIN	☐	CRMT_ICM_SKIN	CRMT_ICM_GENKEY	CHAR	3	0	Skin	*
33	BUILD	☐	CRMT_ICM_BUILD	CRMT_ICM_GENKEY	CHAR	3	0	Build	*
34	GLASSES_STYLE	☐	CRMT_ICM_GLASSES_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Glasses Style	*
35	GENDER_DESC	☐	CRMT_ICM_GENDER	CRMT_ICM_GENKEY	CHAR	3	0	Gender	*
36	VOICE_TYPE	☐	CRMT_ICM_VOICE_TYPE	CRMT_ICM_GENKEY	CHAR	3	0	Voice Type	*
37	VOICE_STYLE	☐	CRMT_ICM_VOICE_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Voice Style	*
38	VOICE_ACCENT	☐	CRMT_ICM_VOICE_ACCENT	CRMT_ICM_GENKEY	CHAR	3	0	Voice Accent	*
39	SHOE_SIZE	☐	CRMT_ICM_SHOE_SIZE	MENG13	QUAN	13	3	Shoe Size
40	SHOE_SIZE_UNIT	☐	CRMT_ICM_SHOE_SIZE_UNIT	MEINS	UNIT	3	0	Shoe Size Unit	T006
41	AGE	☐	CRMT_ICM_AGE_MAX	MENG13	QUAN	13	3	Age (max.)
42	AGE_MIN	☐	CRMT_ICM_AGE_MIN	MENG13	QUAN	13	3	Age (min.)
43	AGE_MAX	☐	CRMT_ICM_AGE_MAX	MENG13	QUAN	13	3	Age (max.)
44	AGE_UNIT	☐	CRMT_ICM_AGE_UNIT	MEINS	UNIT	3	0	Age Unit	T006
45	HEIGHT	☐	CRMT_ICM_HEIGHT_MAX	MENG13	QUAN	13	3	Height (max.)
46	HEIGHT_MIN	☐	CRMT_ICM_HEIGHT_MIN	MENG13	QUAN	13	3	Height (min.)
47	HEIGHT_MAX	☐	CRMT_ICM_HEIGHT_MAX	MENG13	QUAN	13	3	Height (max.)
48	HEIGHT_UNIT	☐	CRMT_ICM_HEIGHT_UNIT	MEINS	UNIT	3	0	Height Unit	T006
49	WEIGHT	☐	CRMT_ICM_WEIGHT_MAX	MENG13	QUAN	13	3	Weight (max.)
50	WEIGHT_MIN	☐	CRMT_ICM_WEIGHT_MIN	MENG13	QUAN	13	3	Weight (min.)
51	WEIGHT_MAX	☐	CRMT_ICM_WEIGHT_MAX	MENG13	QUAN	13	3	Weight (max.)
52	WEIGHT_UNIT	☐	CRMT_ICM_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	T006
53	.INCLUDE	☐				0	0	Extensibility include for ICM BP: Description of Person
54	CRM_ICM_BP_DESC	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
55	.INCLUDE	☐				0	0	ICM BP Header Extension (Easy Enhancement structure)
56	CRM_ICM_BP_HEAD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_ICM_BP_SEARCH_ENH	AGE_UNIT	T006	MSEHI	REF	1	CN
2	CRMS_ICM_BP_SEARCH_ENH	HEIGHT_UNIT	T006	MSEHI	REF	1	CN
3	CRMS_ICM_BP_SEARCH_ENH	SHOE_SIZE_UNIT	T006	MSEHI	REF	1	CN
4	CRMS_ICM_BP_SEARCH_ENH	WEIGHT_UNIT	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	700