topic Re: sm30 in Application Development and Automation Discussions

sm30

Former Member — Tue, 02 Sep 2008 14:41:11 GMT

how to create a view on a table

in fact it should be made possible that the users as well can enter data through SM30

Re: sm30

Former Member — Tue, 02 Sep 2008 14:43:38 GMT

If it is a custom table then Create a Table maintenance and then you wll be able to enter/edit the data using SM30.

Re: sm30

Former Member — Tue, 02 Sep 2008 14:43:48 GMT

goto SE11 and go in change mode... Now, using

Utilities --> Table Maintenance Generator, create it. Specif the field attributes required and activate the same.

Now, goto SM30 and specify the table name and you can maintain the data...

Re: sm30

Former Member — Tue, 02 Sep 2008 14:51:45 GMT

how to create a view on a table

from se11.

in fact it should be made possible that the users as well can enter data through SM30

refer vijay's reply for this.

Re: sm30

Former Member — Tue, 02 Sep 2008 14:59:57 GMT

define a new tcode through se93 for example zmytable02

title 'maintain mytable'

fill in tcode sm30

check 'skip first screen'

in the bottom add 2 fields

VIEWNAME Zmytable

UPDATE X

now users can maintain only that one table through sm30 so you don't have to authorize sm30 but just you're own tcode

oh and first follow the remarks about se11 and maintenance generator mentioned earlier

kind regards

arthur de smidt

Edited by: A. de Smidt on Sep 2, 2008 5:00 PM

Re: sm30

Former Member — Tue, 02 Sep 2008 15:04:28 GMT

Thanks for the reply, but when i go in sm30 and click on 'Maintain', I get the error 'View/table /EU000/FI_ACC can only be displayed and maintained with restrictions'

wat it means?

Re: sm30

Former Member — Tue, 02 Sep 2008 15:11:07 GMT

if you have a ztable you must first change the setting in se11 to X (maintenance allowed)

then generate the table maintenance generator

ps on sap tables you are not allowed to change this, are only a few standard SAP tables that allow direct maintenance

kind regards

arthur