Does someone find a report that compare price item in sales contract vs price item in sales order?

[former_member133155]

Hello,

There are several report in sales, but seems missing the possibilty to follow under 1 report the price entered for an item between Contract > order > billing 

Does anyone found a way to track this information?

Thank you

Ingrid

[fegutieri · Accepted solution]

Dear Ingrid,

Good Afternoon!

Just one doubt: you could consider creating a custom CDS view based on this. Is it feasible to you?

Best Regards

[former_member133155 · Accepted solution]

Thank you Felipe,

Do you know which one is answering this needs? Have you already done it?

Everything can be considered if available in the solution

[fegutieri · Accepted solution]

Dear Ingrid,

So sorry for taking so long - it has been already one month so in case you still haven't solved this question, I am pretty much sure you will be able to achieve what you want through the creation of a custom CDS view. I noticed you tried to find an existent APP however from what I have seen, none of the available ones will meet your needs. I am not aware how much familiar you are with S4HANA Cloud or either with technical terms, but I will try to put it as simple as possible to you:

CDS view stands for Core Data Service Views which reflect the data you have in your S4HANA database - This allows you to view the information you have in your database in real time. SAP delivers some predefined CDS views called Data Sources (Purchase order header, Purchase Order Item, Sales Order Header, Sales Order Item and so on) and you can use them to create your own CDS view combining any Data Sources as you want, choosing whatever columns you want and publishing it. The catch here is to find which Data Sources provided by SAP that combined will achieve the expected outcome from your CDS view!

As far as I noticed (maybe I am wrong and you may find better ones) you could use the following: I_SalesContractItemCube, I_SalesOrderItem and

I_BillgDocItmBscStdVH. All of them have pricing information about the items in the sales contract, sales order, and billing document.

By combining them and choosing the expected outcome (which columns you would like to display in your CDS view), you will be able to extract this information to the SCP and create a new tile into your S4HC environment with a custom report.

In case you have further questions, let me know! You can also get more information from this post right here in our community: https://blogs.sap.com/2018/01/23/create-cds-views-in-sap-s4hana-cloud-and-consume-them-as-apis/

In case I have replied to your answer, please mark it as "Answered".

Thanks a lot!

[former_member133155 · Accepted solution]

Thank you for your answer

I created the CDS view, but the association seems complicated. By integrating the unit amount/total amount of the line/ total amount of the document, it is impossible to list and associate correctly the item

Any idea about association in such cases?

[Sai_Kasturi]

Hi Ingrid,

Could you please let us know if your query has been answered?

Or is there a workaround you have adopted that you can share with the community to address above issue?

Thanks

Sai

[Sai_Kasturi]

Hi Ingrid,

Currently there is no standard report to compare the prices entered in Contract - Order - Billing. The only possibility to extract this information is to develop a custom report using side-by-side extensibility.

Thanks

Sai

[former_member132363]

Here are some SAP resources you may review based on your topic "cash report,sales,sales"

Display Sales Order, Display Credit Memo Request, Display Debit ...

Display Sales Order, Display Credit Memo Request, Display Debit Memo Request, ... Other Apps in Cash Manager ... Cash Pool Transfer Reports ( Accessible).

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('VA03')/S6OP

Fiori Library

SAP Fiori Lighthouse Apps. Actual Cash Flow ... Chemical Inventory Reporting. Classify Products - Commodity ... Manage Sales Plans. Manage Teams and?...

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home

Other Apps in Order-to-Cash Process Manager

Order-to-Cash Performance - Overview ... Finance, Marketing, Sales, Service ... of the order-to-cash process without the need to open many different reports and?...

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2242')/S8OP

[former_member133155]

Thank you, but,

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('VA03')/S6OP > it is not a report

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home >> is the home fiori apps

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2242')/S8OP >> does not concerns the cloud

[former_member132363]

Here are some SAP resources you may review based on your topic "cash report,sales,sales"

Display Sales Order, Display Credit Memo Request, Display Debit ...

Display Sales Order, Display Credit Memo Request, Display Debit Memo Request, ... Other Apps in Cash Manager ... Cash Pool Transfer Reports ( Accessible).

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('VA03')/S6OP

Fiori Library

SAP Fiori Lighthouse Apps. Actual Cash Flow ... Chemical Inventory Reporting. Classify Products - Commodity ... Manage Sales Plans. Manage Teams and?...

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home

Other Apps in Order-to-Cash Process Manager

Order-to-Cash Performance - Overview ... Finance, Marketing, Sales, Service ... of the order-to-cash process without the need to open many different reports and?...

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F2242')/S8OP