topic Re: duplicate records in Application Development and Automation Discussions

duplicate records

Former Member — Wed, 22 Feb 2006 20:30:57 GMT

hi,

i want to delete some duplicate records in material master,i have to delete that one by using MM02 ,how can i do that one thanx in advance.

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:33:28 GMT

Hi,

You can write a program and check the Duplicate material(Define your logic ) and then you can use the following function to delete duplicate material: BAPI_MATERIAL_DELETE

this will set deletion flag for the duplicate material.

Regards,

Lanka

Re: duplicate records

RichHeilman — Wed, 22 Feb 2006 20:35:04 GMT

What makes them duplicate? As material number field is key and you can not have duplicates, does the material description make them duplicates? If so you will need to check for duplicates in MAKT, get the material numbers which are duplicates then you can use MM17 to flag them for deletion.

Regards,

Rich Heilman

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:38:36 GMT

Hi Priya,

There cannot be duplicates for material.,if you are just checking material no. alone.

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:39:56 GMT

hi Rich Heilman,

I have duplicates in material charctersics,like rawstock and oil content.

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:40:56 GMT

Hi Priya,

You can use MM06 to flag material for deletion.

Hope this will help.

Regards,

Ferry Lianto

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:45:20 GMT

Hi Priya,

You can try functions:

BAPI_CLASS_CHANGE

BAPI_CLASS_CHARVALUE_DEL_DEP

Regards,

Lanka

Re: duplicate records

RichHeilman — Wed, 22 Feb 2006 20:46:04 GMT

You will have to write up some logic to figure out which ones are duplicates, then you can use that list of material numbers and use any of the "already mentioned" solutions for flagging the material for deletion.

Regards

RIch Heilman

Re: duplicate records

Former Member — Wed, 22 Feb 2006 20:55:33 GMT

Hi Priya,

YOu can use FM : CLAF_CLASSIFICATION_OF_OBJECTS to get all the charcterstic values. Then compare charcterstics and then you can set the deletion flag by using :BAPI_MATERIAL_DELETE

Hope this may help you.

Regards,

Lanka

Re: duplicate records

Former Member — Wed, 22 Feb 2006 21:09:55 GMT

hi Murthy,

let me explain detail,

we have some duplicates in materail charctersicks

DataPacket Data rec.Component Material Crustsurf

Re: duplicate records

Former Member — Wed, 22 Feb 2006 21:11:54 GMT

hi Murthy,

let me explain detail,

we have some duplicates in materail charctersicks

DataPacket Data rec.Component Material Crustsurf

1 20 3962 nubuck

1 21 3962 nubuck

like this so i want to delete those duplicats.

Re: duplicate records

Former Member — Wed, 22 Feb 2006 21:25:48 GMT

Hi Priya,

As I am looking in to your examples you have maintained two classes for a given material and you want to delete one class which is not relevant.

Try this function :

BAPI_CLASS_CHARVALUE_DEL_DEP

CLAF_CHECK_UDEF_CLASS_CHANGE.

Regards,

Lanka

Message was edited by: Lanka Murthy