The CRMD_MKTPL_DATE table in SAP ERP or S/4HANA stores Additional date ranges for marketing object data. There are total 15 fields in CRMD_MKTPL_DATE table. The Additional date ranges for marketing object 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_DATE table. It is in CRM Marketing Planning: Dates Assignments (CRM_MKTPL_DATES) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMD_MKTPL_DATE Table Fields
Following is the list of fields that are available in SAP CRMD_MKTPL_DATE table. The primary key fields of the table are MANDT (Client), GUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| GUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| PROJECT_GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| TASK_GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| DATE_ID | Unique Identifier for Additional Date Ranges | CRM_MKTPL_DATE_ID | NUMC (2) | |
| START_DATE | Additional Start Date Range | CRM_MKTPL_START_DATE_RANGES | DEC (15) | |
| END_DATE | Additional End Date Range | CRM_MKTPL_END_DATE_RANGES | DEC (15) | |
| OBJECT_CLASS | Category of Marketing Project | CRM_MKTPL_OBJ_CLASS | CHAR (3) | |
| REF_DATE_GUID | Referenced Date Range Guid | CRM_MKTPL_DATE_REF_GUID | RAW (16) | |
| REL_START | Additional Date Ranges Relation | CRM_MKTPL_DATE_RELATION | CHAR (2) | |
| REL_START_OFFSET | Duration of Date Range | CRM_MKTPL_DATE_REL_DURATION | DEC (8) | |
| REL_START_UNIT | Unit of Duration of Date Range | CRM_MKTPL_DATE_REL_UNIT | CHAR (2) | |
| REL_RANGE_DUR | Duration of Date Range | CRM_MKTPL_DATE_REL_DURATION | DEC (8) | |
| REL_RANGE_UNIT | Unit of Duration of Date Range | CRM_MKTPL_DATE_REL_UNIT | CHAR (2) | |
| MKTPL_DATERANGE | Dummy function in length 1 | DUMMY | CHAR (1) |
