how to find tcode of a table

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Om,

I dont have the access to the tcode sm30. So please tell me an alternative to find the tcode of the table directly.

can i not find the tcode of the table by some means.

[Former Member]

Hi,

You can't attach a tcode for a table without using Table Maintanance Generator.

So you must need SM30.

Ask your manager for autharization.

Regards,

Omkar.

[Former Member]

the table is already attached to a tcode. i need to find out to which tcode the table is attached to.

[raymond_giuseppi]

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

[Former Member]

Hi raymond,

my table name is yme1sd136.

so in the table tstcp in the feild param i wrote as /*SM30 VIEWNAME=yme1sd136;UPDATE=X;

and executed the table but it says no table entry found.

can you please help me out.

[Former Member]

u try with this :

/*SM30 VIEWNAME=YME1SD136;UPDATE=X; or

/*SM30 UPDATE=X; VIEWNAME=YME1SD136; or

/*SM31 UPDATE=X;VIEWNAME=YME1SD136; or

/*SM31 VIEWNAME=YME1SD136;UPDATE=X;

Madhavi

[raymond_giuseppi]

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

[Former Member]

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

[Former Member]

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