SAP Table CRMD_MKTTG_TG_S stores CRM Marketing: Selection Criterion of a Profiledata

  

In this post, I will try and describe everything you need to know about the SAP crmd_mkttg_tg_s 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_S 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_S....Right lets get started!


SAP CRMD_MKTTG_TG_S dictionary attributes

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


CRMD_MKTTG_TG_S field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_MKTTG_PF_S_GUIDRAW16(0) CRM Marketing: GUID for a Target Group Selection CriterionSYSUUIDCRM
TG_GUIDCRMT_TARGETGRP_GUIDRAW16(0) CRM Marketing: GUID of Target GroupSYSUUIDCRM
PF_GUIDCRMT_MKTTG_PF_GUIDRAW16(0) CRM Marketing: GUID of a ProfileSYSUUIDCRM
SA_GUIDCRMT_MKTTG_SA_GUIDRAW16(0) CRM Marketing: GUID of Selection AttributeSYSUUIDCRM
SAF_GUIDCRMT_MKTTG_SAF_GUIDRAW16(0) CRM Marketing: GUID of a Selection Attribute FilterSYSUUIDCRM
SOURCE_TYPECRMT_MKTTG_PF_S_SOURCETYPECHAR2(0) CRM Marketing: Origin Type for a TG Selection CriterionCRM_MKTTG_SDS_TYPECRM
SOURCE_NAMECRMT_MKTTG_PF_S_SOURCENAMECHAR72(0) CRM Marketing: Data Source of a TG Selection CriterionCRM
SOURCE_RFCCRMT_MKTTG_PF_S_RFCCHAR32(0) *CRM Marketing: RFC Destination of a Data SourceRFCDESTCRM
POSTFUNCCRMT_MKTTG_PF_S_POSTFUNCCHAR30(0) *CRM Marketing: FM to be Called Following SelectionFUNCNAMECRM
FIELDNAMECRMT_MKTTG_PF_S_FIELDNAMECHAR72(0) CRM Marketing: Techn.Field Name for a Selection CriterionCHAR72CRM
BUPA_FIELDCRMT_MKTTG_SDS_BUPA_FIELDCHAR72(0) CRM Marketing: Business Partner Field of Data SourceCRM
PARTNRFCT_FIELDCRMT_MKTTG_SDS_PARTNRFCT_FIELDCHAR72(0) CRM Marketing: Partner Function Field for Data SourceCRM
OBJ_FIELDCRMT_MKTTG_SDS_OBJ_FIELDCHAR72(0) CRM Marketing: Object Field for Data SourceCRM
SAMPLE_INFOSETCRMT_MKTTG_SDS_SAMPLE_INFOSETCHAR32(0) CRM Marketing: Data Source of a TG Selection CriterionCRM
SAMPLE_FIELDCRMT_MKTTG_SDS_SAMPLE_FIELDCHAR72(0) CRM Marketing: Sample Field of Data Source (Infoset Only)CRM
MAPPING_FORMATCRMT_MKTLIST_FORMATCHAR6(0) *Mapping FormatCRM_MKTLIST_FORMATCRM
SINGLE_ATTRCRMT_MKTTG_PF_RL_TYPE_SINGLECHAR1(0) CRM Marketing: Rel. Between Sel. Criteria (Single Attribute)CRM_MKTTG_PF_RL_TYPECRM
MULTIPLE_ATTRCRMT_MKTTG_PF_RL_TYPE_MULTICHAR1(0) CRM Marketing: Relat. Betw. Sel. Criteria (Cross-Attribute)CRM_MKTTG_PF_RL_TYPECRM
RELATIONSHIPBU_RLTYPECHAR6(0) *Business partner role (change doc.-relevant)BU_ROLECRM
KIND_RELSHIPBU_RELKINDCHAR4(0) *Business partner relationship typeBU_RELKINDCRM
SEL_SIGNCRMT_MKTTG_PF_S_SIGNCHAR1(0) CRM Marketing: Component SIGN for Selection CriterionDDSIGNCRM
SEL_OPTIONCRMT_MKTTG_PF_S_OPTIONCHAR2(0) CRM Marketing: Component 'OPTION' for Selection CriterionDDOPTIONCRM
SEL_LOWCRMT_MKTTG_PF_S_LOWCHAR132(0) CRM Marketing: Component 'LOW' for Selection CriterionCRM
SEL_HIGHCRMT_MKTTG_PF_S_HIGHCHAR132(0) CRM Marketing: Component 'HIGH' for Selection CriterionCRM
SEL_GROUPCRMT_MKTTG_PF_RL_GROUPINT410(0) CRM Marketing: Relationship Group of Selection CriteriaINT4CRM