Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

material age

Former Member
0 Kudos

hi friends .

i have to prepare a report for materials age. could any one help me what fields i require and from which table i can retrieve the data?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hai,

mseg-VFDAT----Shelf Life Expiration or Best-Before Date .

take delivery date for the material from lips table

material age = mseg-VFDAT - delivery date.

shan.

4 REPLIES 4

Former Member
0 Kudos

Hi this is a tricky program, and very long development.

basically you're program should compute on first in first out basis in calculating the age of materials on company code level. lets say you have a ztable that store materials, company code, plant, storage location, qty, date, transaction. bare in mind that whatever transaction made by user lets say. goods issue to prod you dont have to compute the age of materials, transfer posting to other plant or storage loc you should compute age base on origin of the material. good received GR start of counting of age. you'll get this info in MSEG table, and dont forget to consider the reversal of each transaction.. Good luck

Former Member
0 Kudos

hai,

mseg-VFDAT----Shelf Life Expiration or Best-Before Date .

take delivery date for the material from lips table

material age = mseg-VFDAT - delivery date.

shan.

former_member181995
Active Contributor
0 Kudos

may be you can use MC.9 standard report.

No Need of any customized report.

Edited by: Ámit Güjärgoüd on Sep 29, 2008 11:04 AM

0 Kudos

how can i check material age in mc.9 transaction?

can you tell me the parameters that are used to check age of material?

thanks&regards

deepika.