04-24-2007 8:59 AM
Hi All,
in which situation we can create the Open Sales Order Report.???
can any one Explain clearly..
Regards,
Vijay.
04-24-2007 9:02 AM
04-24-2007 9:03 AM
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á
04-24-2007 9:03 AM
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
04-24-2007 9:14 AM
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.
04-24-2007 9:17 AM
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
04-24-2007 9:21 AM
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
04-24-2007 9:05 AM
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