topic Re: Deleted Material in Application Development and Automation Discussions

Deleted Material

Former Member — Thu, 24 May 2007 15:05:21 GMT

Hai,

From which table we will get the details of the deleted material

Thanks in advance

Former Member — Thu, 24 May 2007 15:12:37 GMT

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

Former Member — Thu, 24 May 2007 15:12:38 GMT

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

Former Member — Thu, 24 May 2007 15:23:49 GMT

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.

Former Member — Thu, 24 May 2007 15:35:57 GMT

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