Custom Sales Order and Billing Report

[Expert]

Hi Everyone,  We need a sales order report and billing report like VA05 (must be item-based) but it must also includes custom fields and pricing condition fields. We tried to create a custom report, for this we used cube CDSs but we were unable to generate a report due to the characteristics of the CDSs. The lines of the report copy one line forever. Did you ever need a report like I said? If yes, how did you solve these problems? Or do you know a report in the standard that can meet our needs?  Sales Order Report structure as below;    Best regards,  Tuncay.

[Expert · Accepted solution]

Hi Tuncay,

Retrieving the item details and additionally the pricing elements for each line item is complex. I assume this is the reason for the performance issue you are facing.

I suggest you double check the join for CDS views and apply selection criteria such as Sales area, Business Partner etc. to reduce the data volume for each run.

thanks

Sai

[Expert]

This is a re-posted Q&A of an earlier question on this community