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
CLIENTMANDTCLNT3(0) T000ClientMANDTTEST
GUIDCRMT_TARGETGRP_GUIDRAW16(0) CRM Marketing: GUID of Target GroupSYSUUID
SET_H_GUIDCRMT_MKTTG_SET_GUIDRAW16(0) CRM Marketing: GUID Profile SetSYSUUID
SET_GUIDCRMT_MKTTG_SET_GUIDRAW16(0) CRM Marketing: GUID Profile SetSYSUUID
PROF_GUIDCRMT_MKTTG_PF_GUIDRAW16(0) CRM Marketing: GUID of a ProfileSYSUUID
TG_ORGCRMT_MKTTG_TG_ORGCHAR2(0) CRM Marketing: Origin of a Target GroupCRM_MKTTG_TG_ORG
TG_TYPECRMT_MKTTG_TG_TYPECHAR6(0) CRMC_MKTTG_TYP_HCRM Marketing: Segment TypeCRM_MKTTG_TG_TYPE
PLAN_COUNTCRMT_MKTTG_PLANINT410(0) CRM Marketing: Planned Size of a Segment
ACT_COUNTCRMT_MKTTG_COUNTINT410(0) CRM Marketing: Number of Business Partners in a Segment
DEDUP_CODECRMT_MKTTG_DEDUP_CODECHAR6(0) CRM Marketing: Deduplication Method KeyCHAR6
PRIOCRMT_MKTTG_SEG_PRIOINT410(0) CRM Marketing: Priority of a SegmentCRM_MKTTG_SEG_PRIO
SEARCHFIELDCRMT_MKTTG_SEARCHFIELDCHAR32(0) CRM Marketing: Target Groups Search TermCRM_MKTTG_SEARCHFIELD
DELETE_FLAGCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEAN
ITEM_TABLECRMT_MKTTG_TG_I_TAB_NAMECHAR16(0) CRM Marketing: Table Containing Header ItemsDBOBJ_NAME
ORIG_LGCRMT_MKTTG_ORIG_LGLANG1(0) Original Language of SegmentLANG
CREATED_ATCRMT_MKT_CREATED_ATDEC15(0) Marketing Object: Creation DateBCOS_TSTMP
CREATED_BYCRMT_MKT_CREATED_BYCHAR12(0) Marketing Object: Created By UserUNAME
CHANGED_ATCRMT_MKT_CHANGED_ATDEC15(0) Marketing Object: Date of Last ChangeBCOS_TSTMP
CHANGED_BYCRMT_MKT_CHANGED_BYCHAR12(0) Marketing Object: Last Changed ByUNAME
TG_SELCRMT_MKTTG_TG_SELECTIONCHAR1(0) Variable for Scheduled Target Group SelectionCRM_BOOLEAN
UU_COUNTCRMT_MKTTG_UU_COUNTINT410(0) CRM Marketing: No. of Unknown Users in a Segment
BW_SYNCCRMT_MKTTG_BW_SYNCCHAR1(0) Indicator for Target Group Synchronization with BWCRM_BOOLEAN
OBJ_TYPECRMT_MKTTG_PF_OBJ_TYPECHAR2(0) CRM Marketing: Object Type for a Marketing ProfileCRM_MKTPF_OBJ_TYPE
COUNT_RELATIONCRMT_MKTTG_COUNT_RELATIONSHIPINT410(0) CRM Marketing: Number of Relationships
IDCRMT_MKTTG_TG_IDCHAR10(0) CRM Marketing: Target Group IDCRM_MKTTG_TG_ID
MODELING_TYPECRMT_MKTTG_MODELING_TYPECHAR1(0) CRM Marketing: Modeling TypeCRM_MKTTG_MODELING_TYPE
RESPONSIBLEBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUID
TERR_PATH_GUIDCRMT_TERRITORY_PATH_GUIDRAW16(0) Territory Path GUIDSYSUUID
NODE_GUIDBU_NODE_GUIDRAW16(0) GUID of Hierarchy NodeSYSUUID
VALID_FROMCGPL_PLANSTARTDEC15(0) Planned start dateBCOS_TSTMP
VALID_TOCGPL_PLANSTARTDEC15(0) Planned start dateBCOS_TSTMP
LAST_BUILDCRMT_MKT_CHANGED_ATDEC15(0) Marketing Object: Date of Last ChangeBCOS_TSTMP


View list of all S4 Hana tables