Mailform related to a Campaign

[Former Member]

Hi SAP_CRM Gurus,

i have a requirement that I'll getting a Camapign ID of a Campaign.

The Campaign will have certain Mailforms assigned to it.

With the help of the Camapign ID, I have to retrive the MAILFORMs assigned to the given Campaign Id.

Can anyone suggest any way of achieving the above mentioned functionality?

[Former Member · Accepted solution]

Hi Sibsankar,

I assume you are looking for a way to do this programmatically. If this is the case and you have the campaign id, have a look at table CRM_MKTPL_ATTR where you should be able to find your mail forms by running a select query.

Regards,

David.

[Former Member · Accepted solution]

Hi, Thanks for the reply.

yeah, I am looking to do it programatically.

Actually, the select query can affect the performance. So, I'm looking for an FM.

[Former Member · Accepted solution]

Sibsankar,

After doing a little bit of digging I wasn't able to find a standard function module for retrieving the mail forms information. Running one select query shouldn't have much of an impact on your performance. I would only be cautious if you feel that this code is going to be hit multiple times and will give your system a hammering.

Regards,

David.

[Former Member · Accepted solution]

Hi David, thanks for ur help. ur solution will suffice.

however, after getting the table name that u have provided, i'hv used a where used list..........found one FM- mkt_element_read, to read the attributes realted to a campaign, which also provides the mailform details under the field smartform.