Skip to Content
avatar image
Former Member

Report with purchase requisitions and purchase orders: how?

Hi,

I need to get a list of items bought with their purchase requisitions and purchase orders (when they exist). This can be done looking at each purchase order (ME23N), ou purchase requisition (ME53N), and writing it down. But in some cases, I have to do it on about 450 operations. I'd like to get this list without having to search for each requisition ou order. I can get a complete list of orders and requisitions, but without any relationship between them (they are mixed as if they were the same thing, but there´s a field telling it that row is an order or a requisition). Using some macros in excel, I can find this relationship in 40% of the cases (for example, if item 421351 was purchased only once, an order for item 421351 is related to a requisition for item 421351). Is there any way to get this list automatically? Or is there any field that tell me this relationship?

Thanks,

Francisco Morbiolo

Votorantim Cimentos

Votorantim, SP - Brazil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 05, 2007 at 06:27 PM

    Sorry, I forgot to tell this: I don´t have access to SQ01/SQ02/SQ03.

    I get the orders and requisition reports using ZGLPS020.

    Thanks,

    Francisco Morbiolo

    Votorantim Cimentos

    Votorantim, SP - Brazil

    Add comment
    10|10000 characters needed characters exceeded