topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Wed, 20 Dec 2006 10:07:16 GMT

How to create the Transaction code for Table maintenance generator?

Thanks,

T.suresh

Re: Table maintenance

anversha_s — Wed, 20 Dec 2006 10:10:39 GMT

hi,

<u>how to create a a T-code for generator </u>

Go to se93.

Then create the new T.code.

Under that select parameter Transaction.

Then give the sm30 in the t.code in default values tab.

check the checkbox skip initial screen.

in classification tab.

click checkbox inherit gui attributes..

Now below..

In the default values..

WRITE

viewname = give ur table name.

show = X

save and check it once...

now u can able to call ur table through ur new t.code...

rgds

Anver

Re: Table maintenance

Former Member — Wed, 20 Dec 2006 10:13:11 GMT

1. you need generate the table maintenance using the Menu Utilities->Table maintenance generator

2. give the authorization group, package, function group, overview screen number etc.

3.create the table maintenance

4. now go to se93

5. give custom tcode and say create

then enter description , and then

choose the radio button Transaction with parameters

6. now enter tcode as SM30 and check the check box skip intial screen

7. Check all gui support buttons

8. now go down and enter VIEWNAME from F4 help and value as table name

9. and add UPDATE(choose it from F4) and value as 'X'.

VIEWNAME ZTABLE

<b>UPDATE X</b>

and save it, now check the Tcode.

Re: Table maintenance

Former Member — Wed, 20 Dec 2006 10:21:33 GMT

Thanks for reply.

Thanks,

suresh

Re: Table maintenance

anversha_s — Wed, 20 Dec 2006 10:24:49 GMT

hi,

if ur issue solved , kindly close the thread after marking helpful answers.

Reagrds

Anver

Re: Table maintenance

Former Member — Wed, 20 Dec 2006 10:45:30 GMT

Go to se93.

Create new T.code.

Select parameter Transaction.

Give sm30 in t.code in default values tab.

check checkbox skip initial screen.

in classification tab.

click checkbox inherit gui attributes..

Below..

In the default values..

WRITE

viewname = give ur table name.

show = X

save.

Re: Table maintenance

Former Member — Wed, 20 Dec 2006 11:29:03 GMT

hi srihitha,

i can solve ur problem here.

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'

I think it may help you.

with regards

magesh

Re: Table maintenance

Former Member — Wed, 20 Dec 2006 11:35:38 GMT

Hi,

SRIHITHA

table generator will check duplicate entries as any

other table .

table maintanance Generator is used to manually

input values using transaction sm30

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

using sm30 you can create entries manually.

also check below thread to assign transaction code to

table generator

create transaction use se93

select parameter transaction and give below attributes

Transaction code ZTX1

Transaction text Maintain View ZSDCZTVIEW

Transaction SM30 Screen 0

From module pool

Name of screen field Value

VIEWNAME ZSDCZTVIEW

UPDATE x

MARK HELPFULL ANSWERS AND CLOSE THE THREAD PLEASE

-charitha