Open Sales Orders net value calculation on S/4 HANA

[shobhan_rana]

Hi all,

i would like to calculate the Net value for open sales order for a given customer.

On searching found the following text. from a sap blog for analytics.

can you tell which are the different tables are needed for the calculation. I understand it is a result of atp check.

Confirmed sales orders for which a delivery document has not yet been created in the period of the planned billing date (goods issue date). In this case, the net amount of the confirmed schedule lines is shown.

In the case of unconfirmed or partially unconfirmed sales orders, the net amount of the not yet confirmed requested schedule line is shown, and the billing date defines the analysis period, for example, month, in which the schedule line is displayed.

Kind regards

Shobhan Rana

[sanilbhandari]

Hi

By any chance if you are on S/4HANA, the below blog might be useful to you.

https://blogs.sap.com/2021/08/27/my-first-blog-post-predictive-accounting-in-sap-s-4hana-1909/

You might need help from a Finance colleague for the same.

Thanks & Regards

Sanil Bhandari

[shobhan_rana]

Hello Dear,

thanks for the reply. It is task of mearly SD.

Let me introduce you to the definition of open sales orders - "Sales orders lines or positiones (VBAP) whose delivery is not created".

Why you think the FI people can help in this case?

I wanted to know the tables involved to adress SELECT query to calculate the net nalue of open sales order lines of a given customer for a given time frame.

Best regards

Shobhan Rana

[sanilbhandari]

Hello shobhan.rana

Thanks a lot for your detailed explanation. My suggestion is exactly in line with a persona of a sales accountant who would look for such kind of information, as explained by you.

The predictive accounting looks at data outside Finance data structures and creates statistical entries, if you may in a prediction ledger. The data is read from underlying sales tables to predict possible delivery related costs as well as revenue. That shows up quite a bit of information for your finance business users, especially in the sales accounting area.

If you are on S/4HANA, this functionality needs configurations in the ledger set up. Many of the customers who look at such reports, can easily consume standard functionality already to look at future costs and revenue lines.

Hope this helps !

Thanks & Regards

Sanil Bhandari

[shobhan_rana]

Your answer does not helps.

Only the involved tables i want to know.