SQL statements for the standard reports in SAP Customer Checkout manager

[elena_vavitsa]

Hello,

Can you provide the SQL statements for the standard reports contained within SAP Customer Checkout manager?

Thanks.

BR,

Elena

[bikash_bansal · Accepted solution]

Hello,
I have attached a ReportQueriesSample.txt file where most SQL queries generated for the reports are shown.
This sample do not represent 1 to 1 from Sales Report and also any changes in code (Enhancements or BugFixes) and not updated. This queries are shared for learning purpose only. They are build using complex logic and do not exists 1-1 in code.

reportqueriessample.txt

Hope it helps.

If your question in answered correctly, kindly select the answer as "Right Answer". This helps others to follow and easily locate answers.

Regards,
Bikash Bansal
Product Owner - SAP Customer Checkout

reportqueriessample.txt

[RichTRC]

Hi Bikash,

Would it be possible for you to provide the latest report sql queries?

We are testing these against the reports in FP13 PL04 and the queries are not matching what we see in the CCOM Revenue per Group report.

We believe this could be due to the more recent CCO version and reporting formula changes?

Thanks