cancel
Showing results for 
Search instead for 
Did you mean: 

Report with purchase requisitions and purchase orders: how?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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