SAP CRMC_IC_BPREL Table – customizing table for relationships

The CRMC_IC_BPREL table in SAP ERP or S/4HANA stores customizing table for relationships data. There are total 8 fields in CRMC_IC_BPREL table. The customizing table for relationships table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_IC_BPREL table. It is in CRM Interaction Center: Customizing (CRM_IC_CUSTOMIZING) ABAP package and is part of the Interaction Center WebClient (CRM-IC) module.

SAP CRMC_IC_BPREL Table Fields

Following is the list of fields that are available in SAP CRMC_IC_BPREL table. The primary key fields of the table are CLIENT (Client), PROFILE (Account Identification Profile ID), RELTYPE (Business Partner Relationship Category).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT CLNT (3)
PROFILE Account Identification Profile ID CRMT_IC_BUPA_PROFILE_ID CRMC_IC_BPIDENT CHAR (32)
RELTYPE Business Partner Relationship Category BU_RELTYP TBZ9 CHAR (6)
SEQUENCE Component Sequence CRMT_IC_BUPA_COMPONENT_SEQ NUMC (2)
BPCATG_CREATE Business Partner Category CRM_IC_BUPA_CATEGORY_TYPE CHAR (1)
CP_KIND_CREATE Business Partner Type BU_BPKIND TB004 CHAR (4)
CP_ROLE_CREATE BP role BU_ROLE CHAR (6)
CP_DUP_CHECK Check Contact Person for Duplicates CRMT_IC_CP_DUP CHAR (1)