Maintaining table thru a z-tcode

[#1]

Hi,

I have got an requirement to create a z-transaction for maintaining the z-tables. Does anyone know the steps of doing it ??

Thank You,

SB.

[Former Member · Accepted solution]

Hi,

For that you have to create a maintenance view..

Go to SE11

Choose the view radio button..

Give a view name..

Press create..

Choose the radio button "Maintenance view"

Press enter..

In the table/join conditions tab give the table name..

In the view fields tab give all the fields..

In the maint. status tab choose the radio button Read only...

Then generate the table maintenance for this view..

If you go to SM30..You can only display the table contents...

If you want Read and change..Choose the "Read and change" button in the Maint. status tab of the maintenance view..

Please make sure to reward points for helpful answers..

Thanks,

Naren

[Former Member · Accepted solution]

Thank you Naren for all your help

[Former Member]

Hi,

For display, pleas go SE93, enter the name of the tcode, click create, enter description, choose "Transaction with parameters". Click green check. Enter SM30 in transaction field, then click "Skip intiial screen". Now in the table at the bottom, you need to enter two parameters and there values.

VIEWNAME <your_table_Name>

SHOW X

Regards,

Ferry Lianto

[Former Member]

Hi SB,

Go to T-Code SE11

-Enter the table name (select Change Mode)

- Utilities-> Table Maintainance Generator

- Enter the Auth Group (&NC& --- for no auth)

- Give a Zfunction Group name (can give a new name)

-Select One step & give a screen no in the "Overview Screen"

-Press the create buton

Maintainance View for the table is created.

Now you can create T-code to with the view (same as the table name in this case),

select skip first dcreen of SM30, mention the view name and select updated = X.

Regards,

George

• reward points for helpful answers

[Former Member]

Hi,

Give the table name as the function group name..It will automatically create a function group..

Thanks,

Naren

[Former Member]

Hi Naren,

I am able to do as per the steps you wrote... thank you for your help... but my requirement is that I need 2 z-tcodes one to display only and another to maintain the z-tables... the z-tcode I did for maintaining is working well ... but the one I created just for display is not working correctly ... I mean when I click the button "New Entries"... the screen changes to change mode... is there a way I can disable the button "New Entries" for this display only z-tcode??

Thank You,

SB.

[Former Member]

Hi,

Did you generate a table maintenance for this table??

Go to SE11..

Give the table name ..Press change..

In the menu..Choose..UTILITIES -> TABLE MAINTENANCE GENERATOR..

Give a screen number..and a function group name..

Press create button...

Now the table maintenance will be created for this table..You can maintain the values in the transaction SM30..

Now create a tcode for this table using the above steps that I had mentioned..

Thanks

Naren

[Former Member]

Hi,

You need to generate table maintenance generator for your custom table in SE11.

Regards,

Ferry Lianto

[Former Member]

Hi Ferry,

I am trying to Generate the table maintenance dialogue... but getting stuck in the Function group ... how do I create a function group here ??

Thank You,

SB.

[Former Member]

Hi,

Press F4 on the screen field name...You will get VIEWNAME option..Then choose that..

Thanks,

Naren

[Former Member]

Hi Naren,

I got that ... thank you... but now when I do ctrl+F2... it says that the transaction is consistent ... but when I test it ... the message says "The maintenance dialogue for the <ztable name> is incomplete or not defined."... What is that I did not do??

Thank You,

SB.

[Former Member]

Hi,

Go to SE93, enter the name of the tcode, click create, enter description, choose "Transaction with parameters". Click green check. Enter SM30 in transaction field, then click "Skip intiial screen". Now in the table at the bottom, you need to enter two parameters and there values.

VIEWNAME <your_table_Name>

UPDATE X

Now save it.

Regards,

Ferry Lianto

[Former Member]

Hi,

GOTO SE93. Enter the transaction code and press create button. Choose the button "Transaction with parameters".

In the transaction give SM30, check skip the initial screen button.

Then in the screen fields enter the following values.

Name of the screen field value

VIEWNAME ZTABLE

UPDATE X

THanks,

Naren

[Former Member]

Hi Naren,

Under the column Name of Screen field what should I do to get "VIEWNAME" ??

Thank You,

SB.