SAP Knowledge Base Article - Public

3618224 - Only the condition "Equal to" works when exporting Internal Price/Discount List Items

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

  1. Navigate to Data workbench > Export.
  2. Select Standard Object: Internal Price/Discount List Items.
  3. In filters, select field = "Product ID" Condition = "Starts with" Value = "ABC", where ABC represents the search parameter.



  4. 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

Product

SAP Cloud for Customer core applications all versions