Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Create Transaction code for table

Former Member
0 Likes
14,414

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
4,935

FAQ. Please search in SCN before posting

8 REPLIES 8
Read only

Former Member
0 Likes
4,935

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

Read only

Former Member
0 Likes
4,935

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

Read only

Former Member
4,935

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

Read only

PedroGuarita
Active Contributor
0 Likes
4,935

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".

Read only

Former Member
4,935

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

Read only

Former Member
0 Likes
4,935

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

Read only

Former Member
0 Likes
4,936

FAQ. Please search in SCN before posting

Read only

ThomasZloch
Active Contributor
0 Likes
4,935

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