Skip to Content
0
Former Member
May 15, 2007 at 09:05 AM

purchase orders from purchase requisition

25 Views

Hi all,

I need to get all the purchase orders (positions) from a purchase requisition. To do that the first thing you think is:

selec *

from ekpo

where BANFN = xxx and

BNFPO = xxx

But that select need several time to get the data. I haven't an index and I wouldn't like to create it.

If you have a look at ME53N (purchase requisition) at the tab Status ( level position ) the standard get the data that I need really quick. So it makes me think that there is another way more eficient to get that data that my select to the EKPO table...

I hope anybody has an idea!!!!

thanks in advance

Aaron