topic Re: Creating table entries in Application Development and Automation Discussions

Creating table entries

Former Member — Thu, 14 Feb 2008 09:20:18 GMT

Hi,

I am having a problem. I am trying to add data to the tables that I have created in SE11.

When I try to use the option utilities -> table contents -> create entries, the problem is that the create entries option is greyed out.

When I try to use the SM30 transaction code, when I click on the maintain button it gives me the following error message "View/table ZEMPLOY01 can only be displayed and maintained with restrictions". What should I do?

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:24:17 GMT

Hi Beatrice,

Go to SE11 and change the table maintenance attribute (on tab "Delivery and Maintenance") to "Maintenance allowed".

Regards,

John.

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:27:06 GMT

check once this point

whicle creating your table

there is one option tab

DELIVERY and MAINTANCE

in that you will find dat browser /table view maintan

if you give display / manitance aloowed then you can enter the data with out any restrictions

DefinitionThis indicator specifies whether it is possible to display/maintain a table/view using the maintenance tools Data Browser (transaction SE16) and table view maintenance (transactions SM30 and SM31).

The indicator can be set for database views, projection views, maintenance views, mantenance view variants, and tables (called 'Table/ View' below) using transaction SE11.

Note: The indicator is not available for help views since they are not relevant to SE54 and are used for search functions.

Usage

The indicator can have the following values:

Display/maintenance not allowed

The usage of standard table maintenance tools is not allowed.

Maintenance and display of this table/view is not possible in transaction SE16.

Transaction SE54 does not allow the generation of a maintenance dialog, which means automatically that calling transactions SM30/SM34 for this table/view is no longer possible.

Display/maintenance allowed to limited extent

Usage of standard table maintenance tools is allowed to a limited extent:

Transaction SE16 allows the display function for this table/view, but no maintenance.

Generation of a maintenance dialog for this table/view is possible through transaction SE54.

Transaction SM30 does not allow maintenance and display functions for this table/view.

Note: The generated dialog can be included in view clusters (data maintenance through transaction SM34) or called within a program through the function module View_Maintenance_Call.

Display/maintenance allowed

The usage of standard table maintenance tools is allowed:

Transaction SE16 allows the maintenance and display functions for this table/view.

Note: If an SM30 maintenance dialog exists, this is called.

Transaction SE54 allows the generation of a maintenance dialog for this table/view.

Transaction SM30 allows the display and maintenance functions for this table/view.

Note: The generated dialog can be included in view clusters (data maintenance through transaction SM34) or called through the function module View_Maintenance_Call in the same way as the transaction call SM30.

Comment

Only the last two options are offered for maintenance views and maintenance view variants. 'Display/maintenance not allowed' does not apply since maintenance views and maintenance view variants serve exclusively to generate a user interface. This is rejected in the option 'Display/maintenance not allowed'.

When the standard maintenance tools are used, the system checks the corresponding authorizations of the user.

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:28:27 GMT

Hi,

The good way to maintain table entries is:

1. Go the SE11, check the "Table maintainnace is allowed' option.

2. Then goto utilities, table maintainance genarator

3. in the table maintainance screen, input the auth. group & function group and screen number and finally genarate the screens.

4. Now goto SM30 or SM31, maintain the data.

Rewards please if this info is useful.

Thanks,

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:31:06 GMT

First create table miantance generator using

utilities->table maintance generator

then cretate with two screens

then check in SE30

If u not able to see field in edit mode then come back to table maintance generator and select mintainace screen no and double click on screen number you will get module pool program open

Then go to layout select filed for which you are getting display mode then goto atrribute ->program tab input filed and set input as possible save and activate.

Now check in SE30 you will get that field as in edit mode

Rewards if useful.......

Minal

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:31:09 GMT

in the delivery and Maintenance tab maintain Display and Table maintenance allowed for Data Browser/ Table View Maint.

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 09:36:31 GMT

Dear Beatrice,

There may be 2 problems,

Firstly, You may not be authorized (Table update Authoriztion ) to change , for that u may contact to your basis guy to change authorization setting.

Secondly, just check in Technical Setting that Table maintenace is allowed or not ... sud be allowed.....to enable u to update/ create the entries.

Do'nt forget for rewards point.

Regards,

P Singh

Re: Creating table entries

soumya_jose3 — Thu, 14 Feb 2008 09:50:13 GMT

Hi,

Goto SE11 give the table name goto change mode

then click on DELIVERY MAINTANCE TAB

then select option data browser/table maintance allowed as 'DISPLAY/MAINTAINCE ALLOWED.

Regards,

Soumya.

Re: Creating table entries

Former Member — Thu, 14 Feb 2008 10:04:32 GMT

Thanks alot you really helped me out.