I need to get all the purchase orders (positions) from a purchase requisition. To do that the first thing you think is:
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