How To Fix CM_PIQ_SDPRICELIST018 - You cannot enter customer numbers both as a range and as single values

SAP Error Message - Details

• Message type: E = Error

• Message class: CM_PIQ_SDPRICELIST - Message Class for Price List

• Message number: 018

• Message text: You cannot enter customer numbers both as a range and as single values

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message CM_PIQ_SDPRICELIST018 - You cannot enter customer numbers both as a range and as single values ?

  The SAP error message CM_PIQ_SDPRICELIST018 indicates that there is an issue with how customer numbers are being entered in a particular transaction or report. Specifically, the error arises when a user attempts to input customer numbers both as a range (e.g., 1000 to 2000) and as individual customer numbers (e.g., 1001, 1002) simultaneously. This is not allowed in the system, leading to the error message.
  Cause:
  The primary cause of this error is the conflicting input format for customer numbers. In SAP, when specifying customer numbers, you can either:
  
  Enter a range of customer numbers (e.g., 1000-2000)
  Enter specific individual customer numbers (e.g., 1001, 1002)
  
  However, you cannot mix these two formats in the same input field or selection criteria. Doing so will trigger the error message CM_PIQ_SDPRICELIST018.
  Solution:
  To resolve this error, you should ensure that you are using only one method of input for customer numbers. Here are the steps to follow:
  
  
  Review Input: Check the input fields where you have entered customer numbers. Look for any mixed entries of ranges and individual numbers.
  
  
  Choose One Method:
  
  If you want to specify a range, enter the customer numbers in the format of a range only (e.g., 1000-2000).
  If you want to specify individual customer numbers, list them without any ranges (e.g., 1001, 1002, 1003).
  
  
  
  Correct the Input: Modify your input to conform to one of the acceptable formats and remove any conflicting entries.
  
  
  Re-execute the Transaction: After making the necessary corrections, try to execute the transaction or report again.
  
  
  Related Information:
  
  Transaction Codes: This error may occur in various transactions related to pricing, sales orders, or customer master data. Knowing the specific transaction code can help in troubleshooting.
  SAP Documentation: Refer to SAP Help documentation for more details on input formats and restrictions related to customer number entries.
  User Training: Ensure that users are trained on the correct input methods to avoid similar errors in the future.
  
  If the problem persists after following these steps, it may be beneficial to consult with your SAP support team or check for any specific configurations or customizations in your SAP environment that could be affecting the input handling.