How To Fix O4168 - Condition type & is formula based. Mass price changes cannot be made

SAP Error Message - Details

• Message type: E = Error

• Message class: O4 - IS-Oil: MAP message pool

• Message number: 168

• Message text: Condition type & is formula based. Mass price changes cannot be made

What causes this issue?

In order to determine which prices should be modified using the Mass
Price Change function, the system examines the vendor pricing schema
and identifies the first basic price condition type which it contains.
Condition records of this condition type are then selected for
changing. In this case, the system has selected a condition type
which is formula and average based.
Using the Mass Price Change function, it is possible to increase the
rates of the selected records by either a fixed amount or a percentage.
This type of increment is meaningless in the context of a formula and
average condition record, where there is no actual rate data stored.
Prices should therefore not be maintained in this way.

System Response

An error is raised if the selection results in a condition type which
is formula and average based.

How to fix this error?

Formulae can be maintained directly within Condition records, Info.
records, Quantity contracts and Scheduling agreements by using the
Formula Maintenance function.
If the pricing <DS:DE.KALSM>schema</> of the Vendor contains additional
basic prices which are NOT formula & average based, then these CAN be
maintained using the Mass Price Change function. However, the schema
must be modified so that these condition types are included BEFORE
those which are formula & average based i.e. in and earlier step.

How can this happen?

Using the following schema it would not be possible to maintain
condition records for the standard condition type MP01 using the Mass
Price Change function. This is because it is preceeded in the schema by
a formula & average based condition type FA00.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

<DS:DE.STUNR>Step</> <DS:DE.ZAEHK>Cntr</> <DS:DE.KSCHL>CTyp</>
<DS:DE.VTXTM>Description</>
--------------------------------------------
| 10 | 0 | FA00 | Market price |
--------------------------------------------
| 15 | 0 | MP01 | Formula & Average Price|
--------------------------------------------
Using this second schema it WOULD be possible to maintain condition
records for condition type MP01 using the Mass Price Change function.
This is because it preceeds FA00 in the schema.
<DS:DE.STUNR>Step</> <DS:DE.ZAEHK>Cntr</> <DS:DE.KSCHL>CTyp</>
<DS:DE.VTXTM>Description</>
--------------------------------------------
| 10 | 0 | MP01 | Market price |
--------------------------------------------
| 15 | 0 | FA00 | Formula & Average Price|
--------------------------------------------

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message O4168 - Condition type & is formula based. Mass price changes cannot be made ?

  The SAP error message O4168 indicates that a condition type is formula-based, which means that it is calculated based on other conditions or values rather than being a fixed value. This restriction prevents mass price changes from being applied to such condition types because they are dependent on the underlying formulas and calculations.
  Cause:
  
  Formula-Based Condition Type: The condition type you are trying to change is defined as formula-based in the pricing procedure. This means that its value is derived from other conditions or calculations rather than being a static value.
  Mass Change Restrictions: SAP restricts mass changes for formula-based condition types to ensure data integrity and prevent inconsistencies that could arise from changing base values that affect the formula.
  
  Solution:
  
  Individual Changes: Instead of attempting a mass change, you may need to change the condition type values individually. This can be done through the relevant transaction (e.g., VA02 for sales orders, ME22N for purchase orders) where you can manually adjust the pricing.
  Review Pricing Procedure: Check the pricing procedure to understand how the formula-based condition type is calculated. You may need to adjust the underlying conditions that feed into the formula.
  Use Alternative Methods: If mass changes are necessary, consider using alternative methods such as:
  
  Custom ABAP Program: Develop a custom program that can handle the specific logic required for mass updates while respecting the formula-based nature of the condition type.
  Batch Input Sessions: Create batch input sessions that can process individual changes in a controlled manner.
  
  
  Consult Documentation: Review SAP documentation or consult with your SAP support team to understand the implications of changing formula-based condition types and to explore any potential workarounds.
  
  Related Information:
  
  Condition Types: In SAP, condition types are used in pricing procedures to determine how prices, discounts, and surcharges are calculated.
  Pricing Procedure: The pricing procedure defines the sequence and logic of how different condition types are applied in sales and purchasing documents.
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or updates regarding this error message or related functionality.
  
  If you continue to face issues or need further assistance, it may be beneficial to reach out to your SAP support team or consult with an SAP expert who can provide tailored guidance based on your specific configuration and requirements.