list outstanding orders

blobajob
blobajob used Ask the Experts™
on
I am looking for the best transaction to use to show me a list of outstanding purchase orders within SAP, also a little instruction on achieving desired list.
I would require not to list service orders as they will obviously have no goods receipt.
If possible the list would contain vendor name, short description of order, dates, amounts

Thankyou in advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi
You can use transaction ME2L. It gives you all the list of Purchase orders.
In selection parameters you can select the type of report you want.

Hope this will help you.

Author

Commented:
That found the orders, thanks.
Is there a way of putting them in a better list?

Commented:
ME2M
displays POs by Material
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Author

Commented:
already got the list, ebbe
Looking for a way to print out the list, which is better than whats available by just using the print option, maybe move the information into excel, (is this possible). I got the same list by using the document overview in ME23N, then tried to cut and paste into excel, only problem was it didn't split the cells and all data ran into one.

Commented:
Are you in R2 not R3 environment?
I have no ME23N trans code.

I only have ME23: showing Purchase Order Overview, where you can click Item(Left side), then History (Coloumns next Car), then you will see the GRs & IRs after which you will know what's outstanding for this one PO.

Move to Excel through
System-List-Save-Local file (click speadsheet format). Then you open in Excel afterwards.

Author

Commented:
I am in R3
ME23N - display purchase order

<I only have ME23: showing Purchase Order Overview, where you can click Item(Left side), then History (Coloumns next Car), then you will see the GRs & IRs after which you will know what's outstanding for this one PO.>

This will only give me result for one PO at a time, and only the one I know to search for, what I need is a way of reporting on all orders on system which have not yet been receipted fully.


<Move to Excel through
System-List-Save-Local file (click speadsheet format). Then you open in Excel afterwards.>

This may be OK for one PO, but when many are involved the result is a bit of a mess

Commented:
ME2L      PO by Vendor
ME2M      PO by Material

It would be useful to clear one before starting on another.. Or is that the mess referred to?

Author

Commented:
I've got the searches already, what I need is a clear way to print out the results for expediting purposes.
Using Sharadd's advice, I have the list (so half the points go there), the problem is when this list is printed it isn't the easiest layout to check through.
Ideally what i want is a report that will show me, purchase order number, vendor, short description and line item. In some sort of spreadsheet if possible.

Commented:
Hi
I am sorry to say that with transaction ME2l you can get the list but not in desirable output format.

To achieve this I would suggest you use transaction of quick viewer. There you can get desired result with joining tables
EKKO and EKPO. Now to check open orders just check for field EKPO-ELIKZ. Now this field is sets to X if order item is fully received.

Hope by this you will get a desired result. In this way you will get names of vendor and material also.

Hope this helps you. If you have any problem creating quick viewer ( Transaction SQVI ) query fell free to ask.

The other possible way is to go to transaction se12 or se16.
type in view name V_EKKO_EKPO. and run your query.
But this won't give you Vendor name and material name.


Hope this helps you generating the list in desired format.



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial