SAP ABAP Table CRMM_ICM_BP_AID (ICM BP Alternative Identity Master Data)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMM_ICM_BP_AID	Table Relationship Diagram
Short Description	ICM BP Alternative Identity Master Data

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	AID_GUID	☑	CRM_ICM_BP_AID_GUID	SYSUUID	RAW	16	0	ICM BP Alternative Identity GUID
3	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	.INCLUDE	☐				0	0	ICM BP alternative identity general data
5	OBSERVATION_DATE	☐	CRM_ICM_BP_AID_DATE	DATUM	DATS	8	0	ICM BP Alternative Identity - Observation Date
6	TYPE	☐	CRM_ICM_BP_AID_TYPE	CHAR4	CHAR	4	0	ICM: Other Name type
7	NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
8	FIRST_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
9	STATUS	☐	CRM_ICM_BP_AID_STATUS	CRM_ICM_BP_AID_STATUS	CHAR	1	0	ICM BP Alternative Identity - Status
10	SRCHNAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
11	MIDDLE_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
12	ACADEMIC_TITLE	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
13	GENDER	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
14	BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
15	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
16	BIRTH_COUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
17	NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
18	BIRTH_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
19	SRCH_FIRST_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
20	SRCH_MIDDLE_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
21	SRCH_BIRTH_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
22	.INCLUDE	☐				0	0	ICM BP Alternative Identity administrative data
23	CREATED_ON_DATE	☐	CRM_ICM_BP_AID_CREATED_ON	DATUM	DATS	8	0	ICM BP alternative identity - Created on Date
24	CREATED_ON_TIME	☐	CRM_ICM_BP_AID_CREATED_ON_TIME	UZEIT	TIMS	6	0	ICM BP AID - Created on Time
25	CREATED_BY	☐	CRM_ICM_BP_AID_CREATED_BY	UNAME	CHAR	12	0	ICM BP alternative identity - Created by user
26	CHANGED_ON_DATE	☐	CRM_ICM_BP_AID_CHANGED_ON	DATUM	DATS	8	0	ICM BP alternative identity - Changed on Date
27	CHANGED_ON_TIME	☐	CRM_ICM_BP_AID_CHANGED_ON_TIME	UZEIT	TIMS	6	0	ICM BP AID - changed on time
28	CHANGED_BY	☐	CRM_ICM_BP_AID_CHANGED_BY	UNAME	CHAR	12	0	ICM BP alternative identity - changed by user
29	CREATED_BY_NAME	☐	CRM_ICM_BP_AID_CREATED_BY_NAME	TEXT40	CHAR	40	0	ICM BP Atlernative Id Created By Name: Formatted Name of Emp
30	CHANGED_BY_NAME	☐	CRM_ICM_BP_AID_CHANGED_BY_NAME	TEXT40	CHAR	40	0	ICM BP AID - changed by name
31	.INCLUDE	☐				0	0	BP Source of Info DB Attributes
32	ICM_ACT_GD	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
33	ICM_RES_AG	☐	CRM_ICM_BP_PROF_RESP_AGENCY	BU_PARTNER	CHAR	10	0	Responsible Agency	*
34	.INCLUDE	☐				0	0	ICM BP Alternative identity extension
35	CRM_ICM_BP_AID	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
36	LOGICAL_DELETE	☐	CRM_ICM_BP_AID_FLAG	FLAG	CHAR	1	0	ICM BP Alternative Identities - FLAG

History

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