Skip to Content
0
Former Member
May 24, 2010 at 07:12 AM

PO Last Purchase Price ??

44 Views

Hi ! currently I'm working on a P.O. Report. My query is :- I want to display the last purchase price of the P.O..

For this requirement, I've joined the tables EKKO & EKPO, sorted on material & plant. And now I want to fetch the last purchase price from EIPA table using the info rec no. For that how can I write a select query.

Right now I'm using :-

 SELECT SINGLE PREIS    INTO DISP-LASTPR      FROM EIPA  WHERE INFNR    = DISP-INFNR.

which is not solving the problem.

Please help.