Skip to Content

One of the most common question in the Trade Promotion Management Space is – how do I find out the trade promotions whose conditions (may be Rebate  or Discounts) got into the Sales Order in ECC?

To Answer this question – I am proving a step by step process how this can be achieved

  • Get the sales Order Number for which you want to trade back to the Trade Promotion (For Example – 100XXXXXXX)
  • Now pass the sales order number to VBAK table, field VBELN

Pic1.jpg

and note down the Value of the filed KNUMV

Pic 2.jpg

  • Now take the Value of KNUMV (Here – 0015129651) & Pass it to table KONV field KNUMV

Pic 3.jpg

Here you will get all the conditions attached to the sales order – some conditions would be coming here from TPM Spend Types (depends on the config)

Here lets’ take all the Condition numbers (field – KNUMH)

Pic 4.jpg

  • Now take the List of the condition numbers & pass to table CND_MAP_KNUMH field KNUMH

Pic 5.jpg

& Take down the VARNUMH

Pic 6.jpg

here we see from the sales Order – out of many condition 2 came from CRM (basically TPM)

Note down the values of VARNUMH

  • Now log into CRM and go to the table /SAPCND/CONDREF and pass the above values of VARNUMH

Pic 7.jpg

Here note down the REF_GUID (condition Record ID) only for the entries where Ref. Type is MKT

  • Now go back to ECC to the table PRPS (given Project system integration is there for the environment) and pass the value to field CGPL_GUID

Pic 8.jpg

Here you can see Trade Promotion IDs

So our goal of Tracing Back to Trade Promotions from the Sales Order is successfully done.


To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply