How & where to check the marketing transactions associated with the target group?

[former_member293746]

Hi SAP CRM Experts,

1)I would like to know how & where to check all the marketing transactions associated with a particular target group in SAP CRM ?

2) Any specific tables or Tcodes to find these?

Would appreciate doing the needful at the earliest.

Best Regards

SV

[former_member293746]

Hi Markus,

Thanks for your efforts.

Just a bit confusion here, actually i need to campaign linked with Target Group.

I know the target group number only and now i want to find what are all the Campaigns associated with this Target group.

Please suggest the steps how to find fom tables or Tcodes?

Thanks in advance.

Best Regards

SV

[former_member92946]

Hello SV,

you can get the Target Group GUID by inserting the TG ID into the "ID" Field of the DB Table: CRMD_MKTTG_TG_H. Afterwards paste the GUID into table: CRMD_MKTPL_TGGR and you will get all associated Campaigns to this TG, just the reversed procedure as I have described previously.

Regards,

Markus

[former_member293746]

Hello Markus,

Appreciate for your efforts.

Still i cannot find the campaigns associated with Target Group ID with these steps.

Best Regards

SV

[former_member293746]

Hi Markus ,

Thanks for the info provided.

I have input the Target Grp GUID from table CRMD_MKTTG_TG_H into the table CRMD_MKTPL_TGGRP in order to get the Campaign, but i am receiving the "

No table entries found for specified key"

Please let me know from which Target Grp GUID and from what table i should use to get the Campaign ?

Thanks

SV

,

HI Markus,

Thanks for the info provided.

When i input the Target Grp GUID from table CRMD_MKTTG_TG_H into the table CRMD_MKTPL_TGGRP to get the campaign , receiving the message as "No table entries found for specified key".

Please suggest which Target grp GUID should be used?

Best Regards

SV

[former_member92946]

Hello SV,

for me the scenario is working. I am using the TARGETGRP_GUID from Table: CRMD_MKTPL_TGGRP and paste it into the GUID field of Table: CRMD_MKTTG_TG_H.

Please make sure that the TG exists and has not been deleted in the meantime.

Regards,

Markus

[former_member293746]

Hi Markus,

Thanks for the info provided.

Actually i am looking for campaign with which the target group is associated? Where to check this , any Tcode or table?

Best Regards

SV

[former_member92946]

Hi SV,

you can get the Campaign details from DB Table: CGPL_PROJECT. The linkage between the Campaign and the Target Group is found in Table: CRMD_MKTPL_TGGRP.

Regards,

Markus

[former_member92946]

Hello S V,

the Target Group Information is stored within tables: CRMD_MKTTG_TG_H (for the Header Data) and table: CRMD_MKTTG_TG_I (for the TG Item Data --> the members).

Could you please explain what transactions you are referring to? Do you want to know where the TG is used in?

Regards,

Markus