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

O4168 - Overview

• 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