Hopefully you have read Jean-Baptiste’s blog on integration configuration for external pricing. His blog discusses middleware configuration required for external pricing integration. This blog discusses the C4C configuration required. Recently this was documented by our product owner Hermann and it seemed appropriate to share in a blog as well.
When you use external pricing in C4C, all pricing is executed remotely in ERP. The only configuration that is needed in C4C is to maintain texts for the ERP condition types and the texts for the summary lines in the pricing procedure.
You may have a large number of condition types in ERP where only a little of them is used in the relevant pricing procedures. Therefore it is recommended not to maintain all ERP condition types in C4C but only the condition types actually used in the relevant pricing procedures.
1. Look which pricing procedures are used in ERP
The first step is to check which pricing procedures are relevant for the integration with C4C.
ERP IMG path: Sales and Distribution – Basic Functions – Pricing – Pricing Control – Define and Assign Pricing Procedures – Define Pricing Procedure Determination
Here you see the pricing procedure usages. Check for the pricing procedures that are relevant for the integration with
C4C.
Example
In this test landscape the C4C integrates with the sales area 1000/30/00 in ERP. In the ERP IMG you see that there is only one pricing procedure used here: ZRVAG1.
Note down the id(s) of the relevant pricing procedure(s) and the description(s).
2. Download the relevant pricing procedures from ERP into Excel
Next step is to download the pricing procedure definitions.
ERP IMG path: Sales and Distribution – Basic Functions – Pricing – Pricing Control – Define and Assign Pricing Procedures – Maintain pricing procedures
For each of the pricing procedures determined in step 1 execute these steps:
a. Select the line for the pricing procedure.
b. Double click on “Control data” in the dialog structure on the left.
Example
Download the Control data table as follows.
a.Choose “Table View – Print” from the menu
b. Choose “List – Export – Spreadsheet…” from the menu.
c. On the popup choose the last option “Select from All Available Formats” and in the drop-down “Excel (in Office 2007 XLSX Format)” and store the file.
3. Adjust the Excel file
Remove all columns from “G – From step” to “R – Mandatory”. We don’t need these columns. From the menu choose Data – Filter to get the Auto Filter symbol for each column. Save your result.
Example
4. Maintain the condition texts in C4C
Use the auto filter in Excel to show all NON blank entries in column “F – Condition type”. These are the condition types with texts you have to maintain in C4C.
Example
The C4C fine tuning setting is “External Pricing – External Condition Types”.
5. Maintain the pricing procedures in C4C
Use the auto filter in Excel to show all BLANK entries in column “F – Condition type”. These are the intermediate sums you have to maintain in C4C. The C4C fine tuning setting is “External Pricing – External Pricing Procedures”. Here you first maintain the pricing procedure plus text (this is what you noted down in step 2) and then the texts for the intermediate sums. The “step number” from the Excel is what you enter as “step” in the C4C UI.
Example
That’s it! This blog shows an example of the C4C configuration required for external pricing.
Article is very useful
Thanks Ginger
Hi Ginger,
I’ve maintained the desired middleware settings as covered in Jean’s blog and External Pricing settings as described in this blog.
But I keep on getting the below errors when I request for external pricing.
(WC7) Partner XXXXXX (Sales Manager) is not an employee
(WC7) Pricing procedure could not be determined
Am I missing some more configuration here?
Regards,
Sandeep
Hi Sandeep,
Make sure the Role ID is properly mapped.
For us for instance with SAP CRM mapping we had 10 as a Bill To in C4C, but 10 was Sales Employee (Manager) in CRM. We just needed to map 10 to 3 and it’s done in Implementation Activity easily.
Thanks,
JB.
Hi Ginger, we have got our external pricing up and running and we are finally getting a good understanding of how it works. There is one thing bothering me though…
There doesn’t seem to exist any Form for Quotes using external pricing. It looks really bad. I tried to change the layout so that it at least shows the price field of the product but the it doesn’t sum it upp in the totals.
Hasn’t SAP provided a form following the external pricing feature? After all the external pricing is a standard integration provided by SAP. Do we need to create an entirely new form in livecycle designer for this?
Best regards
Fredrik
Hi Fredrik,
I am still struggling to get External Pricing work with SAP CRM and get error “Pricing procedure cannot be determined”. However the Pricing with similar data in our on premise system works fine.
Not sure what is missing in my case?
Regards,
Sandeep
Hi Sandeep, Make sure the pricing procedure determination is maintained for the document type that is replicated from C4C to ERP in Your ERP system. For example, when you click ‘Request Pricing’ on sales quote in C4C, this mirrors(creates) a document in ERP(F.exp:- RQO, Depends on what you have maintained) this document should be assigned a pricing procedure in ERP. Regards SHiva
Hi Shiva,
I am integrating SAP C4C with pricing in SAP CRM and am using the same quotation type which is configured in SAP CRM and uses same pricing procedure.
When I execute the pricing with the same document type in SAP CRM, the pricing works abolutely fine.It is only in SAP C4C when I request for External Pricing that I get the error.
Regards,
Sandeep
Sandeep,
Kindly post the error screen shot.
BR
Ankur
Hi Ginger,
We are working on the C4C-ECC integration. Are these steps relevant for configuring ‘Request for pricing from External system’ in Opportunities?
We are unable to find the ‘External Pricing’ option on Fine tuning activity. ‘External Pricing’ activity is visible in Fine tuning only when scoping is done with business option – “Do you use an external application to calculate price for sales quote items in your cloud solution”.
Please let us know.
Thanks,
Deepak
Hi Ginger
I’m having the same problem that Deepak. I see the option “Do you use an external application to calculate price for opportunities items in your cloud solution”. But I don’t see the activity external pricing procedures
Hi Ginger / Jean,
I saw you blog and we have implemented the same way but get the below error.
Also saw the trace not much of an info. there are 2 versions of soap 1.1 and 1.2 we tried with both. we do have replication for other marketing attributes working fine. but the issue is with the external pricing.
Message Processing Log{
ContextName = com.sap.scenarios.cod2crm.querysalesquotepricing.request
IntermediateError = true
MessageGuid = AFaL4MbhuRjzskkpRZvde0Xcw_Ho
Node = vsa837356
OverallStatus = FAILED
ReceiverId = CRM_
StartTime = Tue Jan 05 15:27:02 UTC 2016
StopTime = Tue Jan 05 15:27:17 UTC 2016
Children [
Invoked endpoint{
Cxf.EndpointAddress = /COD/CRM/CustomerQuoteRequestExternalSalesDocumentDataOut
Error = Inbound processing in endpoint at /COD/CRM/CustomerQuoteRequestExternalSalesDocumentDataOut failed with message “SoapFault:faultstring=”http://schemas.xmlsoap.org/wsdl/“, the namespace on the “definitions” element, is not a valid SOAP version.; faultcode={http://schemas.xmlsoap.org/soap/envelope/}VersionMismatch”
StartTime = Tue Jan 05 15:27:02 UTC 2016
Status = FAILED
StopTime = Tue Jan 05 15:27:17 UTC 2016
Children [
Entering Camel route route40{
StartTime = Tue Jan 05 15:27:02 UTC 2016
Children [
Exchange ID-vsa837356-39073-1451717598641-39-16 created in Endpoint[cxf://bean:COD_]{
StartTime = Tue Jan 05 15:27:02 UTC 2016
StopTime = Tue Jan 05 15:27:17 UTC 2016
Children [
Processing exchange ID-vsa837356-39073-1451717598641-39-16 in removeHeaders[*]{
StartTime = Tue Jan 05 15:27:02 UTC 2016
StepId = removeHeaders36
StopTime = Tue Jan 05 15:27:02 UTC 2016
Children [
Processing exchange ID-vsa837356-39073-1451717598641-39-16 in removeHeader[operationName]{
StartTime = Tue Jan 05 15:27:02 UTC 2016
StepId = removeHeader115
StopTime = Tue Jan 05 15:27:02 UTC 2016
Children [
Processing exchange ID-vsa837356-39073-1451717598641-39-16 in removeHeader[operationNamespace]{
StartTime = Tue Jan 05 15:27:02 UTC 2016
StepId = removeHeader116
StopTime = Tue Jan 05 15:27:02 UTC 2016
Children [
Processing exchange ID-vsa837356-39073-1451717598641-39-16 in cxf:bean:CRM_{
Error = org.apache.cxf.binding.soap.SoapFault: “http://schemas.xmlsoap.org/wsdl/“, the namespace on the “definitions” element, is not a valid SOAP version.
regards,
Mohan.
Hi Mohan
Hm…have you created an incident? The namespace error concerns me.
-ginger
Hi Ginger,
Yes this error is strange and in the error trace as well we don’t find any information.
There is an incident created 3 days ago. The incident number — 3100906445.
It will be great if you can help resolve this.
Regards,
Mohan.
hi,
we are requesting external price for sales quote from erp system. we have followed the steps mentioned above and were able to determine prices.
But now the issue is, we have non-stock material with item cat TAX and item category group NLAG.
I donot find any fine-tuning activity for defining item category groups.
I tried by creating an item type ZTAX and configured code list mapping, maintained price components. but when i request pricing system is displaying error message “Item category TAN could not be determined”.
how to solve this issue.
thanks in advance