cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the last purcahse date for a material?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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 .......

Former Member
0 Kudos

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

Former Member
0 Kudos

hi subbu

How can we use this table.Can you guide me using some examples.Thanks for your time