topic Re: table maintanance in Application Development and Automation Discussions

table maintanance

Former Member — Wed, 15 Mar 2006 13:25:13 GMT

Hai..

How can I create a transaction for Table Maintanance.

Re: table maintanance

andreas_mann3 — Wed, 15 Mar 2006 13:29:46 GMT

hi,

with TA se93 - parameter transaction -

for transaction sm30 - viewname = your table and update = X

Andreas

Message was edited by: Andreas Mann

Re: table maintanance

FredericGirod — Wed, 15 Mar 2006 13:31:55 GMT

Hi,

I hope you have allowed and create screen for SM30/SM31 for your table.

So SE93

Transaction name -> Create -> Transaction with parameters

Transaction : SM30

Skip initial screen : X

Name of screen field :

VIEWNAME / the_table_name

UPDATE / X

Save

Rgd

Frédéric

Re: table maintanance

Former Member — Wed, 15 Mar 2006 13:36:21 GMT

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

regards

kishore

Re: table maintanance

Former Member — Wed, 15 Mar 2006 14:09:38 GMT

Hi Suneel,

After creating the Table Maintenance for a table:

1) Goto transaction SE93 and enter your <transaction name>

2) Create -> Enter "Description" and select Checkbox for "Transaction with parameters"

3) In block "Default values for", enter the following values:

Transaction: SM30

Skip initial screen: X

4) In block "Default values", enter the following values:

Name of screen field | Value

|----

VIEWNAME | <Table name>

UPDATE | X

5) Save the transaction

Hope it helps.

Regards,

Neeraj Gupta