In this post, I will try and describe everything you need to know about the SAP crmd_mkttg_tg_h 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_MKTTG_TG_H 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_MKTTG_TG_H....Right lets get started!
Object Name: CRMD_MKTTG_TG_H
Dictionary Type: Transparent table
Description: TG Exchange: Target Group Header
| 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) | * | Client | MANDT | TEST | |||||
| TG_ID | CRMT_MKTTG_TG_ID | CHAR | 10(0) | CRM Marketing: Target Group ID | CRM_MKTTG_TG_ID | |||||||
| CLIENT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_TARGETGRP_GUID | RAW | 16(0) | CRM Marketing: GUID of Target Group | SYSUUID | CRM | ||||||
| TG_TYPE | CRMT_MKTTG_TG_TYPE | CHAR | 6(0) | CRM Marketing: Segment Type | CRM_MKTTG_TG_TYPE | |||||||
| OBJ_TYPE | CRMT_MKTTG_TG_OBJ_TYPE | CHAR | 2(0) | CRM Marketing: obj type (target group, product segment) | CRM_MKTTG_TG_OBJ_TPYE | |||||||
| SET_H_GUID | CRMT_MKTTG_SET_GUID | RAW | 16(0) | CRM Marketing: GUID Profile Set | SYSUUID | CRM | ||||||
| DELETE_FLAG | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | |||||||
| SET_GUID | CRMT_MKTTG_SET_GUID | RAW | 16(0) | CRM Marketing: GUID Profile Set | SYSUUID | CRM | ||||||
| ITEM_TABLE | CRMT_MKTTG_I_TAB_NAME | CHAR | 16(0) | target group: table containing items | DBOBJ_NAME | |||||||
| ORIG_LG | CRMT_MKTTG_ORIG_LG | LANG | 1(0) | Original Language of Segment | LANG | |||||||
| PROF_GUID | CRMT_MKTTG_PF_GUID | RAW | 16(0) | CRM Marketing: GUID of a Profile | SYSUUID | CRM | ||||||
| TG_ORG | CRMT_MKTTG_TG_ORG | CHAR | 2(0) | CRM Marketing: Origin of a Target Group | CRM_MKTTG_TG_ORG | CRM | ||||||
| CREATED_AT | CRMT_MKTTG_CREATED_AT | DEC | 15(0) | Target Groups: created at | BCOS_TSTMP | |||||||
| TG_TYPE | CRMT_MKTTG_TG_TYPE | CHAR | 6(0) | CRMC_MKTTG_TYP_H | CRM Marketing: Segment Type | CRM_MKTTG_TG_TYPE | CRM | |||||
| CREATED_BY | CRMT_MKTTG_CREATED_BY | CHAR | 12(0) | target group: created by | UNAME | |||||||
| CHANGED_AT | CRMT_MKTTG_CHANGED_AT | DEC | 15(0) | Date of Last Change | BCOS_TSTMP | |||||||
| PLAN_COUNT | CRMT_MKTTG_PLAN | INT4 | 10(0) | CRM Marketing: Planned Size of a Segment | INT4 | CRM | ||||||
| ACT_COUNT | CRMT_MKTTG_COUNT | INT4 | 10(0) | CRM Marketing: Number of Business Partners in a Segment | INT4 | CRM | ||||||
| CHANGED_BY | CRMT_MKTTG_CHANGED_BY | CHAR | 12(0) | Target Group: Last Changed by | UNAME | |||||||
| DEDUP_CODE | CRMT_MKTTG_DEDUP_CODE | CHAR | 6(0) | CRM Marketing: Deduplication Method Key | CHAR6 | CRM | ||||||
| ARCHIVE_FLAG | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | |||||||
| PRIO | CRMT_MKTTG_SEG_PRIO | INT4 | 10(0) | CRM Marketing: Priority of a Segment | CRM_MKTTG_SEG_PRIO | CRM | ||||||
| DELETE_ALL_ITEMS | XFLAG | CHAR | 1(0) | New Input Values | XFLAG | SDIC | ||||||
| SEARCHFIELD | CRMT_MKTTG_SEARCHFIELD | CHAR | 32(0) | CRM Marketing: Target Groups Search Term | CRM_MKTTG_SEARCHFIELD | CRM | ||||||
| DELETE_FLAG | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| ITEM_TABLE | CRMT_MKTTG_TG_I_TAB_NAME | CHAR | 16(0) | CRM Marketing: Table Containing Header Items | DBOBJ_NAME | CRM | ||||||
| ORIG_LG | CRMT_MKTTG_ORIG_LG | LANG | 1(0) | Original Language of Segment | LANG | CRM | ||||||
| CREATED_AT | CRMT_MKT_CREATED_AT | DEC | 15(0) | Marketing Object: Creation Date | BCOS_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_MKT_CREATED_BY | CHAR | 12(0) | Marketing Object: Created By User | UNAME | CRM | ||||||
| CHANGED_AT | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_MKT_CHANGED_BY | CHAR | 12(0) | Marketing Object: Last Changed By | UNAME | CRM | ||||||
| TG_SEL | CRMT_MKTTG_TG_SELECTION | CHAR | 1(0) | Variable for Scheduled Target Group Selection | CRM_BOOLEAN | CRM | ||||||
| UU_COUNT | CRMT_MKTTG_UU_COUNT | INT4 | 10(0) | CRM Marketing: No. of Unknown Users in a Segment | INT4 | CRM | ||||||
| BW_SYNC | CRMT_MKTTG_BW_SYNC | CHAR | 1(0) | Indicator for Target Group Synchronization with BW | CRM_BOOLEAN | CRM | ||||||
| OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CHAR | 2(0) | CRM Marketing: Object Type for a Marketing Profile | CRM_MKTPF_OBJ_TYPE | CRM | ||||||
| COUNT_RELATION | CRMT_MKTTG_COUNT_RELATIONSHIP | INT4 | 10(0) | CRM Marketing: Number of Relationships | INT4 | CRM |