SAP Knowledge Base Article - Public

3552659 - Error: Value 12345 is not valid for field Product

Symptom

When you import Base Price for a Product using an Excel file, you get an Error: Value 12345 is not valid for field Product.

Environment

SAP Sales Cloud and SAP Service Cloud Version 2

Reproducing the Issue

  1. Open Navigation Menu
  2. Go to Prices
  3. Select 7PR0 - List Price under Condition Type
  4. Select INT001 - BAse Price under Condition Table
  5. Click on Import button
  6. Select File Type: Excel
  7. Click on Browse Files to select the Excel file
  8. Click on Import
  9.  Value 12345 is not valid for field Product, where 12345 is the Product Display ID

Cause

Product Display ID is entered in the field 'Application Fields_Product_ID'

Resolution

Enter Product UUID (Technical ID) instead of Display ID for the field Application Fields_Product_ID as outlined in the Field Definition sheet of Price Master Data.

Keywords

Error, value, not valid for field Product, price, master, data, condition type, condition table, uuid, technical id, display id, import, base, list , KBA , CEC-CRM-PRC , Pricing for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0