We have about 2000 materials that we stock that are currently identified by ID numbers starting with a K6. All these items need to be updated with a new ID number that is a 5 million number.
I have very little experience with SAP and just started in the stockroom when this transition needed to be started. There doesnt seem to be a way (that I can see) to just change the K6 number to the 5 million number.
Nobody was told how they were supposed to do this only that it needed done and that the company had a collection of home made tutorial documents that could be downloaded from thier SAP training section of thier Intranet.
According to the documents I found on that site, the following are roughly the steps that are required to complete the project:
If the matarial is not found already existing in another plant, we create a 5mil number, but if it does exist we:
Use ACD tool to Extend the material to your plant
Using transaction MM02 change the MRP type of the old number to ND and emove the Cycle Count Indicator
Use MIGO and :
Input material number where qty is to be transferred to another material number
Input material number where qty is to be recieved by another material number
click on qty tab
Qty in unit of entry: Input qty to be tranmsferred
Insure OK is selected
and click save
Physically place the transferred quantity into the repairablr bin
flag for deletion old K6 #
Enter transaction code MM02
input desired material number
follow path Goto(1), MRP1
MRP TYPE
change value to ND for mat. where qty on hand = 0
change value to MO for mat. where qty on hand =greater than 0
follow menu path GoTo(1), Plant Data/ Storage
CC phys.inv.ind.: Erase any value
CC Fixed: Ensure that this box is checked - click save
Contact Maintenance Dept to investigate task lists, open work orders, open reservations, or bills of materials for this material - material should be removed from all of these documents before flagging for deletion
Ensure that BOM's and task lists are updated with the new number
According to this procedure, everything basically has to be started over from scratch, even though we are using the exact same materials that already have their information in the system, all we need to do is change the material numbers of what we already have!
I simply cannot believe there is not an easier way! I know next to nothing about SAP but I know it is a database, with the help of VBA, I have created some fairly complicated Access databases for this and other companies, and even in the most complicated one I have ever seen you could easily change a number, primary key or not, and that new value will immediatly be what shows up, with everything else still tied to it in the way it needs to be,
Am I right to believe that there is a much easier way to do this?