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

item master data table

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2010 at 01:13 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2010 at 01:23 PM

    Hi Areeba Ali,

    Check this first: active item code

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

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2010 at 03:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2010 at 04:06 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 05:06 AM

    Thanks ALL OF U .

    Problem Solved .

    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.