Skip to Content
author's profile photo Former Member
Former Member

Change 2000 material numbers from K6***** numbers to 5million based numbers

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.

My question is, how do I do this? and more importantly, when I transition the materials from their K6 number to thier 5 million number, will all of the BOM's automatically update their materials lists to the 5 million numbers? There are hundreds of equipment BOM's with thousands of materials listed under them, certainly a database as large and expensive as SAP wouldn't require that all of that had to be deleted and re-done?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 12:20 AM

    let me give you some more details as to what I am dealing with.

    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


    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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.