topic Re: how to create a tcode for table maitenance in Application Development and Automation Discussions

how to create a tcode for table maitenance

Former Member — Fri, 16 May 2008 16:19:59 GMT

i have a ztable which is having a maintenace view now i have to create a transaction code for the given table maintenance please can anyone give me the details how to create it and what steps i have to follow.

Re: how to create a tcode for table maitenance

naimesh_patel — Fri, 16 May 2008 16:24:22 GMT

You need to create Parameter Transaction.

When you create a tcode, select parameter transaction radiobutton.

Give SM30 as the tcode.

Press Enter.

Now, go to the table control.

press F4, Select Viewname ... and assign your table control name on the right side of the table control.

If you want to have display, than select DISPLAY from the F4 help and set the value 'X'.

Regards,

Naimesh Patel

Re: how to create a tcode for table maitenance

Former Member — Fri, 16 May 2008 16:52:19 GMT

thanks for quick answer, i also have to give some table which is not having a table maintenance view, and other thing is i have to have and update ability for sm30 for some other tables. here what is the differerence between parameter transaction and tcode transaction. thanks again .

Re: how to create a tcode for table maitenance

Former Member — Fri, 16 May 2008 17:34:54 GMT

Hi,

if you want to execute a transaction with default values , then you can go for parameter transaction.

for creating that

1)GOTO SE93

2)select the parameter transaction radio button

3)give the tcode value eg: MM01

4) screen no

5)check gui support checkboxes

6) given field names and values which are present on MM01 screen . so whenever you run the zmm01 tcode, the transaction gets executed with default values.

you can also skip thefirst screen.

Reward points if helpful.

Thanks and Regards.

Re: how to create a tcode for table maitenance

Former Member — Fri, 16 May 2008 22:59:56 GMT

Write simle report similar as below


*&---------------------------------------------------------------------*
*& Report  Z_RUN_TABLE_MAITENANCE.
*&
*&---------------------------------------------------------------------*

REPORT  Z_RUN_TABLE_MAITENANCE.

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
    EXPORTING
      ACTION    = 'S'
      VIEW_NAME = 'Z_MY_TABLE_MAITENANCE_NAME'.  "<--- put there name of your table maitenance

and create in transaction SE93 a transaction code for the report.

I don't remember but you must use big letters in exporting parameters of FM VIEW_MAINTENANCE_CALL

Re: how to create a tcode for table maitenance

Former Member — Mon, 19 May 2008 06:20:26 GMT

Hi Suleman,

You need to create a Parameter transaction - In SE93 while creating the tcode, specify the last option (Transaction with Parameters or Parameter Transaction).

In the subsequent screen, under the Defaults block, specify the transaction as SM30 and select the check-box 'Skip initial screen'.

At the bottom of this screen, in the list you would specify the following-

Name of screen field -

Values

UPDATE -

VIEWNAME -

Name of your table

Save all these.

***Reward points if found helpful

Regards,

Naresh

Re: how to create a tcode for table maitenance

Former Member — Mon, 19 May 2008 10:15:40 GMT

Hi Suleman,

1) Go to SE11

2) In Delivery and Maintenance TAB

i) Delivery Class as A ( most of the times)

ii) Data Browser/Table View Maint. as "Display/Maintenance Allowed"

3) Enter the required fields.

4) Goto Technical Settings.Enter the appropriate data

5) Then go to Utilities-->Table Maintenance Generator

i) Enter the Authorization Group (Varies from project to project...when no authorization required give &NC& )

ii)Function Group as "Table Name"

iii)Package varies from project to project

iv)Maintenance Type as "One Step"

a)Give overview Screen Number (Your own number..but remember)

b)Single Screen "Any number"(it can be 0 also)

6) Then click on the white color create button on menu bar(Create)

7) To view the maintenance Screen Transaction is SM30(There you need to give the table name)

😎 If you want to change the description of the fields,alignment,mandatory,greying the fields,Validations and many more

goto SE51 enter program name as "SAPL(TABLE NAME) EX:SAPLZH116 and enter the screen number what you gave in the step 5,iv,a.

9)If u want to have a transaction to table maintenance

a)Go to SE93

b)Choose "Transaction with Parameters" Radio button

c)Give the Package Name which is given in 5,iii

d)Give transaction as SM30

e)Choose Skip Initial Screen

f)In GUI Support Choose all the three options

g) In the default values Tab

Name of the Screen Field Value

UPDATE X

VIEWNAME (Enter Table Name)

After doing this goto se93..in 9(a)

1.In the home page create a prgm name..

2.give the description below description choose anyone suitable to ur project

3.Give the program name and screen number

4.In sap gui area enable all the check boxes...

cheers

Mohinder Singh Chauhan