SAP S/4Hana table CRMD_MKTTG_TG_H stores CRM Marketing: Target Group Header Datadata
So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_MKTTG_TG_H look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.
Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.
S4 Hana CRMD_MKTTG_TG_H dictionary attributes
Object Name: CRMD_MKTTG_TG_H
Dictionary Type: Transparent table
Description: CRM Marketing: Target Group Header Data
Field list for CRMD_MKTTG_TG_H table on an S/4 SAP system
| 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 | |||||
| GUID | CRMT_TARGETGRP_GUID | RAW | 16(0) | CRM Marketing: GUID of Target Group | SYSUUID | |||||||
| SET_H_GUID | CRMT_MKTTG_SET_GUID | RAW | 16(0) | CRM Marketing: GUID Profile Set | SYSUUID | |||||||
| SET_GUID | CRMT_MKTTG_SET_GUID | RAW | 16(0) | CRM Marketing: GUID Profile Set | SYSUUID | |||||||
| PROF_GUID | CRMT_MKTTG_PF_GUID | RAW | 16(0) | CRM Marketing: GUID of a Profile | SYSUUID | |||||||
| TG_ORG | CRMT_MKTTG_TG_ORG | CHAR | 2(0) | CRM Marketing: Origin of a Target Group | CRM_MKTTG_TG_ORG | |||||||
| TG_TYPE | CRMT_MKTTG_TG_TYPE | CHAR | 6(0) | CRMC_MKTTG_TYP_H | CRM Marketing: Segment Type | CRM_MKTTG_TG_TYPE | ||||||
| PLAN_COUNT | CRMT_MKTTG_PLAN | INT4 | 10(0) | CRM Marketing: Planned Size of a Segment | ||||||||
| ACT_COUNT | CRMT_MKTTG_COUNT | INT4 | 10(0) | CRM Marketing: Number of Business Partners in a Segment | ||||||||
| DEDUP_CODE | CRMT_MKTTG_DEDUP_CODE | CHAR | 6(0) | CRM Marketing: Deduplication Method Key | CHAR6 | |||||||
| PRIO | CRMT_MKTTG_SEG_PRIO | INT4 | 10(0) | CRM Marketing: Priority of a Segment | CRM_MKTTG_SEG_PRIO | |||||||
| SEARCHFIELD | CRMT_MKTTG_SEARCHFIELD | CHAR | 32(0) | CRM Marketing: Target Groups Search Term | CRM_MKTTG_SEARCHFIELD | |||||||
| DELETE_FLAG | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | |||||||
| ITEM_TABLE | CRMT_MKTTG_TG_I_TAB_NAME | CHAR | 16(0) | CRM Marketing: Table Containing Header Items | DBOBJ_NAME | |||||||
| ORIG_LG | CRMT_MKTTG_ORIG_LG | LANG | 1(0) | Original Language of Segment | LANG | |||||||
| CREATED_AT | CRMT_MKT_CREATED_AT | DEC | 15(0) | Marketing Object: Creation Date | BCOS_TSTMP | |||||||
| CREATED_BY | CRMT_MKT_CREATED_BY | CHAR | 12(0) | Marketing Object: Created By User | UNAME | |||||||
| CHANGED_AT | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP | |||||||
| CHANGED_BY | CRMT_MKT_CHANGED_BY | CHAR | 12(0) | Marketing Object: Last Changed By | UNAME | |||||||
| TG_SEL | CRMT_MKTTG_TG_SELECTION | CHAR | 1(0) | Variable for Scheduled Target Group Selection | CRM_BOOLEAN | |||||||
| UU_COUNT | CRMT_MKTTG_UU_COUNT | INT4 | 10(0) | CRM Marketing: No. of Unknown Users in a Segment | ||||||||
| BW_SYNC | CRMT_MKTTG_BW_SYNC | CHAR | 1(0) | Indicator for Target Group Synchronization with BW | CRM_BOOLEAN | |||||||
| OBJ_TYPE | CRMT_MKTTG_PF_OBJ_TYPE | CHAR | 2(0) | CRM Marketing: Object Type for a Marketing Profile | CRM_MKTPF_OBJ_TYPE | |||||||
| COUNT_RELATION | CRMT_MKTTG_COUNT_RELATIONSHIP | INT4 | 10(0) | CRM Marketing: Number of Relationships | ||||||||
| ID | CRMT_MKTTG_TG_ID | CHAR | 10(0) | CRM Marketing: Target Group ID | CRM_MKTTG_TG_ID | |||||||
| MODELING_TYPE | CRMT_MKTTG_MODELING_TYPE | CHAR | 1(0) | CRM Marketing: Modeling Type | CRM_MKTTG_MODELING_TYPE | |||||||
| RESPONSIBLE | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | |||||||
| TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | RAW | 16(0) | Territory Path GUID | SYSUUID | |||||||
| NODE_GUID | BU_NODE_GUID | RAW | 16(0) | GUID of Hierarchy Node | SYSUUID | |||||||
| VALID_FROM | CGPL_PLANSTART | DEC | 15(0) | Planned start date | BCOS_TSTMP | |||||||
| VALID_TO | CGPL_PLANSTART | DEC | 15(0) | Planned start date | BCOS_TSTMP | |||||||
| LAST_BUILD | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP |
View list of all S4 Hana tables
