Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table for mapping Campaign ID and Business Transaction

Greetings All,

We are using campaign management - when a user enters the campaign ID through the B2B shop and creates an order.

The campaign applied can be seen in the transaction (CRMD_ORDER) on the "Header Overview" tab of the business transaction in the field "Camp/TP". on F1 it give the following tech details Table - CRMT_5010_1O_UI, Field - CAMPAIGN_HE_ID

We are creating a report for checking how many orders were created for a particular campaign - to see the success of the campaign.

However I could not find any table - linking the campaign ID and the business transaction...

I have checked the tables CRMD_ORDERADM_H / CRMD_ORDERADM_I but no luck

Can someone help, correct answers will be awarded generously.

Thanks,

Tags:
Former Member
Former Member replied

Hi !

campaigns are linked to transactions using the document flow. This is a set of different tables.

Starting from the transaction guid (CRMD_ORDERADM_H-GUID, or CRMD_ORDERADM_I-GUID for item document flow entries), table SRRELROLES links the order guid to field ROLEID.

A similar entry in table SRRELROLES should be found for the campaign guid, linked to a 'ROLEID'. The two RoleIDs are linked together in an entry in table CRMD_BINREL. Attirbutes for this relation can be seen in CRMD_BRELVONAE (Header) or CRMD_BRELVONAI (item) .

regards,

Thomas

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question