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.