Skip to Content
Former Member
Nov 03, 2009 at 12:06 PM

how to pull a list of materials which has obolete status set, from 2years.


Hi All,

I need to pull a list a of materials which has MM-PP status = 04(marc-mmsta) set on them for the past 2 years.

i tried fetching this in MARC table but the problem here is, the users have not maintained any date in the Valid from date field(marc-mmstd) for any of the materials, so i cannot find out when exactly the status was set to 04.

i tried my luck in the table CDHDR but here, i cant find the changes done, for a particular field.

is there a table where in i can see the changes done to a particular field(say marc-mmsta) so that i can track when exactly the status was set to 04 in the material master and pull in the materials that has 04 status on them for the past 2 years?