Reference condition type not working

[#1]

Good Day 

We are trying to display the retail sales price on the purchase order schema.  This will enable buyers to check the sell price before ordering to manage margin. 

We are using the reference condition functionality and have assigned the same access sequences (with the same condition table) to both the sales and purchase condition types(Z001). 

We have maintained the reference sales condition type in the procurement condition type.  We have maintained the sales pricing condition but are unable to display the same condition on the procurement side.  

Any ideas anyone

[Chris1973]

Good day @MM007 

Thank you for your question

Yes, you can use reference condition types and reference applications in Public Cloud. However, if you assign the same access sequence and condition types, note that they are not sufficient on their own. You also need to set the Reference Condition Type and Reference Application because; the system uses both the Reference Condition Type and Reference Application when searching for the referenced condition record.

See the following reference for more details.

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0e602d466b99490187fcbb30d1dc897c/7a2622a36b024a388bee6fc9...

Here is a quick configuration guide:

• Open configuration activity Set Pricing Condition Types – Purchasing and select your purchasing condition type Z001.
• Provide the following:
  • Reference Application = V for Sales/Distribution
  • Reference Condition Type = your sales Z001 condition type
• Make sure you verify that the Sales and Purchasing condition types have at least one common condition table. This is required when you reference condition records.
• In Set Calculation Schema – Purchasing, make sure you confirm that the purchasing Z001 is included in the calculation schema used for the purchase order.

Here are references for more guidance

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0e602d466b99490187fcbb30d1dc897c/7a2622a36b024a388bee6fc9...

https://help.sap.com/docs/SAP_S4HANA_CLOUD/64609d0ecac54654b0837cba34555b82/38fde2576741c112e1000000...

Since your purpose is only to display the retail sales price to the buyer, you can set this condition as statistical. This allows you to display the value for comparison without changing the PO net price.

There is one particular limitation you should keep in mind. The condition table used for the reference should contain fields that can be populated during PO pricing. If your Sales Condition record depends on fields such as Customer, Sales organisation or Distribution Channel, these values may not be available from the purchasing document.

If that is the case, the system will not find the reference record even if the access sequences look the same. So, make sure you verify the fields in the condition table before you carry out this test. See KBA 3635911 for more information.

Once you have completed the configuration, you can create a test PO in Manage Purchase Order. Enter the supplier, product purchasing organization and plant, and check the item’s pricing conditions.

Let me know if you have any further questions.

Best regards

Chris