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

how to find tcode of a table

Hi all,

please i want to update a table in the production client. I know the table name but then i want to know its

transaction code.

how can i find the tcode attached to the table.

reward points for all use full ans.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 09:57 AM

    Hi,

    in transaction SM30 insert the table you want to update, then press the button "customizing". SAP drives you to the IMG transaction that update the table you inserted.

    Regards,

    Omkar.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2008 at 10:26 AM

    If the table is attached to a transaction using a maitenance dialog, look at table TSTCP where field PARAM contains the name of the table or of one maintenance view of this table. (and begin with /SM30 for maitenance dialog or /SM34 for clusters)

    Samples:

    >TCODE PARAM

    >AO11 /*SM30 VIEWNAME=V_T093c_03;UPDATE=X;

    >BD44 /*SM34 VCLDIR-VCLNAME=tbdsergroup;UPDATE=x;

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • try with wildcards like /SMyme1sd136*, or look for view(s) using the table (SE11 where used). Look at Development and Production system, if this table is Customizing, the programmers may have not transported the dialog maintenance in production (and you won't be able to use the transaction without opening the Customization in production)

      You could also look for the transport request used to transport the table in production, maybe the transaction to maintain it was in the same request.

      SE03 - Search for Objects in Requests/Tasks - Execute - R3TR TABL YME1SD136

      Look at transactions and programs transported along wuth the table, if there is a maintenance program or transaction, it should be in the list.

      Regards

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 12:06 PM

    look at table TSTC. It is the table for transactions. You can search there with wildcards, for example: SE* or SE.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 03:47 PM

    Is this a custom table? I tried to check our system, but we don't have this table. If there isn't a transaction already created for the table, you can create your own. Even if you don't have access to SM30, you can use SE11 to create a maintenance dialog. You then create a transaction that accesses the maintenance dialog through SM30 but skips the initial screen. Under the default values of the transaction, make these entries:

    Name of screen field Value

    UPDATE X

    VIEWNAME name of yme1sd136 maintenance view

    Then you only need authorization for the table transaction, not for SM30. We do this to give our users access to maintain specific tables without opening them up to use SM30. I hope this helps.

    - April King

    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.