topic Re: code to get latest purchase requisition in Application Development and Automation Discussions

code to get latest purchase requisition

Former Member — Wed, 15 Apr 2009 11:52:15 GMT

hello,

i have to built a report for purchase requisition i got stuck while finding the latest purchase order so how i can solve this problem

Re: code to get latest purchase requisition

tarangini_katta — Wed, 15 Apr 2009 12:04:57 GMT

Hi,

Waht do you mean by latest purchese order.

U can get purchase order based on date created.

EKKO-ERDAT.

Can you please explain u r question clearly.

Thanks

Re: code to get latest purchase requisition

Former Member — Wed, 15 Apr 2009 12:10:27 GMT

go to cdhdr table sort internal table with date and time in decending order,

Re: code to get latest purchase requisition

Former Member — Wed, 15 Apr 2009 12:11:53 GMT

pick the first one. give the respective object class

Re: code to get latest purchase requisition

Former Member — Thu, 16 Apr 2009 05:37:20 GMT

hiiiiii,

i want the latest PO OF PARTICULAR ITEM.

IT MEANS IF AN ITEM HAVING THREE PO WITH BWART - 101 101 102(REVERSAL) OF SAME DATE 04.04.2009 SO MY CODING WILL OF THAT TYPE THROUGH THAT I SHOULD GET LATEST PO MEANS IF 102 IS LATEST THEN IT SHOULD BE DISPLAY WITH ITS QUANTITY RATE AND SUPPLIER NAME.BUT RIGHT NOW ACCORDING TO MY PROGRAM IT SHOWING 1ST BWART-101 VALUES IS IT NEED TO SORT IF SO THEN WHICH TABLE I HV TO SORT??

IAM USING TABLES - EBAN FOR PR, MSEG,EKBE, LFA1.

Re: code to get latest purchase requisition

Former Member — Thu, 16 Apr 2009 06:05:41 GMT

Hello

You have purchase requisition. So, EBAN-BANFN and EBAN-BNFPO.

1. Goto EKET with EBAN-BANFN and EBAN-BNFPO and get all EKET-EBELN and EKET-EBELP for particular position.

2. Select from EKBE into internal table all records with EBELN = EKET-EBELN and EBELP = EKET-EBELP and BWART between '101' and '102'.

3. Sort this internal table by EBELN and BELNR. Last record will have latest PO number.