Regarding Traction code Creation

[Former Member]

Hi All,

How to create Transation code for Database Table Entries.

I mean i have Database Table.

I have to use TCode for entering the data into that table.

If any one give the solution usefull for me.

Thanks in Advance.

Subbu.

[Former Member]

Refer this thread:

Regards,

Ravi

[Former Member]

Create a Table maintaince generator..which u can create from se11.under the menu option utilities .and then assign a TCode to that screen...

santhosh

[Former Member]

Santhosh,

Yes you are correct.

I have created table maintanance generator for table.

But how to create TCode for that screen.

Thanks,

Subbu.

[Former Member]

In the screen where u created the table maintence ..under one of the menu options u will have the option create transaction..

u can even go to the system-> status of the table control and get the program name and the screen number and use them to create a TCODE form se93

santhosh

Message was edited by:

Kaluvala Santhosh

[Former Member]

goto SE93

Give the new TCODE name-->Create

Select last radiobutton

Now Give the Transaction as SM30

At the bottom give the Name of screen field as View name

[Former Member]

Hi,

If you generate the Table maintenance generator for the Tables using SM30 you can enter data into tables.

enter SM30, enter table name and press new entries and create the data

or you can create a small program to call this TAble maintenance generator and you can attach a custom Tcode for that program

reward if useful

regards,

Anji

[Former Member]

Hi,

generate a table maintainance.

Go to Se93,Give a Tode and click on create. Then Select the radio button PArameter transaction.

Now Give the T.code in the screen as SM30 and chck the Box, Skip First screen.

The Screen No as the Table maintenance screen no and module pool as the program generated by the table maintenance. you can find the screen no and program name from the generated screen, menuoption System-> status.

At the bottom you have name of the screen fields and value.

Give screen fied name as UPDATE, Value as X.

Save, And Activate.

Regards,

[Former Member]

Hi Subramanyam,

Table maintenance is used to maintain data in the tables created (ZTABLE)

Generally for inserting new records into custom table thru transaction SM30, we need to enter all the values manually and save the record.

When certain data for the key fields needs to be populated automatically while creating entries, the steps involved are:

Maintaining the subroutine in view V_TVIMF for a particular custom table.

Logic for extracting relevant data for the fields entered, when user press enter button.

Check this blog for more information on extracting data in table maintenance.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

hi ,

1) this can be done by using the T-Code <b>SE93</b>

2) enter the z t-code name and choose create push button

3) enter the short description for t-code

4) choose the radio button<b> transaction with parameters ( parametr transaction )</b>

5) mention t-code as <b>SM30</b>

6) enter <b>VIEWNAME - > table NAME

</b> and then <b>UPDATE - > X</b>

7) save the t-code

hence the t-code is created for ur z table

reward points if helpful..

thanks,

Ginni

[Former Member]

Hi,

After u create the table,

Do the table maintainence Generator for ur table.Only then ur T code wil work.

First go to SE93

Give the name of the Tcode u want to create n press "Create".

Choose "PARAMETER transaction" option in the pop up window n click enter.

Now,

In the Default Values Tab,

Enter the transaction as SM31.

And Tick mark in the check box for Skip Initial Screen.

Click All the 3 check boxes under GUI Support.

Then below in the Default values,

Write View name : Z.... (ur Table Name)

Update : X

Click Save icon to the top.

now the T code wil b craeted for ur data base table.

U can test ur T code by enteering the t code in the command box.

*********reward points if useful.

All the best.

[Former Member]

Hi

Generate Table maintenance for the your database table

Go to SE93 Transaction, write the name of transaction u want to create

Choose option Transaction with parameters

Give Transaction : SM30

In the bottom select VIEWNAME = Give database name

UPDATE = 'X'.

Save the transaction

Thanks

Sandeep

Reward if helpful

[Former Member]

hi,

u can use module pool programming to do this u can SE84 n create some screen which link to his table an develop a TC for this screen so that when ever u enter or delete a data through this screen it wil reflect in the table also.

ravi

[Former Member]

All Are correct.

Thanks to every body with names.

Problem is solved.

Subbu.