on 08-20-2007 9:05 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.