SAP ABAP Table CRMT_ICM_BP_DESCR_UI (ICM: Business Partner: Personal Description - UI Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS-ICM-BP (Application Component) Business Partners
     ⤷ CRM_ICM_BOL_BP_PS (Package) CRM ICM: Bol objects for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ICM_BP_DESCR_UI	Table Relationship Diagram
Short Description	ICM: Business Partner: Personal Description - UI Structure

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_ICM_BP_DESCR_UI	AGE_UNIT	T006	MSEHI	REF	1	CN
2	CRMT_ICM_BP_DESCR_UI	BUILD	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
3	CRMT_ICM_BP_DESCR_UI	CHIN_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
4	CRMT_ICM_BP_DESCR_UI	CHIN_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
5	CRMT_ICM_BP_DESCR_UI	CONTACT_LENSES	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
6	CRMT_ICM_BP_DESCR_UI	EAR_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
7	CRMT_ICM_BP_DESCR_UI	EAR_SIZE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
8	CRMT_ICM_BP_DESCR_UI	EYEBROW_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
9	CRMT_ICM_BP_DESCR_UI	EYEBROW_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
10	CRMT_ICM_BP_DESCR_UI	EYE_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
11	CRMT_ICM_BP_DESCR_UI	EYE_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
12	CRMT_ICM_BP_DESCR_UI	EYE_SIZE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
13	CRMT_ICM_BP_DESCR_UI	FACE_FEATURE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
14	CRMT_ICM_BP_DESCR_UI	FACE_LENGTH	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
15	CRMT_ICM_BP_DESCR_UI	FACE_SHAPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
16	CRMT_ICM_BP_DESCR_UI	FACE_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
17	CRMT_ICM_BP_DESCR_UI	FAC_HAIR_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
18	CRMT_ICM_BP_DESCR_UI	FAC_HAIR_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
19	CRMT_ICM_BP_DESCR_UI	GENDER	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
20	CRMT_ICM_BP_DESCR_UI	GLASSES_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
21	CRMT_ICM_BP_DESCR_UI	HAIR_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
22	CRMT_ICM_BP_DESCR_UI	HAIR_LENGTH	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
23	CRMT_ICM_BP_DESCR_UI	HAIR_STATUS	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
24	CRMT_ICM_BP_DESCR_UI	HAIR_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
25	CRMT_ICM_BP_DESCR_UI	HEIGHT_UNIT	T006	MSEHI		1	CN
26	CRMT_ICM_BP_DESCR_UI	PHENOTYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
27	CRMT_ICM_BP_DESCR_UI	PIERCING	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
28	CRMT_ICM_BP_DESCR_UI	SHOE_SIZE_UNIT	T006	MSEHI	REF	1	CN
29	CRMT_ICM_BP_DESCR_UI	SKIN	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
30	CRMT_ICM_BP_DESCR_UI	TEETH_COLOR	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
31	CRMT_ICM_BP_DESCR_UI	TEETH_CONDITION	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
32	CRMT_ICM_BP_DESCR_UI	TEETH_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
33	CRMT_ICM_BP_DESCR_UI	VOICE_ACCENT	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
34	CRMT_ICM_BP_DESCR_UI	VOICE_STYLE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
35	CRMT_ICM_BP_DESCR_UI	VOICE_TYPE	CRMC_ICM_VALUES	GENERIC_KEY	REF	1	CN
36	CRMT_ICM_BP_DESCR_UI	WEIGHT_UNIT	T006	MSEHI	REF	1	CN

History

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