Skip to Content
0

Table(s) that holds Campaign & Campaign element related details in SAP CRM

Dec 15, 2017 at 08:42 PM

138

avatar image

Hi SAP CRM Gurus,

I am trying to find out the table(s) that hold the Campaign & Campaign element related details in SAP CRM.

If I know the tables, I would then directly write a query to check all the details from the back end instead of verifying from front end CRM system.

I would like to know all the details even if it's multiple tables that needs to be connected, but at the least would expect the following info for a given Campaign/Campaign Element,

  • “Campaign” level: General Data, Dates, Status, Channel
  • “Campaign Element” level: General Data, Dates, Status, Channel, Segments

Any help would be highly appreciated.

Thanks,

Sri

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ricky J Dec 18, 2017 at 06:04 AM
0

Hi,

CGPL_PROJECT

CGPL_TASK

CGPL_TEXT

Check tables start with CGPL*...

-Ricky

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Ricky,

Thanks for the response, I checked the 3 tables & couldn't get details about channels, status etc. All it has is the GUID, campaign/element names, created by IDs & name of the campaign.

Also I checked all other tables that starts with CGPL in the CRM schema, but couldn't find any other table that meets my requirement. Do you have any other additional suggestions?

Thanks,

Sri

0

Hello Sri,

the campaign channel and more details are available in the following table:

CRM_MKTPL_ATTR - CRM Marketing Planner: Marketing plan/campaign attributes

The status is available in the following tables:

CRM_JSTO - Status Object Information
CRM_JEST - Individual Object Status

The status information can be fetched with the campaign / campaign element guid.

best regards,

Johannes

0

Hi Johannes,

Thanks for the reply. This is really helpful. With these tables, I am able to check most of the fields, however I'm wondering if I could see the Target groups(names) attached to the Mail Group/Control Group from any tables.

See screen shot attached from CRM.

Thanks,

Sri

capture.jpg (26.8 kB)
0