3728037 - Mismatch in Number of Price/Discount List Items Exported via Data Workbench for Non‑Admin Users

When a non-admin user exports Discount/Price List Items using Data Workbench, the exported file contains fewer records than shown in the UI preview.

SAP Cloud for Customer

1. Go to Data Workbench work center.
2. Go to Export work center view.
3. Select and expand "export Price List" --> Select Internal price list/Dscount List --> In the filter put filter "PriceDiscountListID" "Starts With" "DE_".
4. Click on next.
5. In Next page - Total Records = 294 showing.
6. Note : No value showing under "Internal Price/Discount List Items" pane.
7. Click on "Export Data" (After successfully export pop up message)
8. Now, Go to Monitor WCV.
9. Open the file once the status show finished.
10. Issue or Actual behavior : Downloaded excel records are showing 24 only.
11. Expected behavior : Download excel file total record should show 294.

Note: for other fields filter and export issue is not reproducible.

Only with Field "PriceDiscountListID" "Starts With" "DE_" this issue is occurring.

During Data Workbench export, the system performs a backend join between:

Discount/Price List Items and Price List Headers

Non-admin users have restricted visibility to headers based on Release Status.
✔ Allowed header statuses for non-admins:

1 – Draft
3 – Active

❌ Restricted status:

5 – Obsolete

Because the backend join respects header-level authorization:

Items belonging to headers with Release Status = 5 (Obsolete) are automatically filtered out for non-admin users.
The UI preview does not enforce header authorization, so it shows the full count (294).
The export enforces authorization → resulting in fewer items (24).

This is a standard behavior. 

Option 1 (Recommended): Use Admin user for full export
Use an Admin user to export the complete set of Discount/Price List Items.

Option 2: Adjust Header Release Status
Change the Price/Discount List Header from:

5 → 1 (Draft) or
5 → 3 (Active)

Once the header is in an allowed status, non-admin users will be able to export all related items.

Data workbench, Export, Discount price list, Price list, Starts with. , KBA , LOD-CRM-PRC , C4C Pricing , Problem