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

[Former Member]

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?

Thanks

Mahendra

[JL23 · Accepted solution]

all changes are stored in CDHDR and CDPOS.

CDHDR has the header information, e.g. user who made the change and when he did it. The CDPOS has the info about the content of change.

[Former Member · Accepted solution]

Thanks for your quick response. this should solve the problem