Trade promotion and agreement relationship

[Former Member]

Hi friends,

I am trying to find a table which stores the link between trade promotion and agreement. I checked CGPL_PROJECT,CGPL_MKTPL_TPATTR and CGPL_MKTPL_ATTR already but didn't find entry for agreements.

If you know the table, please let me know.

Thanks.

[former_member202391]

Hi Satish,

Did you try checking in Table /BON/AG_HEADER, which holds list of Agreements and their associcated Promotion IDs (Object GUID).

Regards

Naren..

[former_member596397]

You have to use a combination of the CRMD_MKTGS_LINKS table and the SRRELROLES table.  It is kind of tricky because it is recursive.

if you use SE16, then do the following

1. SRRELROLES.objkey = TPM GUID

2. CRMD_MKTGS_LINKS.roleb = value of SRRELROLES.RoleID  (Use the BRELTYPE = AGTP)

3. SRRELROLES.RoleID = CRMD_MKTGS_LINKS.rolea

4. SRRELROLES.ojbkey = AGR GUID

I'm unable to paste in the code I have for a query, otherwise I would provide you a query.

[Former Member]

Hi Satish,

have you tried with CGPL_HIERARCHY table?

Giacomo

[Former Member]

Hi friend,

What you are seeking for is the agreement or agreement generated condition records?

Best regards,
Henry

[Former Member]

Hi Henry,

I am seeking just the agreement. All the trade promotions are tied to one agreement. The agreement belongs to one business partner.

Regards.

Satish