We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-log-mm] SAP Query (using SQVI or SQ01) to include date of last goods issue and remaining shelf life

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by ravimanoj
on Aug 14 at 10:38 AM
Hi,

I need to create q query that will be patterned after the report in MB52.

However, I need to add certain fields. Of these additional fields, I need to include the Date of last goods issue for a particular batch of a material, and the remaining shelf life of a particular batch. Does anyone know if these are stored in a table?

To get the last goods issue date, I can get it through MSEG/MKPF and search for the date of the latest 601 movement type. But I don't know if I can include this processing in a query. This is why I want to know if this date is stored in any table, like the date of last goods receipt is stored in the batch table, and can be seen in MSC3N.

If it's not possible in a query, do you think it would be better to have this sort of report programmed through ABAP?

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
How Do You Use Social Media to Advance Your Career? Take the Survey, Win an iPad
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language