Campaign determination in sales order

[Former Member]

Hi to all,

Campaign determination is not occurring in ECC sales order ,as it was created in CRM later replicated to ECC successfully.

I had checked few relevant tables (PRPS,CMBP_MAP) in ECC but there are no entries in it, so can you help me with your inputs on to fix this issue, however the setup in CRM is fine.

Thanks in advance,

Shiva

[Former Member · Accepted solution]

Hello,

The campaign ID is filled in the background into database table

field VBKD-CAMPAIGN when the corresponding sales order is transferred

to R/3 from CRM or when the campaign is determined in R/3

automatically (please check OSS note 562774 for this functionality).

In the sales order it's the same for campaign conditions and pricing

conditions as well: if the (master data) conditions will be changed

(e.g. you change a pricing condition record in VK12 or cancel a trade

promotion), the conditions in the document will not be changed

automatically. If you want to have the new pricing conditions within

the order, you have to trigger a new pricing.

But unfortunately there is no standard tool available to trigger a new

campaign determination within a sales order without changing anything

else (see documentation below).

There are two possible workarounds :

-> Make a dummy change as described in the documentation below.

-> if it's sufficient to trigger a new campaign document inside the

billing document, you can try to implement the OSS note 856313.

Please see below an extract of the SAP Documentation:

=> Campaign Determination

...........

Features

Campaign determination does not take place when the sales order is

replicated from SAP CRM to SAP ECC. Campaign determination is only

carried out again in SAP ECC once you make changes to the following

data:

· Sales organization

· Distribution channel

· Sold-to party

· Product

· Pricing date"

...........

I hope you find this information very helpful and hopefully it will solve your problem.

Regards,

Martina McElwain

SD - Forum Moderator

[Former Member · Accepted solution]

Thank you Martina for exact details of the functionality.

Very interesting indeed.

As I see you work for SAP, I have a question for you from a frustrated SD Consultant (that me

Why is all the nice stuff always out of standard ERP (ECC) and needs additional licensing?

- Trade Promotions are in CRM.

- Bonus buy is in Retail.

- Decent Distribution / DRP is part of APO / SCM.

- Now WM get's an EWM that is also out of ECC.

On the other hand the beverage industry solution is now part of standard ERP (empties management + DSD). That's nice.

I understand the reason is the need for additional licensing ($$$) and that's OK of course; but my FMCG Consulting customers are not ready to buy a Retail license only to get Bonus Buy; they are not retailers. I am sure one of them would be interested by Trade Promotion Management, but integrated natively in standard ERP, not in another system.

Of course large companies have no problem setting up different systems, but for mid-size companies you must have a very good reason before setting a different system from SAP ERP. For Reporting (SAP BI) that makes sense of course, but IMHO that's the exception that confirms the rule.

Best Regards,

Franck Lumpe

Freelance SAP Logistics Consultant

[Former Member · Accepted solution]

Hello Franck ,

I am glad you found my response useful. Unfortuantely, I am not in a position to know why certain standard functionality is available easily and freely in CRM and not ERP. I do know however - and this is the case for retroactive campaign determination - that if you as a customer are in a position to create a development request for certain functionality then these are very much encouraged by our development team.

Kind Regards,

Martina McElwain

[former_member82960 · Accepted solution]

Hi Martina.

I have read your explanation, and it is exactly what I was looking for, but unfortunately it is not the solution of our problem.

We have implemented TPM and started up to create short/long term promotion for next year. One of our cut-over activities is to execute new pricing for already created sales orders in ERP, but as far I have understod in your explanation, it is not possible to determine the campaign-number without making one of the changes you have mentioned.

It could maybe be a possibility to execute the new pricing on the billing document, and therefore I have been looking for the note 856313, but it doesn't exiist. Could it be another number, or is it not yet published?

Regards

Lotte Ravn.

Royal Unibrew

DK

[Former Member · Accepted solution]

Hello Martina,

Thank your for your kind answer. Because of the tone of my post, I was not expecting any one

if you as a customer are in a position to create a development request for certain functionality then these are very much encouraged by our development team.

This is good to hear. I'll keep it in mind to remind my own Consulting Customers of this possibility.

Best Regards,

Franck

[Former Member · Accepted solution]

Hi Lotte Ravn,

Your right on your views, as even I have the same issue as the campaign id is getting updated in CMPB_MAP table but not in the ECC sales order after doing the relevant changes, as I had checked VBKD table but not successful.

Regards,

Shiva

[Former Member · Accepted solution]

Hi Frank,

Please let us know the procedure for raising an devleopment request, as the campaign id is getting updated in CMPB_MAP table but not in the ECC sales order after doing the relevant changes, as I had checked VBKD table but not successful.

Regards,

Shiva

[ian_kehoe · Accepted solution]

Dear Shiva,

Please see note 11 for entering a development request.

Best regards,

Ian Kehoe

[Former Member]

As suggested by Franck, Campaign is purely CRM functionality. As concerned of data maintained in CRM and not copied in ECC, only the relevant fields from CRM will be copied in ECC, which are available in ECC.

In the case you want to copy Campaign details in ECC, it will be a development and 'Z' fields will be required to be added in ECC along with development for data to be copied (Ideally not recommended, as it will Value add only from Information point of view and no financial benefits)

Regards,

Rajesh Banka

[Former Member]

Hi Shiva,

My understanding is that the "campaign" concept is CRM only.

In SAP ERP we have promotions / sales deals, but the "campaign" field in a sales order item is replicated from the CRM system, I believe there is no determination in SAP ERP.

My knowledge regarding SAP CRM / SAP ERP integration is academic (from SAP documentation only), so I may be wrong.

My 2 cents anyway,

Best Regards,

Franck