Table for mapping Campaign ID and Business Transaction
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.
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) .