topic Re: creating tcode for custom table in Application Development and Automation Discussions

creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:20:22 GMT

hi experts,

i have to create a tcode for my custom table,

it would would be created for users to maintain values in the table,

how is that?

thanks.

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:22:23 GMT

Hi,

Create the Table Maintainance Generator for the table and assign the Tcode for the program.

Check this link..

Edited by: Avinash Kodarapu on Mar 2, 2009 1:54 PM

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:22:24 GMT

hi,

u need to create a table maintenance generator for it .

thanks

Re: creating tcode for custom table

suredarreddy_pulimamidi — Mon, 02 Mar 2009 08:25:10 GMT

Hi,

First You create table maintance fro the custom table and with that you can create t-code.While creating transaction using se93 select last radio button transaction with parameters,after that in default values for tab give SM30,in default tab give VIEWNAME as table name and UPDATE eq 'X'.

Regards,

Surendar Reddy.

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:27:00 GMT

Hi Dude,

First you need to create the Table maintanance generator

then use tocde se93 select the 4th option ie Transaction with parameters

Hope it may clears for your requirement

Thanks & Regards

Ramakrishna Pathi

Re: creating tcode for custom table

keerthy_k — Mon, 02 Mar 2009 08:27:32 GMT

Hi,

Here are the steps:

1) Go to SE93 and Create a Tcode.

2) Click on the u2018Transaction with parametersu2019 radio button and continue.

3) Enter the Transaction as SM30.

4) Select u2018Skip initial screenu2019.

5) Enter VIEWNAME value as Table name (here Z*) and UPDATE value as X in the u2018Name of screen fieldu2019 and save.

Note : The VIEWNAME,UPDATE and their respective values should be Capital.

Keerthi.

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:29:32 GMT

i did that already.

when i go to se 93 there seems to be an error

ZFI_SO_DETAILS <- here is the name of my table, i put this in the program field.

when i run the tcode, then i found this error!

Program "ZFI_SO_DETAILS " not found.

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:31:37 GMT

hi,

your table ZFI_SO_DETAILS must be not active , please active your table and then make the transaction code in SE93.

regards

rahul

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:34:06 GMT

hi keerthy,

its working but i would like to follow up this problem, i found this error when trying to maintain

the table "Caution: The table is cross-client" how could i address that?

thank you!

Re: creating tcode for custom table

GauthamV — Mon, 02 Mar 2009 08:36:26 GMT

You are getting this error because your custom table

doesnt contain MANDT field.

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:36:28 GMT

Hi,

u can go to transaction code se93

give transaction code neme that you want to create

and click on create

and give desc..

and click radioo button create transaction parameter

and press enter

and give Transaction as SM30 and

tick check box skip initial screen

and click sap gui support all check boxes

and in default values press f4 and select view name and in value field give as ur table name

and in second line press f4 and select update and in value field give as X,

and save it

excute .

like this we can create transaction code for table

Thanksa nd regards

Durga.K

Re: creating tcode for custom table

keerthy_k — Mon, 02 Mar 2009 08:42:14 GMT

Hi,

This will come if u have not given the Clnt(MANDT) field. ie the table is independant. U can ignore this error.

Keerthi.

Edited by: Keerthy K on Mar 2, 2009 9:42 AM

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:43:48 GMT

Hi,

It's giving the warning because you are not maintaining the MADT field, which means the

entries are not client specific.

Regards,

Manoj Kumar P

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 08:51:57 GMT

thanks keerti your such a good help,

one thing more im having this error Client 200 has status 'not modifiable.'

hence i cant maintain values for the table, what should i do?

Re: creating tcode for custom table

dev_parbutteea — Mon, 02 Mar 2009 08:56:27 GMT

Hi,

set your table's delivery and maintenance data as follows:

:- Delivery Class --> A Application table (master and transaction data)

:- Data Browser/Table View Maint. --> display and maintenance allowed

Regards.

Re: creating tcode for custom table

keerthy_k — Mon, 02 Mar 2009 09:02:40 GMT

Hi,

May be because u are not authorized to update this in clnt 200. U can update this table in some other client and save this in a request. Now using the transaction SCC1 in clnt 200, just give the request number in the Transport request and give the source clnt as the clnt number in which u have updated the table and execute.

keerthi

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 09:16:43 GMT

thanks for the help experts!

one thing more!

when i looked at sm30,

it seems the field are not displaying properly

it show a + sign.

can you help me on this one.

Re: creating tcode for custom table

keerthy_k — Mon, 02 Mar 2009 09:25:55 GMT

Hi,

U mean the field names, then it might be because of some changes made in the table after creating a table maintenance generator. If u have made any changes to the table after creating table maintenance generator then u need to re-generate the function grp. For this u can do it in two way.

1) goto transaction SE54.

2) select the tab 'edite function group'.

3) and give the fun grp name and select the 3rd radio button to re-genarate.

4) a pop-up comes wherein u need to select all the check boxes and press enter.

The function group will be re-generated.

2nd way is to delete and regenaate the fun grp in the table maintenance genarator screen itself. it will give a pop up with some check boxes. select all the check boxes and press enter. Here u need to create again the sme fn grp in se80 and activate it again. And give the fun grp name in the table maintenance genarator.

keerthi

Re: creating tcode for custom table

Former Member — Mon, 02 Mar 2009 09:44:03 GMT

thank you so much keerti

that one really solve it.