on 07-30-2007 1:36 PM
Hi Friends
Could you please help me out for following issue.
There are some duplication of material codes were created with same characteristics.
1. how to get report of similar material codes with : Material code/ description/ Chacteristics.
2. After identification of materials what is the next process to delete material codes.( If two codes are existing one has to be delete)
bye
nirmal
Hi ,
You can get dublicate records in cl30n ;
First enter the class name and class type , press enter
Second , press F8
Than comes all materials that belongs your class . After that you can add all characteristics in your list by chosing varyant button ( Its like collored cube) .
Finally , download your list to excel . With using "CONCATENATE" formula you must first have one string from your characteristics values and sort your list by the string . And like this formula "=IF(F3=F4;0;9) " you can find dublicate materials.
In this way , you don't need ABAP programmer . You can solve it by yourself .
Note that , if you don't want to do this again, you must set your characteristis etc as Stephen says .
Hope helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
When you have set up the classification and characteristics, you should also set the flag that checks for duplicate materials. If you then allocate a class to a material and the characteristic values are the same, the system issues a warning message suggesting that this might be a duplication.
As for reporting on these duplicates, there is no standard report that will highlight the duplicates. But you can use most of the standard reports and sort them into description sequence and this may help a bit, but it will not give you exactly what you want and so it might be worth getting your ABAP programmer to build a report for you.
When you have identified the duplicates, make sure that all POs and movements have been completed and transfer the stock (if any) to the other material (MB1B with MT 309), then seet the delete flag on the material and at some stage use the archiving functionality to physically delete the record.
Steve B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.