Is it possible to obtain the monthly SalesOrder amount

[kyamanaka]

Is it possible to use CDSView to extract the increase/decrease in the SalesOrder amount in a specified month as the order amount history?
An example data is as follows.
April registration SONumber: A Details: 00001  1,000,000 (JPY) → April order amount: 1,000,000 (JPY)
 May change     SONnumber: A Details: 00001  1,100,000 (JPY) → May order amount:   100,000 (JPY)
June change     SONnumber: A Details: 00001     900,000(JPY) → June order amount: - 200,000(JPY)

Is there a way to achieve this using standard functionality or InApp extension?

[AngelaDai]

hi Kyamanaka,

You can find released cds views for sales here (https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/87fae757dc3bf032e1000000...) to check if there is a cds view can fulfill your requirements. but per my finding there is no views of change history of Sales Order.

Also please kindly check these APPs which can display Changes in Objects in Sales

https://help.sap.com/docs/SAP_S4HANA_CLOUD/a376cd9ea00d476b96f18dea1247e6a5/b25a3abf5ac740bcb56b9171...

Best regards,

Angela

[kyamanaka]

Hi AngelaDai

Thanks you for the answers.
We wanted to be able to see the monthly order volume in SAC and custom analysis reports, so we needed to be able to extract it with CDSView.
Since it does not seem to exist in CDSView, it seems that there is no other way than to create the data in an external system.

Best regards,

Kyosuke