Table maintenance

[Former Member]

How to create the Transaction code for Table maintenance generator?

Thanks,

T.suresh

[anversha_s]

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

[Former Member]

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.

[Former Member]

Thanks for reply.

Thanks,

suresh

[anversha_s]

hi,

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

Reagrds

Anver

[Former Member]

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.

[Former Member]

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 .

Or

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

[Former Member]

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

3)

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