Skip to Content
0

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

Nov 11, 2016 at 11:56 AM

82

avatar image
S V

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

CRM Marketing
target
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Sort by:
avatar image
Markus Riedel Answered
Nov 15, 2016 at 08:58 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
S V Answered Nov 16, 2016 at 02:53 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Markus Riedel
Nov 17, 2016 at 02:38 PM

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

0
Comment
avatar image
S V Answered Nov 17, 2016 at 03:37 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Markus Riedel
Nov 18, 2016 at 09:40 AM

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

0
Comment
avatar image
S V Answered Nov 18, 2016 at 11:02 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Markus Riedel
Nov 21, 2016 at 09:22 AM

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

0
S V
Markus Riedel
Nov 23, 2016 at 04:12 PM

Hello Markus,

Appreciate for your efforts.

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

Best Regards

SV

0
Comment