topic Re: Create Transaction code for table in Application Development and Automation Discussions

Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:02:32 GMT

Dear all,

I have here a Z-Table. The customer write to me: New transaction ZSPC for the maintenance of Z-Table.

How can I do it ? they want create a tcode for a table. I think they want directly maintenance the table in SM30.

best regards

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:12:14 GMT

Make a new report and pass the tablename to function module VIEW_MAINTENANCE_CALL.

action = U (Change).

view_name = your table.

You can use excl_cua_funct to exclude certain function of the table maintenance.

dba_sellist can remain empty.

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

action = 'U'

show_selection_popup = range_limits_input

view_name = 'ZESAG'

variant_for_selection = variant

TABLES

dba_sellist = rangetab

excl_cua_funct = fu_to_excl

EXCEPTIONS

client_reference = 01

foreign_lock = 02

no_clientindependent_auth = 03

no_database_function = 04

no_editor_function = 05

no_show_auth = 06

no_tvdir_entry = 07

no_upd_auth = 08

system_failure = 09

view_not_found = 10.

Create a transaction code for this report and you're done.

With kind regards,

Roel van den Berge

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:18:16 GMT

Hi,

First create a table maintenace generator for that table. Then follow below steps to create Tcode for it.

1.Goto SE93 , give a name and click on create.

2. Select radio button transaction with paramter.

3. In transaction give as SM30.

4. At bottom default values table give as below

Viewname - give your table name

update - X

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:23:00 GMT

Hi,

Follow the bellow steps.

1.From SE11 create a table maintenace generator for that table.

2.Selct one step/two step(if onestep give the one screen number and if it is two step give the two screen umbers)

3..Afrer that Goto SE93 , give a transaction and click on create.

4. Select radio button transaction with paramter.

5. In transaction give as SM30.

6. At bottom default values table give as below

Viewname give your table name

Display X

Thats it.

Note:

display X means when the view opens it will open in display mode , if u want to change u can crtae change

if u want new entries u can create create new entries.

Regards

Re: Create Transaction code for table

PedroGuarita — Wed, 16 Jun 2010 10:28:04 GMT

Create a maintenance view for the table with table maintenance generator (SE54) and then create a transaction (SE93) for TCODE SM30 with parameters "VIEWNAME" and "UPDATE".

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:38:29 GMT

Hi,

You can create transaction for table maintainence in following way.

go to Tcode se93 and choose create and choose transaction with parameter radiobutton..

and then enter sm30 in the Transaction input field and fill thedown screen of default Values

as follows

Screen field name Value

VIEWNAME Table/view name

UPDATE 'X' for allowing maintainence

SHOW 'X' for only display

TRANSPORT 'X' for customizing

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:39:37 GMT

Hi,

You can create table maintainance for that table. Then go to se93 give any tcode name and click on create.

Then u will get popup give their tcode description and in Start object check last radio button "transaction with parameters (Parameter transaction)". Give transaction as sm30. ans check checkbox skip initial screen.

At end of that screen in table control default values.

mention like this:

Name of screen field value

UPDATE X

VIEWNAME ZTable name

and save the tcode. This will work.

Regards,

Yogesh

Re: Create Transaction code for table

Former Member — Wed, 16 Jun 2010 10:44:39 GMT

FAQ. Please search in SCN before posting

Re: Create Transaction code for table

ThomasZloch — Wed, 16 Jun 2010 11:00:22 GMT

Please search for available information before asking, do not ask basic how-to questions.

Please do not provide step by step guides to basic questions!

Thread locked.

Thomas