cancel
Showing results for 
Search instead for 
Did you mean: 

Updating ItemCode in OITM (Item Master) table

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member204969
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.