Symptom
- The issue is specific to the business object "Internal Price/Discount List Items"
- When trying to export data using the conditions "Starts with" or "Contains" for Product ID, it returns zero records.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Cloud for Customer
Reproducing the Issue
- Navigate to Data workbench > Export.
- Select Standard Object: Internal Price/Discount List Items.
- In filters, select field = "Product ID" Condition = "Starts with" Value = "ABC", where ABC represents the search parameter.
- Click on Next, observe 0 records.
Cause
For the price list, only the equal to operator will work for the Product ID. The reason is technical limitations with this particular business object. It also affects the OData API for the same.
Resolution
- For price list, only the equal to operator will work for the product ID.
- As a workaround, export the data and filter it via MS Excel.
Keywords
price export, product ID, starts with, contains, zero records, salespricelist, InternalPriceDiscountListItemsCollection, Internal Price/Discount List Items , KBA , LOD-CRM-PRC , C4C Pricing , LOD-CRM-INT-API , OData API (C4C Only) , LOD-CRM-INT-DWB , Data Workbench , Problem
SAP Knowledge Base Article - Public