back to top

SAP CRMD_MKTPL_OPER Table – Operations in Marketing Programs

The CRMD_MKTPL_OPER table in SAP ERP or S/4HANA stores Operations in Marketing Programs data. There are total 13 fields in CRMD_MKTPL_OPER table. The Operations in Marketing Programs 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 CRMD_MKTPL_OPER table. It is in CRM Marketing Planning – User Interfaces (CRM_MKTPL) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.

SAP CRMD_MKTPL_OPER Table Fields

Following is the list of fields that are available in SAP CRMD_MKTPL_OPER table. The primary key fields of the table are CLIENT (Client), GUID (Operation GUID).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT CLNT (3)
GUID Operation GUID CRM_MKTPL_OPERATION_GUID RAW (16)
OPERATION_ID Operation Done in a Marketing Program CRM_MKTPL_OPERATION CHAR (1)
MKTELEM_GUID GUID of a Marketing Project for the Operation CRM_MKTPL_MKTEL_OPERATION_GUID RAW (16)
EXTERNAL_ID Project Planning: External Indentifier of an Element CGPL_EXTID CHAR (24)
OBJECT_TYPE Object Type in Project Planning CGPL_OBJECT_TYPE CHAR (3)
TEMPLATE Template Indicator CRM_MKTPL_TEMPLATE CHAR (1)
CREATED_BY Name of Person Who Created Object CGPL_CREATED_BY CHAR (12)
CREATED_ON Date When the Object Was Created CGPL_CREATED_ON DATS (8)
CHANGED_BY Name of Person Who Changed Object CGPL_CHANGED_BY CHAR (12)
CHANGED_ON Date on which object was last changed CGPL_CHANGED_ON DATS (8)
DELETED_BY User who Deleted a Marketing Program CRM_MKTPL_DELETED_BY CHAR (12)
DELETED_ON Timestamp for a Deleted Marketing Program CRM_MKTPL_DELETED_ON DEC (15)