Skip to Content
0
Former Member
Aug 29, 2008 at 04:34 PM

All Open Sales Orders Extract to a flat file

380 Views

Hi Guys,

I am basically a FI guy who has been asked to create this extarct - it would be great if you guys can help me out with it:

1) Sum of all open orders in the system which have not been shipped

2) Sum of all open orders in the system which have been shipped by not yet invoiced.

3) Sum of all open billing, invoice document created but no AR doc created.

Which tables i can consider - i have a lill. idea - VBUK and VBUP tables. What should be the criteria to get all the above.

Please help me out.

Thanks,

Maulik Shah