topic Re: Only display a table in SM30 in Application Development and Automation Discussions

Only display a table in SM30

Former Member — Tue, 26 May 2009 14:52:28 GMT

Hi All,

I need to create a transaction parameter with SM30 for a 'Z' table.

But I only need to display. The user cannot modify entries.

Does anybody know how I can do this?

Thanks,

Janete

Re: Only display a table in SM30

Former Member — Tue, 26 May 2009 15:13:43 GMT

You can do this with a table maintenance genrator. If you search the forum for this subject, you will find plenty of information.

rob

Re: Only display a table in SM30

Former Member — Tue, 26 May 2009 15:33:37 GMT

Hi Janete,

Go to Se11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

In the table maintenance generator screen, we should give Authorization Group, Function Group name (Function Group name can be same as table name), Maintenance type can be one step or two step, usually we will create with one step. we should give maintenance screen number.

Authorization Group used to group the logically related objects. It helps us to group dictionary tables for the purpose of authorization checking (Table TDDAT contains its list) . To create go to SE54, give the table name and choose authorization group and then click on create/change.

Function Group name is the name of the group to which the generated maintainence would belong.

Package if you want to assign it to a particular package.

After clicking on create button, a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.

We can view the table contents by choosing Display and we can create table entries by choosing Maintain.

PS: If you dont want the user to maintain the table contents, or if you dont to create entires and maintain the same using Data Browser (SE16) you can set the display maintainance not allowed. With this you can maintain data in the table consistently.

You use the table maintainance generator to maintain the data using the SAP Generated Function Modules. You need to take care of the SAP Locking mechanism to Create Update and Delete entries in the Table. Through Table Maintainance Generator you can achieve all of these.

Thanks and Regards

Srikanth.P

Re: Only display a table in SM30

KK07 — Tue, 26 May 2009 16:26:16 GMT

Hi,

I Think you can get this by selecting SHOW = 'X'. in Se93.

When you run the Tcode it will open in display mode only.

Anyhow,if user presses 'new entries' then it allows to enter the data.

Cheers,

Re: Only display a table in SM30

Former Member — Tue, 26 May 2009 17:27:36 GMT

Hi,

Just check the FM which is called by SM30.

In that there is an option by which you can call the table in display mode only.

You can create a Z report and call the FM in it with display option.

Regards,

Ankur Parab

Re: Only display a table in SM30

Former Member — Fri, 26 Jun 2009 13:36:09 GMT

first create a view of your table.

make sure it is a maintenance view!!

go to the maint.status tab

choose display only

activate

now go to Utilities->Table Maintenance Generator and generate a maintenance view

that's it

Re: Only display a table in SM30

Former Member — Fri, 26 Jun 2009 18:23:34 GMT

I did as you have explainde. In addition, I create te transaction for SM30 with the following options:

Name of screen field Value

VIEWNAME ZRMM_141V

VIMDYNFLDS-LTD_DTA_AR X (to permit apply filter and do not change table)

UPDATE_LTD X (to permit apply filter and do not change table)

Thanks,

Janete

Re: Only display a table in SM30

Former Member — Fri, 26 Jun 2009 18:46:34 GMT

I think this would have been much simpler with authorizations.

Rob