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.

RE:[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 wnash7658 (SAP Specialist and Leader)
on Aug 16 at 1:34 AM 		Mark this reply as helpfulMark as helpful
Hello,

I always consider a query first, though you have to consider "data cortersian" can occur. Based on one table have one record and another table have wo records. Though you can ensure that certain selections are made by the user. You can also add aditional ABAP to your infoset if needed too.

The Last GR can be found in table MCHA.

ABAP is a lot more dynamic and ALV is very powerful with Object Orientated.

Finally, it's all your decision.

Regards


Waza

---------------Original Message---------------
From: ravimanoj
Sent: Saturday, August 14, 2010 10:45 AM
Subject: SAP Query (using SQVI or SQ01) to include date of last goods issue and remaining shelf life

> 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
wnash7658
SAP Logistics Material Management Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
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