topic Re: Purchase order in Application Development and Automation Discussions

Purchase order

Former Member — Fri, 01 Dec 2006 13:10:32 GMT

Hi,

In purchase order if we create a new line itme it is updating ekbe-bwart = 641, and after that if we delete that line item it is updating ekbe-bwart = 642 if we again

create line item it will update eket-bwart = 641 so i wont to read latest

line item. is there any function module for getting these details directely.

could any one help me.

Re: Purchase order

Former Member — Fri, 01 Dec 2006 13:15:03 GMT

do this way...select data from ekbe into itab.

sort itab descending.

delete adjacent duplicates from itab comparing <order>.

U will have the latest one in itab.

Re: Purchase order

Former Member — Fri, 01 Dec 2006 13:22:14 GMT

Hi,

it wont work,i already done in that way.

Message was edited by:

lakkireddy sarala

Re: Purchase order

Former Member — Fri, 01 Dec 2006 13:38:32 GMT

I think you can fetch the data from EKBE table for the document and item for the selected movt type. Order the data by posting date (i.e. EKBE-BUDAT) in descending order..and the first record would give you the last document.

Regards

Anurag