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

Updating ItemCode in OITM (Item Master) table

Hi Experts,

I am trying to update the ItemCode in OITM based on a temporary table we created in SQL with 2 simple columns (OldCode and NewCode).

Basically, we are trying to change the ItemCodes in OITM if they exist in OldCode and set value to NewCode.

My concern is that should we also take into account other tables or is it sufficient to modify ItemCode in OITM without affecting the system?

Thanks for you advice.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2011 at 04:38 PM

    Hi,

    Direct updating system table like OITM is not allowed. ItemCode will be everywhere in the system, You may never be manually replace all itemcode without problem.

    SAP support policy clearly specified no one should directly update system tables. If you do, you risk losing SAP support.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      it is better to make another Database.because there are nos of table linked with OITM or if you can use another field for new code then it is ok in existing database company.

      Thnaks.

      --

      Manvendra Singh Niranjan

  • Posted on Apr 22, 2011 at 12:03 PM

    There are two problems with this:

    1. You lose the SAP maintenance if you make any direct update on system tables.

    2. There are a lot of tables in the system where the reference to item master is based on the item code.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi István,

      What do you mean by "SAP Maintenance"?

      Also, are there resources from which I may know the relationship of OITM with other tables; like a relationship database diagram?

      In theory, once we update all itemcodes in all the correct tables this will not harm the system right?

      Thanks for your kind support.

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.