Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

sm30

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

former_member188685
Active Contributor
0 Kudos

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

6 REPLIES 6

former_member188685
Active Contributor
0 Kudos

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
0 Kudos

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

0 Kudos

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?

0 Kudos

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_member181995
Active Contributor
0 Kudos
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_member186143
Active Contributor
0 Kudos

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