The CRMM_BPATPL31 table in SAP ERP or S/4HANA stores Profile Attributes data. There are total 9 fields in CRMM_BPATPL31 table. The Profile Attributes 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 CRMM_BPATPL31 table. It is in Profiles for CRM Datasets (CRMM_BUPA_PROFILE_FRG) ABAP package and is part of the CRM Specific Business Partner Data (CRM-MD-BP-DAT) module.
SAP CRMM_BPATPL31 Table Fields
Following is the list of fields that are available in SAP CRMM_BPATPL31 table. The primary key fields of the table are CLIENT (Client), PARTNER_GUID (Business Partner GUID), PROFILE_ID (Profile ID), SALES_ORG (Sales Organization ID), CHANNEL (Distribution Channel), DIVISION (Division).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW (16) | |
| PROFILE_ID | Profile ID | CRMT_SPL_BUPA_PROFILE_ID | * | CHAR (10) |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR (2) | |
| DIVISION | Division | CRMT_DIVISION | TSPA | CHAR (2) |
| VALID_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| VALID_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| SET_GUID | GUID for sets of business partner | CRMT_BU_SET_GUID | RAW (16) |
