duplicate records

[Former Member]

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.

[Former Member]

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

[RichHeilman]

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

[Former Member]

hi Rich Heilman,

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

[Former Member]

Hi Priya,

You can try functions:

BAPI_CLASS_CHANGE

BAPI_CLASS_CHARVALUE_DEL_DEP

Regards,

Lanka

[Former Member]

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

[Former Member]

hi Murthy,

let me explain detail,

we have some duplicates in materail charctersicks

DataPacket Data rec.Component Material Crustsurf

1

1

[Former Member]

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.

[Former Member]

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

or

CLAF_CHECK_UDEF_CLASS_CHANGE.

Regards,

Lanka

Message was edited by: Lanka Murthy

[Former Member]

Hi Priya,

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

[Former Member]

Hi Priya,

You can use MM06 to flag material for deletion.

Hope this will help.

Regards,

Ferry Lianto

[RichHeilman]

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