topic Re: Open Sales Orders in Application Development and Automation Discussions

Open Sales Orders

Former Member — Fri, 27 Jan 2006 17:27:56 GMT

I need to create a report to list Open Sales Orders.What is the logic behind determining is a Sales Order is open or not?If a Sales Order has an associated Invoice and its Delivery status is completed it shouldn't be considered under Open orders right?

Re: Open Sales Orders

Former Member — Fri, 27 Jan 2006 17:33:53 GMT

Hi ,

Check table VBUK and VBUP for delivery status "LFSTK" and billing status "FKSTK".

Lanka

Message was edited by: Lanka Murthy

Re: Open Sales Orders

Former Member — Fri, 27 Jan 2006 17:33:55 GMT

Hi,

You can get the logic from VA05 Transaction.

check the check box and run the trxn.

regards

vijay

Re: Open Sales Orders

Former Member — Fri, 27 Jan 2006 17:35:34 GMT

Hi Akhila,

First check for the field VBAP-KZTLF for Open orders.VBAK-AUTLF for complete delivery.

Re: Open Sales Orders

Former Member — Fri, 27 Jan 2006 19:23:52 GMT

Hi all,

Thanks a lot for your answers.I will use these options and try to create a report.I think if my report output matches the output of VA05,then I have got it right.

Re: Open Sales Orders

Former Member — Sat, 28 Jan 2006 04:09:05 GMT

Yes exactly, your report output and VA05 Open order should match.

regards

vijay