SAP ABAP Table CRMM_ICM_BP_DESC (ICM: Business Partner: Personal Description)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS-ICM-BP (Application Component) Business Partners
     ⤷ CRM_ICM_BP_APP_PS (Package) CRM ICM: Business Partner - Application

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMM_ICM_BP_DESC	Table Relationship Diagram
Short Description	ICM: Business Partner: Personal Description

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DESC_GUID	☑	GUID		RAW	16	0	Globally Unique Identifier
3	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	.INCLUDE	☐				0	0	ICM: Business Partner: Personal Description
5	.INCLUDE	☐				0	0	Management Data for Data Records of a Table
6	CREATED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
7	CHANGED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
8	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	CHANGED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	.INCLUDE	☐				0	0	BP Source of Info DB Attributes
11	ICM_ACT_GD	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
12	ICM_RES_AG	☐	CRM_ICM_BP_PROF_RESP_AGENCY	BU_PARTNER	CHAR	10	0	Responsible Agency	*
13	OBSERVATION_DATE	☐	CRMT_ICM_OBSERVATION_DATE	DATUM	DATS	8	0	Observation Date
14	STATUS	☐	CRMT_ICM_STATUS	CRM_ICM_BP_AID_STATUS	CHAR	1	0	Status	*
15	SKIN	☐	CRMT_ICM_SKIN	CRMT_ICM_GENKEY	CHAR	3	0	Skin	CRMC_ICM_VALUES
16	HEIGHT_MIN	☐	CRMT_ICM_HEIGHT_MIN	MENG13	QUAN	13	3	Height (min.)
17	HEIGHT_MAX	☐	CRMT_ICM_HEIGHT_MAX	MENG13	QUAN	13	3	Height (max.)
18	HEIGHT_UNIT	☐	CRMT_ICM_HEIGHT_UNIT	MEINS	UNIT	3	0	Height Unit	T006
19	WEIGHT_MIN	☐	CRMT_ICM_WEIGHT_MIN	MENG13	QUAN	13	3	Weight (min.)
20	WEIGHT_MAX	☐	CRMT_ICM_WEIGHT_MAX	MENG13	QUAN	13	3	Weight (max.)
21	WEIGHT_UNIT	☐	CRMT_ICM_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	T006
22	BUILD	☐	CRMT_ICM_BUILD	CRMT_ICM_GENKEY	CHAR	3	0	Build	CRMC_ICM_VALUES
23	DISABILITY_TYPE	☐	CRMT_ICM_DISABILITY_TYPE	CRM_BOOLEAN	CHAR	1	0	Disability Type
24	SHOE_SIZE	☐	CRMT_ICM_SHOE_SIZE	MENG13	QUAN	13	3	Shoe Size
25	SHOE_SIZE_UNIT	☐	CRMT_ICM_SHOE_SIZE_UNIT	MEINS	UNIT	3	0	Shoe Size Unit	T006
26	PHENOTYPE	☐	CRMT_ICM_PHENOTYPE	CRMT_ICM_GENKEY	CHAR	3	0	Phenotype	CRMC_ICM_VALUES
27	AGE_MIN	☐	CRMT_ICM_AGE_MIN	MENG13	QUAN	13	3	Age (min.)
28	AGE_MAX	☐	CRMT_ICM_AGE_MAX	MENG13	QUAN	13	3	Age (max.)
29	AGE_UNIT	☐	CRMT_ICM_AGE_UNIT	MEINS	UNIT	3	0	Age Unit	T006
30	VOICE_TYPE	☐	CRMT_ICM_VOICE_TYPE	CRMT_ICM_GENKEY	CHAR	3	0	Voice Type	CRMC_ICM_VALUES
31	VOICE_STYLE	☐	CRMT_ICM_VOICE_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Voice Style	CRMC_ICM_VALUES
32	VOICE_ACCENT	☐	CRMT_ICM_VOICE_ACCENT	CRMT_ICM_GENKEY	CHAR	3	0	Voice Accent	CRMC_ICM_VALUES
33	GENDER	☐	CRMT_ICM_GENDER	CRMT_ICM_GENKEY	CHAR	3	0	Gender	CRMC_ICM_VALUES
34	EYE_COLOR	☐	CRMT_ICM_EYE_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Eye Color	CRMC_ICM_VALUES
35	EYE_SIZE	☐	CRMT_ICM_EYE_SIZE	CRMT_ICM_GENKEY	CHAR	3	0	Eye Size	CRMC_ICM_VALUES
36	EYE_SHAPE	☐	CRMT_ICM_EYE_SHAPE	CRMT_ICM_GENKEY	CHAR	3	0	Eye Shape	CRMC_ICM_VALUES
37	EYEBROW_STYLE	☐	CRMT_ICM_EYEBROW_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Eyebrow Style	CRMC_ICM_VALUES
38	EYEBROW_COLOR	☐	CRMT_ICM_EYEBROW_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Eyebrow Color	CRMC_ICM_VALUES
39	GLASSES_STYLE	☐	CRMT_ICM_GLASSES_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Glasses Style	CRMC_ICM_VALUES
40	CONTACT_LENSES	☐	CRMT_ICM_CONTACT_LENSES	CRMT_ICM_GENKEY	CHAR	3	0	Contact Lenses	CRMC_ICM_VALUES
41	HAIR_COLOR	☐	CRMT_ICM_HAIR_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Hair Color	CRMC_ICM_VALUES
42	EAR_SHAPE	☐	CRMT_ICM_EAR_SHAPE	CRMT_ICM_GENKEY	CHAR	3	0	Ear Shape	CRMC_ICM_VALUES
43	EAR_SIZE	☐	CRMT_ICM_EAR_SIZE	CRMT_ICM_GENKEY	CHAR	3	0	Ear Size	CRMC_ICM_VALUES
44	FACE_SHAPE	☐	CRMT_ICM_FACE_SHAPE	CRMT_ICM_GENKEY	CHAR	3	0	Face Shape	CRMC_ICM_VALUES
45	FACE_TYPE	☐	CRMT_ICM_FACE_TYPE	CRMT_ICM_GENKEY	CHAR	3	0	Face Type	CRMC_ICM_VALUES
46	FACE_LENGTH	☐	CRMT_ICM_FACE_LENGTH	CRMT_ICM_GENKEY	CHAR	3	0	Face Length	CRMC_ICM_VALUES
47	FACE_FEATURE	☐	CRMT_ICM_FACE_FEATURE	CRMT_ICM_GENKEY	CHAR	3	0	Face Feature	CRMC_ICM_VALUES
48	CHIN_TYPE	☐	CRMT_ICM_CHIN_TYPE	CRMT_ICM_GENKEY	CHAR	3	0	Chin Type	CRMC_ICM_VALUES
49	CHIN_SHAPE	☐	CRMT_ICM_CHIN_SHAPE	CRMT_ICM_GENKEY	CHAR	3	0	Chin Shape	CRMC_ICM_VALUES
50	FAC_HAIR_STYLE	☐	CRMT_ICM_FACIAL_HAIR_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Facial Hair Style	CRMC_ICM_VALUES
51	FAC_HAIR_COLOR	☐	CRMT_ICM_FACIAL_HAIR_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Facial Hair Color	CRMC_ICM_VALUES
52	PIERCING	☐	CRMT_ICM_PIERCING	CRMT_ICM_GENKEY	CHAR	3	0	Piercing	CRMC_ICM_VALUES
53	HAIR_LENGTH	☐	CRMT_ICM_HAIR_LENGTH	CRMT_ICM_GENKEY	CHAR	3	0	Hair Length	CRMC_ICM_VALUES
54	HAIR_STYLE	☐	CRMT_ICM_HAIR_STYLE	CRMT_ICM_GENKEY	CHAR	3	0	Hair Style	CRMC_ICM_VALUES
55	HAIR_STATUS	☐	CRMT_ICM_HAIR_STATUS	CRMT_ICM_GENKEY	CHAR	3	0	Hair Status	CRMC_ICM_VALUES
56	TEETH_TYPE	☐	CRMT_ICM_TEETH_TYPE	CRMT_ICM_GENKEY	CHAR	3	0	Teeth Type	CRMC_ICM_VALUES
57	TEETH_CONDITION	☐	CRMT_ICM_TEETH_CONDITION	CRMT_ICM_GENKEY	CHAR	3	0	Teeth Condition	CRMC_ICM_VALUES
58	TEETH_COLOR	☐	CRMT_ICM_TEETH_COLOR	CRMT_ICM_GENKEY	CHAR	3	0	Teeth Color	CRMC_ICM_VALUES
59	.INCLUDE	☐				0	0	Extensibility include for ICM BP: Description of Person
60	CRM_ICM_BP_DESC	☐	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	CRMM_ICM_BP_DESC	AGE_UNIT	T006	MSEHI	REF	1	CN
2	CRMM_ICM_BP_DESC	BUILD	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
3	CRMM_ICM_BP_DESC	CHIN_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
4	CRMM_ICM_BP_DESC	CHIN_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
5	CRMM_ICM_BP_DESC	CONTACT_LENSES	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
6	CRMM_ICM_BP_DESC	EAR_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
7	CRMM_ICM_BP_DESC	EAR_SIZE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
8	CRMM_ICM_BP_DESC	EYEBROW_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
9	CRMM_ICM_BP_DESC	EYEBROW_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
10	CRMM_ICM_BP_DESC	EYE_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
11	CRMM_ICM_BP_DESC	EYE_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
12	CRMM_ICM_BP_DESC	EYE_SIZE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
13	CRMM_ICM_BP_DESC	FACE_FEATURE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
14	CRMM_ICM_BP_DESC	FACE_LENGTH	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
15	CRMM_ICM_BP_DESC	FACE_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
16	CRMM_ICM_BP_DESC	FACE_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
17	CRMM_ICM_BP_DESC	FAC_HAIR_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
18	CRMM_ICM_BP_DESC	FAC_HAIR_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
19	CRMM_ICM_BP_DESC	GENDER	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
20	CRMM_ICM_BP_DESC	GLASSES_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
21	CRMM_ICM_BP_DESC	HAIR_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
22	CRMM_ICM_BP_DESC	HAIR_LENGTH	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
23	CRMM_ICM_BP_DESC	HAIR_STATUS	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
24	CRMM_ICM_BP_DESC	HAIR_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
25	CRMM_ICM_BP_DESC	HEIGHT_UNIT	T006	MSEHI		1	CN
26	CRMM_ICM_BP_DESC	PHENOTYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
27	CRMM_ICM_BP_DESC	PIERCING	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
28	CRMM_ICM_BP_DESC	SHOE_SIZE_UNIT	T006	MSEHI	REF	1	CN
29	CRMM_ICM_BP_DESC	SKIN	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
30	CRMM_ICM_BP_DESC	TEETH_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
31	CRMM_ICM_BP_DESC	TEETH_CONDITION	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
32	CRMM_ICM_BP_DESC	TEETH_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
33	CRMM_ICM_BP_DESC	VOICE_ACCENT	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
34	CRMM_ICM_BP_DESC	VOICE_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
35	CRMM_ICM_BP_DESC	VOICE_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
36	CRMM_ICM_BP_DESC	WEIGHT_UNIT	T006	MSEHI	REF	1	CN

History

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