Question:
Hello all, I am trying to find standard functionality to do some cleaning on profile sets, profiles and target groups that are currently not used or linked to a campaign!
Are there any reports, transactions that are usefull to do so?
Otherwise I would like to create a query to visualize those marketing objects which I should delete!
tables found so far are the following:
Profile set --> profile --> target group :
CRMD_MKTTG_SET_H --> CRMD_MKTTG_PF_H --> CRMD_MKTTG_TG_H
How can I get the link to the campaign?
The table for campaigns I found are the following:
CGPL_PROJECT
and
CGPL_TEXT
But the GUID of these campaign tables is not available in those other tables!
Thanks for an answer!
Davy Pelssers
SAP CRM consultant
davy.pelssers@cernum.com
_________________
Davy Pelssers
Independant SAP Consultant CRM/BW/Authorisations
pelssersdavy@hotmail.com
Answer:
ok..I found out the link between campaign and Target group:
Table CRMD_MKTPL_TGGRP is the one!
further information on campaign attributes can also be linked via table CRM_MKTPL_ATTR.
anyone who has time to try out a query like mentioned before, can always mail me his findings!!
regards
Davy Pelssers
davy.pelssers@cernum.com
_________________
Davy Pelssers
Independant SAP Consultant CRM/BW/Authorisations
pelssersdavy@hotmail.com