How To Fix WXP504 - Only one quantity key figure can be assigned to interface &1

SAP Error Message - Details

• Message type: E = Error

• Message class: WXP - Retail Planning

• Message number: 504

• Message text: Only one quantity key figure can be assigned to interface &1

What causes this issue?

You want to create an <GL:AUFTEILER>allocation table</> using
<DS:de.WISP_PLINT>interface</> &V1& for planning step &V3&. The
interface must contain a quantity key figure before this can be done.
Possible key figures are all <DS:de.WISP_PLKNZ>key figures</> that
contain a unit of measure and which are assigned to the planning step.
In the interface in question, however, no key figure has been entered.

System Response

No allocation table can be created.

How to fix this error?

Assign a quantity key figure to interface &V1&.

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 WXP504 - Only one quantity key figure can be assigned to interface &1 ?

  Certainly! Here's a detailed explanation for the SAP error message:
  
  SAP Error Message:
  WXP504: Only one quantity key figure can be assigned to interface &1
  
  Cause:
  This warning message occurs in SAP BW (Business Warehouse) during the process of defining or activating an InfoProvider or during the assignment of key figures in a DataSource or transformation interface.
  
  The message indicates that more than one quantity key figure has been assigned to the same interface (e.g., a DataSource or InfoProvider interface).
  In SAP BW, only one key figure can be defined as a quantity key figure per interface because quantity key figures have special handling in aggregation and calculations.
  Assigning multiple quantity key figures to the same interface violates this rule, hence the system issues this warning.
  
  
  Explanation:
  
  Quantity key figure: A key figure that represents a measurable quantity (e.g., number of units sold, quantity ordered).
  SAP BW requires that only one key figure per interface be marked as a quantity key figure to avoid ambiguity in data processing and aggregation.
  This is especially relevant when dealing with interfaces like DataSources, InfoCubes, or DSOs where key figures are mapped.
  
  
  Solution:
  
  Check the interface &1 (the interface name will be displayed in the message) where the key figures are assigned.
  Identify all key figures marked as quantity key figures in this interface.
  Ensure only one key figure is assigned as a quantity key figure:
  
  If multiple key figures are marked as quantity key figures, decide which one should retain this status.
  For the others, remove the quantity key figure assignment.
  
  
  Save and activate the interface again.
  
  
  How to check and change quantity key figure assignment:
  
  In the SAP BW modeling tools (e.g., in the DataSource or InfoProvider maintenance screen):
  
  Go to the key figure assignment or mapping section.
  Look for the "Quantity" checkbox or indicator.
  Uncheck the quantity flag for all but one key figure.
  
  
  Alternatively, in the transformation or DTP, check the key figure properties.
  
  
  Additional Information:
  
  This is a warning message (WXP504), so it may not stop processing but should be corrected to avoid data inconsistencies.
  Quantity key figures are important for correct aggregation and calculation logic in BW.
  If you need to handle multiple quantities, consider redesigning the data model or using different interfaces.
  
  
  Summary:
  
  
  
  Aspect
  Details
  
  
  
  
  Message
  WXP504: Only one quantity key figure can be assigned to interface &1
  
  
  Cause
  More than one key figure marked as quantity key figure in the same interface
  
  
  Effect
  Potential data aggregation issues; warning during activation or processing
  
  
  Solution
  Assign only one key figure as quantity key figure per interface; remove quantity flag from others
  
  
  Where to fix
  DataSource, InfoProvider, transformation key figure assignment
  
  
  
  
  If you need help identifying the interface or key figures, you can provide the interface name (&1) from the message, and I can guide you further.
  
  Let me know if you want step-by-step instructions for a specific SAP BW object!