Table having outstanding order value

[Former Member]

Dear Friends,

We have order relates billing (no deliveries). I am trying to develop an ABAP report which shows the open sales orders with outstanding sales values.

I am using the table VBAK for sales order data and VBUK to find out the open sales orders. However in case of partially billed sales orders I am not able to find the outstanding sales value.

For example: Sales Order No 120119923 has net value 1000 USD. Created a partial invoice against sales order No 120119923 for 300 USD. My resport should show below along with other regular fields:

Sales Order No     Due Net Value

120119923             700

I am not sure which table would have 700 as in above example.

Thanks & Regards,

Rajesh Singh

[Lakshmipathi]

The subject conveys a different meaning to your post.  Ideally, it should have been Open Sale Order value.  Nevertheless, did you check VA05 where you have the option to choose "Open sale orders" ?

G. Lakshmipathi

[Shiva_Ram]

In your development, then you need to use tables VBRK/VBRP, to get the already billed values. Use this value along with sales order value to find the remaining value that needs to be billed. You can't directly read from any tables, I think.

Regards,