‎2007 May 24 4:05 PM
Hai,
From which table we will get the details of the deleted material
Thanks in advance
‎2007 May 24 4:12 PM
Hello,
In the Table MARA the Field <b>LVORM</b> will tell whether tzhe material is deleted or not.
Also see the field <b>MARA-LIQDT</b> to get the Deletion date.
Regards,
Vasanth
‎2007 May 24 4:12 PM
Hello,
In the Table MARA the Field <b>LVORM</b> will tell whether tzhe material is deleted or not.
Also see the field <b>MARA-LIQDT</b> to get the Deletion date.
Regards,
Vasanth
‎2007 May 24 4:12 PM
HI,
check the tables CDPOS & CDHDR...
changed data tables... there u can see which materials r deleted..
but i believe Materials can not be deleted.. u will set a flag to it.
Regards
SAB
‎2007 May 24 4:23 PM
You've also got deletion flags(also called LVORM) on tables like MARC, MVKE etc if you just want to delete at plant ,sales level.
‎2007 May 24 4:35 PM
Best way is CDHDR,CDPOS and it has all change logs..
select * from cdhdr into table i_cdhdr
where OBJECTID in r_objectid
and USERNAME in s_usernm
and OBJECTCLAS = 'MATERIAL'
r_object id = material number..
FM : CHANGEDOCUMENT_READ_POSITIONS
Reward Points if it is useful
Thanks
Seshu