In this post, I will try and describe everything you need to know about the SAP crmd_tm_cl_cmpgn table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_TM_CL_CMPGN what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_TM_CL_CMPGN....Right lets get started!
Object Name: CRMD_TM_CL_CMPGN
Dictionary Type: Transparent table
Description: Business context information: campaign, scripts
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| PID | UUID | RAW | 16(0) | Global Unique ID for table | UUID | CRM | ||||||
| CMPG_ID | CGPL_PROJECT_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Projects | CGPL_PROJECT_GUID | CRM | ||||||
| CMPG_DESC | CGPL_TEXT1 | CHAR | 40(0) | Language-Dependent Description | TEXT40 | CRM | ||||||
| CMPG_PRIO | CRMT_CLM_NUMC1 | NUMC | 1(0) | Numc1 | CRM | |||||||
| CMPG_TYPE | CHAR4 | CHAR | 4(0) | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | SAP | CRM | |||||
| CMPG_PLANSTART | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
| CMPG_PLANFINISH | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
| TASK_ID | CGPL_TASK_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Tasks | CGPL_PROJECT_GUID | CRM | ||||||
| TASK_DESC | CGPL_TEXT1 | CHAR | 40(0) | Language-Dependent Description | TEXT40 | CRM | ||||||
| TASK_PLANSTART | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
| TASK_PLANFINISH | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
| TARGETGRP_ID | CRMT_TARGETGRP_GUID | RAW | 16(0) | CRM Marketing: GUID of Target Group | SYSUUID | CRM | ||||||
| SCRIPT_ID | GUID | RAW | 16(0) | Globally Unique Identifier | CRM |