How To Fix WXPB224 - Locked totals must have at least two unlocked data cells

WXPB224 - Overview

• Message type: E = Error

• Message class: WXPB - MAP Messages: SAP R/3 Enterprise Add-On

• Message number: 224

• Message text: Locked totals must have at least two unlocked data cells

What causes this issue?

The value of the subtotal or total is locked. You try to lock the value
of one of the two remaining input ready summands. This is not possible.

System Response

When you enter a value in a data cell with a locked total or subtotal,
the change in value has to be transferred to the other unlocked
summands. This means that at least one other (so, altogther at least
two) data cells must remain ready for input if the total is locked.
For a total with n summands, a maximum of n-2 summands can be locked at
the same time.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message WXPB224 - Locked totals must have at least two unlocked data cells ?

  SAP Error Message:
  WXPB224: Locked totals must have at least two unlocked data cells
  
  
  Cause:
  This error occurs in SAP Planning or Budgeting applications (such as SAP BPC, SAP BW-IP, or SAP Analytics Cloud Planning) when you try to lock a total cell in a planning or input-ready query, but the underlying data structure or input schedule does not have at least two unlocked (editable) data cells that contribute to that total.
  In other words, the system requires that if you lock a total (aggregated) value, there must be at least two individual data cells (detailed values) that remain unlocked so that the system can distribute or allocate the total value among these unlocked cells. If there is only one or zero unlocked cells, the system cannot perform the allocation or spreading logic, hence the error.
  
  Explanation:
  
  Locked totals: Totals or aggregated values that are fixed (locked) by the user or system, meaning they cannot be