on 05-02-2010 5:12 PM
Hello,
I would like to know if there is a transaction or table where I can find the " First Goods Receipt Date" based on Material Code, like table S032 wich shows "Last Goods Receipt Date"
Kind regards,
Mary
Dear All,
Thank you for your answers,
Your solutions works of course, but I am deal with a situation when I have to check thousands of articles, a history of 2-3 years, and of course, many goods receipts, and without long time and Excel processing, does not work.
Will be more helpfull with " First Goods Receipt Date", if there is something like this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mary,
have you checked infostructure S031 for your requirement?
regards,
Adwait Bachuwar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mary,
MB51 helpful for your search. Movement type 101 with other parameters such plant, storage location. Beside that go to table EKBE, there you can find purchasing history.
rgds,
nanthakumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
go to mb51 and enter movement type 101 and you can enter other parameters like plant, storage location
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
Check with EKBE - Purchasing document history table..
Regards,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> Hello,
> I would like to know if there is a transaction or table where I can find the " First Goods Receipt Date" based on Material Code, like table S032 wich shows "Last Goods Receipt Date"
>
> Kind regards,
> Mary
The above requirement can be met through MB51 report, by searching for a material will show you all material document list. You can look for the oldest date there where goods receipt took place.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.