topic Tcode for table maintainance in Application Development and Automation Discussions

Tcode for table maintainance

Former Member — Wed, 15 Oct 2008 05:56:27 GMT

Hi,

How to create a Tcode for table maintainance.

I have created a Z-table.

Can we create a Tcode for SM30 with table name directly.

Re: Tcode for table maintainance

Former Member — Wed, 15 Oct 2008 05:58:04 GMT

Table maintennace generator is used to create screen to maintain values in a table. Once you create maint generator you can goto transaction SM30 and add data to table . In SAP it is more relevant to customizing data.

Create a table maintance program for a z table :

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

Name of the screen field | value

VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'.

Re: Tcode for table maintainance

former_member431812 — Wed, 15 Oct 2008 07:04:09 GMT

Hi,

1. you can go to SE11 for Z-table then via menu Utilities->Table Maintenance generator

2. Go to Transaction: SE93 Create (type is parameter transaction) , here you can attached the transaction for maintaining your ztable.

This link can help you

Hope this helps,

Pragya

Re: Tcode for table maintainance

Former Member — Wed, 15 Oct 2008 08:25:41 GMT

Hi Charan,

For making tcode for table maintainance of your z-table, you first need to go to transaction se93.

There you write the name of transaction which you want to give.

Then you click on create.

give the short desc to yor transaction.

Choose last radio button for start object i.e (transaction with parameters) and click enter

Give the transaction as SM30 in Default values for section

and tick the check box "skip initial screen".

give the screen number as given in se11 table maintainance generator.

Check all the chec boxes in GUI support section.

Now in default values section at the end :

1. write name of screeen field as "VIEWNAME" and value as "<your z table name>".

2. 2nd name of screeen field as "UPDATE" and value as "X".

click on save

and execute it.

Your tcode for your z table is made.

Hope it will solve your problem.

Regards,

Nikita