Table For Open Sales Order And Customer Invoices

[Former Member]

Dear Gurus,

Are there any table to know open Sales orders and pending invoices for Customers?

Wishes,

Abhishek

[jpfriends079 · Accepted solution]

Try and use tcode VA05N, provide you required parameters and choose open sales order radio button & Execute.

For pending invoices use tcode FBL5N / FBL5 and provide customer and choose open items radio button & relevant type of item.

As already mention by Vivek, you can also got for SAP Query or Z report development, if you purpose is not solved by SAP Standard reports or transactions.

Thanks & Regards

JP

[Former Member]

Hi,

Go to T code VA05 and select open sales order radio button. Put other input parameters like date range or sold to . Execute you shal get list of all open sales order.

For pending invoices go to T code VL04 and you get list of all billing not yet created even though GI is done.

These are standard SAP functionality and can be used rather than looking in a table level.

Regards

Vivek