sm30

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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.

[Former Member]

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