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

Open Sales Order

Former Member — Tue, 24 Apr 2007 07:59:05 GMT

Hi All,

in which situation we can create the Open Sales Order Report.???

can any one Explain clearly..

Regards,

Vijay.

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:02:17 GMT

Refer to these related threads

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:03:22 GMT

Hi!

You can use the standard transaction VA05 to qurey the open sales orders.

If it is not enough for you, you might write your own report. Use the tables VBAK (sales order header), VBAP (sales order items), VBUK (sales document status header level), VBUP (sales document status position level).

In the status table, "A" status means the order is "Open". "B" means partially delivered. "C" means it is completed.

Regards

Tamá

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:03:26 GMT

Hi,

You have created a sales order for a product with the qty of 50 .

out of that 50 qty only 30 items were delivered. and the remaining 20 items are yet to be delivered, so in that situation that order was considered as open order.

So based on the dates we generally create a Open order report.

So Order qty(VBAP-KWMENG) and Deliver Qty(LIPS-LFIMG) gives the Open order Qty.

reward points if useful

regards,

ANJI

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:05:47 GMT

Hi Vijay

Please check transaction VA05 for open sales order report.

Look at the below link also

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/abapProgramtoCloseopenSalesorder(NotfullyConfirmed+)&

Regards

Sudheer

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:14:27 GMT

Hi Anji,

You can use the standard transaction VA05 to qurey the open sales orders.

but in which situation , we have to write our OWN prg FOR Open Sales Order.

ANY ONE REPLY PLZ..

REGARDS,

VIJAY.

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:17:08 GMT

The standard transaction will only show a limited number of fields(That too standard ones). If you want any other fields in the report, in that case we will go for a custom report.

case 1). additional data needed from standard tables which are not in VA05 now.

case 2) Custom fields appended to the standard tables which are not present in va05 now.

Regards,

Ravi

Re: Open Sales Order

Former Member — Tue, 24 Apr 2007 08:21:38 GMT

Hi Vijay.

VA05 yes gives you the list of Open Sales Orders..but you might need to create your own report if any of the selection-screen options which are given in VA05 are not required for you / or if you want more specified information, where you might need to evaluate sales orders not only on sold-to-party material and purchase order number.

santhosh