item master data table

[Former Member]

Hi All ,

I have to update item code .so i want to know how can i update this . and i want to know if it is better to delete item data through SQL Back end .and what tables are linked to item master data table .

Thanks In advance

Areeba Ali

[Former Member · Accepted solution]

Areeba,

You must never do SQL updates, insert or delete into SAP database tables. It is not supported by SAP.

The acceptable solution for your problem would be to see if you can delete the item from Item Master Data window. Bring up the ItemCode on the Item Master Data window, right click on the window and select "Remove". If you have already used this item in a transaction, you may not be able to delete the item.

In which case, you can put the Item Inactive and create a new ItemCode and starting using this ItemCode going forward.

Krishnan

[Former Member]

Thanks ALL OF U .

Problem Solved .

[former_member186095]

Hi,

you can delete the item code using SQL statement thorugh backend using this sql query e.g. item code is B747400:

delete from dbo.oitm where itemcode = 'B747400'

if you delete it, the db will not consistent and no more support from SAP AG except you create new db and taken the opbal for the db.

The warehouse journal, all created documents and history tables will not consistent anymore after the deletion.

to prove it, you may check using this code:

select itemcode,dscription from oinm where itemcode not in (select itemcode from oitm)
select itemcode from oitw where itemcode not in (select itemcode from oitm)
select itemcode from itm1 where itemcode not in (select itemcode from oitm)
select itemcode from itw1 where itemcode not in (select itemcode from oitm)

All of the tables involve in the above queries will be affected. If the item never have any transactions, you can delete it directly using this step:

1. search the item

2. if the item is available then right click --> select remove

JimM

[Former Member]

Hi Areeba...........

This could be very serious issue if you change Used Item Code at from Backend.

As everyone is suggesting please do not try to do this as it can harm DB also.

If you got the issue then SAP can also not support you........

Regards,

Rahul

[Former Member]

Hi Areeba Ali,

Check this first:

Any items returned by the query I provided are not deletable.

Thanks,

Gordon