Symptom
It is necessary to export via DWB the "Sales Quote Price Item Details" data. However, the number of records in the task does not match the number selected in DWB tool.
Environment
SAP Cloud For Customer
Reproducing the Issue
1. Open the DWB tool.
2. Select the Object "Sales Quote Price Item Details"
3. Create a filter to export the desired data.
4. The total of objects will be e.g. 25,000 objects.
5. Once the Task is completed in the DWB Monitor, the total of objects is e.g. 3,000.
6. it is possible to see some missing data.
Cause
The issue here lies in a limitation within the SalesQuote object itself. The way data is structured and accessed does not support paging for subnodes like the PriceAndTaxCalculationItem. As a result, large datasets involving price and tax calculations cannot leverage paging directly through the SalesQuotePriceItemCollection.
In simpler terms, the SalesQuotePriceItemCollection is designed to retrieve price and tax information for a specific sales quote and its items, but there are limitations in how this data can be queried. Paging cannot be used on the subnode (price and tax calculation items) because it is tightly linked to the sales quote, and there is no special Odata query with paging for the PriceAndTaxCalculationItem object. This represents a limitation in the system’s design for sales quotes.
Resolution
This is the expected system behavior. An alternative option may be to check the SAP Cloud for Customer Ideas Forum to submit an idea: SAP Cloud For Customer Influence
Keywords
SalesQuotePriceItemCollection; export; price; item; sales quote; , KBA , LOD-LE-CQP-CO , Lean Sales Orders , Problem