creating tcode for custom table

[Former Member]

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.

[Former Member]

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

[Former Member]

hi,

u need to create a table maintenance generator for it .

thanks

[Former Member]

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.

[Former Member]

hi,

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

regards

rahul

[suredarreddy_pulimamidi]

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.

[Former Member]

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

[keerthy_k]

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.

[Former Member]

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!

[GauthamV]

You are getting this error because your custom table

doesnt contain MANDT field.

[keerthy_k]

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

[Former Member]

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

[Former Member]

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?

[dev_parbutteea]

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.

[keerthy_k]

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

[Former Member]

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.

[keerthy_k]

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

[Former Member]

thank you so much keerti

that one really solve it.

[Former Member]

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