SAP CRMD_MKTTG_DDTMP Table – CRM-Marketing: temporary storage for dedup objects

The CRMD_MKTTG_DDTMP table in SAP ERP or S/4HANA stores CRM-Marketing: temporary storage for dedup objects data. There are total 7 fields in CRMD_MKTTG_DDTMP table. The CRM-Marketing: temporary storage for dedup objects 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_MKTTG_DDTMP table. It is in CRM Marketing: General FMs for TG Selection (Enhanced) (CRM_MKTTG) ABAP package and is part of the Target Groups (CRM-MKT-SEG-TGR) module.

SAP CRMD_MKTTG_DDTMP Table Fields

Following is the list of fields that are available in SAP CRMD_MKTTG_DDTMP table. The primary key fields of the table are CLIENT (Client), SET_GUID (CRM Marketing: GUID Profile Set), TG_GUID (CRM Marketing: GUID of Target Group), BP_GUID (Business Partner GUID), RELATIONSHIP (Business Partner Relationship Category), REL_GUID (Business Partner GUID).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT CLNT (3)
SET_GUID CRM Marketing: GUID Profile Set CRMT_MKTTG_SET_GUID RAW (16)
TG_GUID CRM Marketing: GUID of Target Group CRMT_TARGETGRP_GUID RAW (16)
BP_GUID Business Partner GUID BU_PARTNER_GUID RAW (16)
RELATIONSHIP Business Partner Relationship Category BU_RELTYP CHAR (6)
REL_GUID Business Partner GUID BU_PARTNER_GUID RAW (16)
PRIO CRM Marketing: Priority of a Segment CRMT_MKTTG_SEG_PRIO INT4 (10)