The CRMC_MKP_OPT table in SAP ERP or S/4HANA stores Opt-in Definitions for Marketing Permission data. There are total 3 fields in CRMC_MKP_OPT table. The Opt-in Definitions for Marketing Permission 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_MKP_OPT table. It is in Marketing PermissionData Set for Business Partner (CRM_BUPA_MKT_PERMISSION) ABAP package and is part of the Business Partners (CRM-MD-BP) module.
SAP CRMC_MKP_OPT Table Fields
Following is the list of fields that are available in SAP CRMC_MKP_OPT table. The primary key fields of the table are CLIENT (Client), OPTID (Identifier for Country-Specific Opt-In Settings).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| OPTID | Identifier for Country-Specific Opt-In Settings | CRMT_BU_MKTPERM_OPTID | CHAR (10) | |
| VALIDITY | Validity Period in Months | CRMT_BU_MKTPERM_VALIDITY | NUMC (10) |
