Skip to Content
author's profile photo
Former Member

How to find the last purcahse date for a material?

Hi Gurus,

Is there a way to find out the last date on which a particular material was purchased?

We all know POs are being made all the time - and some of them get cancelled

So, how can one find last purchase date from an open or close PO

Note: this is based ony on material and not on vendor

Can somebody help?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 08:23 PM

    You can use TCode SE11. The Table would be EKBE. Indicate MATNR and WERKS (if applicable) on the Field Selection Screen. The Field that you would need would be BUDAT. Click on the BUDAT Column to select it, then Sort the Column in Descending Order. You can also obtain this info in a Z-Program if need be, the logic would be the same.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 08:29 PM

    Hi Shakeel,

    Go to Se16n transaction

    and select EKBE table, there u will find so many field ranges, restrict it as u like

    u can get it there

    regards,

    subbu

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 09:16 PM

    I also should have added BWART = '101' (Goods Receipt). You can further restrict with other fields at the Data Browser Selection Screen, such as Material Document Year, etc .......

    Add comment
    10|10000 characters needed characters exceeded