SAP S/4Hana table CRMD_MKTTG_TG_S stores CRM Marketing: Selection Criterion of a Profiledata

  

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_S 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_S dictionary attributes

Object Name: CRMD_MKTTG_TG_S
Dictionary Type: Transparent table
Description: CRM Marketing: Selection Criterion of a Profile


Field list for CRMD_MKTTG_TG_S 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) ClientMANDTTEST
GUIDCRMT_MKTTG_PF_S_GUIDRAW16(0) CRM Marketing: GUID for a Target Group Selection CriterionSYSUUID
TG_GUIDCRMT_TARGETGRP_GUIDRAW16(0) CRM Marketing: GUID of Target GroupSYSUUID
PF_GUIDCRMT_MKTTG_PF_GUIDRAW16(0) CRM Marketing: GUID of a ProfileSYSUUID
SA_GUIDCRMT_MKTTG_SA_GUIDRAW16(0) CRM Marketing: GUID of Selection AttributeSYSUUID
SAF_GUIDCRMT_MKTTG_SAF_GUIDRAW16(0) CRM Marketing: GUID of a Selection Attribute FilterSYSUUID
SOURCE_TYPECRMT_MKTTG_PF_S_SOURCETYPECHAR2(0) CRM Marketing: Origin Type for a TG Selection CriterionCRM_MKTTG_SDS_TYPE
SOURCE_NAMECRMT_MKTTG_PF_S_SOURCENAMECHAR72(0) CRM Marketing: Data Source of a TG Selection Criterion
SOURCE_RFCCRMT_MKTTG_PF_S_RFCCHAR32(0) CRM Marketing: RFC Destination of a Data SourceRFCDEST
POSTFUNCCRMT_MKTTG_PF_S_POSTFUNCCHAR30(0) CRM Marketing: FM to be Called Following SelectionFUNCNAME
FIELDNAMECRMT_MKTTG_PF_S_FIELDNAMECHAR72(0) CRM Marketing: Techn.Field Name for a Selection CriterionCHAR72
BUPA_FIELDCRMT_MKTTG_SDS_BUPA_FIELDCHAR72(0) CRM Marketing: Business Partner Field of Data Source
PARTNRFCT_FIELDCRMT_MKTTG_SDS_PARTNRFCT_FIELDCHAR72(0) CRM Marketing: Partner Function Field for Data Source
OBJ_FIELDCRMT_MKTTG_SDS_OBJ_FIELDCHAR72(0) CRM Marketing: Object Field for Data Source
SAMPLE_INFOSETCRMT_MKTTG_SDS_SAMPLE_INFOSETCHAR32(0) CRM Marketing: Data Source of a TG Selection Criterion
SAMPLE_FIELDCRMT_MKTTG_SDS_SAMPLE_FIELDCHAR72(0) CRM Marketing: Sample Field of Data Source (Infoset Only)
MAPPING_FORMATCRMT_MKTLIST_FORMATCHAR6(0) Mapping FormatCRM_MKTLIST_FORMAT
SINGLE_ATTRCRMT_MKTTG_PF_RL_TYPE_SINGLECHAR1(0) CRM Marketing: Rel. Between Sel. Criteria (Single Attribute)CRM_MKTTG_PF_RL_TYPE
MULTIPLE_ATTRCRMT_MKTTG_PF_RL_TYPE_MULTICHAR1(0) CRM Marketing: Relat. Betw. Sel. Criteria (Cross-Attribute)CRM_MKTTG_PF_RL_TYPE
RELATIONSHIPBU_RLTYPECHAR6(0) Business partner role (change doc.-relevant)BU_ROLE
KIND_RELSHIPBU_RELKINDCHAR4(0) Business partner relationship typeBU_RELKIND
SEL_SIGNCRMT_MKTTG_PF_S_SIGNCHAR1(0) CRM Marketing: Component SIGN for Selection CriterionDDSIGN
SEL_OPTIONCRMT_MKTTG_PF_S_OPTIONCHAR2(0) CRM Marketing: Component 'OPTION' for Selection CriterionDDOPTION
SEL_LOWCRMT_MKTTG_PF_S_LOWCHAR132(0) CRM Marketing: Component 'LOW' for Selection Criterion
SEL_HIGHCRMT_MKTTG_PF_S_HIGHCHAR132(0) CRM Marketing: Component 'HIGH' for Selection Criterion
SEL_GROUPCRMT_MKTTG_PF_RL_GROUPINT410(0) CRM Marketing: Relationship Group of Selection CriteriaINT4


View list of all S4 Hana tables