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
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.
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.
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.
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.
That’s it! This blog shows an example of the C4C configuration required for external pricing.