Tables: Relationship between campaign and campaign-targetgroup

Hi Experts,

Iu2019m looking for the tables where I can find the relationship between campaign and the targetgroups which used in the campaign.

I tried the following way:

CGPL_PROJECT(guid) -> CRMD_MKTPL_TGGRP(project_guid) -> CRMD_MKTPL_TGGRP(targetgrp_guid) -> CRMD_MKTTG_SET_H(prof_guid)

But this way only work for a few campaigns. Not for all. So I think it is the wrong way.

Can anybody help me?

Thanks a lot

Best regards