CRMM_ICM_BP_AID - ICM BP Alternative Identity Master Data
ICM BP Alternative Identity Master Data information is stored in SAP table CRMM_ICM_BP_AID.
It is part of development package CRM_ICM_BP_APP in software component CRM-S4-IPS-ICM. This development package consists of objects that can be grouped under "CRM ICM: Business partner - Application".
It is part of development package CRM_ICM_BP_APP in software component CRM-S4-IPS-ICM. This development package consists of objects that can be grouped under "CRM ICM: Business partner - Application".
Fields for table CRMM_ICM_BP_AID
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | |
AID_GUID | ICM BP Alternative Identity GUID | X | CRM_ICM_BP_AID_GUID | RAW | 16 | |
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | ||
.INCLUDE | CRMS_ICM_BP_AID_GEN_DATA | 0 | ||||
OBSERVATION_DATE | ICM BP Alternative Identity - Observation Date | CRM_ICM_BP_AID_DATE | DATS | 16 | ||
TYPE | ICM: Other Name type | CRM_ICM_BP_AID_TYPE | CHAR | 8 | ||
NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
FIRST_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
STATUS | ICM BP Alternative Identity - Status | CRM_ICM_BP_AID_STATUS | CHAR | 2 | ||
SRCHNAME | Search Name | CRM_ICM_BP_SRC_NAME | CHAR | 160 | ||
MIDDLE_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
ACADEMIC_TITLE | Academic Title: Key | AD_TITLE1 | CHAR | 8 | ||
GENDER | Sex of business partner (person) | BU_SEXID | CHAR | 2 | * | |
BIRTH_DATE | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 16 | ||
BIRTH_PLACE | Birthplace of business partner | BU_BIRTHPL | CHAR | 80 | ||
BIRTH_COUNTRY | Country/Region for Name Format Rule | AD_NAMCTRY | CHAR | 6 | * | |
NATIONALITY | Nationality | BU_NATIO | CHAR | 6 | * | |
BIRTH_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
SRCH_FIRST_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
SRCH_MIDDLE_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
SRCH_BIRTH_NAME | ICM BP Alternative Identity - Name (Other name or Last name) | CRM_ICM_BP_AID_NAME | CHAR | 160 | ||
.INCLUDE | CRMS_ICM_BP_AID_ADM_DATA | 0 | ||||
CREATED_ON_DATE | ICM BP alternative identity - Created on Date | CRM_ICM_BP_AID_CREATED_ON | DATS | 16 | ||
CREATED_ON_TIME | ICM BP AID - Created on Time | CRM_ICM_BP_AID_CREATED_ON_TIME | TIMS | 12 | ||
CREATED_BY | ICM BP alternative identity - Created by user | CRM_ICM_BP_AID_CREATED_BY | CHAR | 24 | ||
CHANGED_ON_DATE | ICM BP alternative identity - Changed on Date | CRM_ICM_BP_AID_CHANGED_ON | DATS | 16 | ||
CHANGED_ON_TIME | ICM BP AID - changed on time | CRM_ICM_BP_AID_CHANGED_ON_TIME | TIMS | 12 | ||
CHANGED_BY | ICM BP alternative identity - changed by user | CRM_ICM_BP_AID_CHANGED_BY | CHAR | 24 | ||
CREATED_BY_NAME | ICM BP Atlernative Id Created By Name: Formatted Name of Emp | CRM_ICM_BP_AID_CREATED_BY_NAME | CHAR | 80 | ||
CHANGED_BY_NAME | ICM BP AID - changed by name | CRM_ICM_BP_AID_CHANGED_BY_NAME | CHAR | 80 | ||
.INCLUDE | CRMS_ICM_BP_SRC_INFO_DB_ATTR | 0 | ||||
ICM_ACT_GD | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | ||
ICM_RES_AG | Responsible Agency | CRM_ICM_BP_PROF_RESP_AGENCY | CHAR | 20 | * | |
.INCLUDE | CRMS4S_ICM_BP_AID_INCL_EEW_PS | 0 | ||||
ICM_BP_AID_DUMMY | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
LOGICAL_DELETE | ICM BP Alternative Identities - FLAG | CRM_ICM_BP_AID_FLAG | CHAR | 2 |