SAP ABAP Table CRMT_ICM_BP_DESCR (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	INTTAB	Structure
Structure	CRMT_ICM_BP_DESCR	Table Relationship Diagram
Short Description	ICM: Business Partner: Personal Description

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

History

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