How to differentaite between material created on & material changed ??

[Former Member]

Hi all,

How to differentiate between material created and material changed???

is there any flag or indicator present to differetiate between two....please guide me.

Thanks,

Ashu

[Former Member]

u can check the tables :CDPOS and CDHDR ..

look at field CHNGIND in CDPOS .. the values are

U, I, E, D ..

I is for insert ..

U for Update

E for Delete (single field documetation)

D for delete

[GauthamV]

hi,

check these fields in table MARA.

ERSDA - Creation date

ERNAM - Name of Person who Created the Object

LAEDA - Date of Last Change

AENAM - Name of person who changed object.

[Former Member]

Hi,

In table MARA you will find two fields ERSDA(created on) and LAEDA(date of last change).compare this two fields if both are equal then that material not changed otherwise it is changed.

Reward if useful.

Regards,

Swetha.

[Former Member]

Hi,

Write a query on mara filtering MATNR, ERSDA, LAEDA.

Those materials which dont have a LAEDA value have not been modified, those which have a value are changed materials.

tc

sajimon chandran

[Former Member]

Hi Ashu,

I just want to clarify one point from you.

i always prefer to hit MARA with below feilds, if you want track singe change of the material

ERSDA - Creation date

ERNAM - Name of Person who Created the Object

LAEDA - Date of Last Change

AENAM - Name of person who changed object.

some times material may change multiple times, in these cases we need to hit CDPOS and CDHDR

to track the material changes....

or you can create a custom table with the feild time & date of change...and when ever material getting changed

in the ME21n exit update one entry in custom table.

Many Thanks

Raghu