I have a requirement, in which from the GUID of the Target Group, i need to fetch the details of the Campaigns in which it is assigned (There will be multiple assignement).
I found two Tables for this:
1. CRMD_MKTPL_TGGRP : Field: TARGETGRP_GUID
2. CRMD_MKTTG_TG_H : Fields: SET_H_GUID, SET_GUID, PROF_GUID
My logic was to join these table for getting the Campaign for each Target Group, but unfortunately i didnt find any common data in between the field TARGETGRP_GUID of CRMD_MKTPL_TGGRP and above stated 3 fields of the CRMD_MKTTG_TG_H.
is there any FM available for getting the Campaign details from the Target Group?
Please share your comments.