Skip to Content
Former Member
Apr 22, 2011 at 09:45 AM

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.