topic Re: Custom table modify problem in Application Development and Automation Discussions

Custom table modify problem

Former Member — Fri, 28 May 2010 16:02:22 GMT

Hello,

I am trying to update a Z* table through SM30 but a certain field can not be updated or modified. All other fields can be changed but this certain field does not accept entries. In SM30 everything seems ok and I can save but when I run SM30 or SE16 to view table the entry is gone. I have tried also SE16 and tried to change the related field but received error 'Unable to write database record'. Is there a way to lock update to specific fields in data dictionary which prevents me from updating this field? Where should I check?

Thx in advance,

Ali

Re: Custom table modify problem

ThomasZloch — Fri, 28 May 2010 16:39:55 GMT

Is it really a table or rather a view, joining several tables?

What is the data type of this field, and which value are you trying to enter?

What is the message class and number of the error you get in SE16, does it have an explanatory long text?

Might have something to do with related check or text tables...

Thomas

Re: Custom table modify problem

former_member214857 — Fri, 28 May 2010 16:49:15 GMT

Hi Ali

If you need block some specific fields in SM30 transaction when editing entries for Z-tables you can edit object Maintenance view and enabled disable this field directly in the screen.. You can use transaction SM31 to do that.

Kind regards

Re: Custom table modify problem

Marcel_Wahl — Sat, 29 May 2010 02:28:26 GMT

Hi Ali,

try the following sequence:

1) If the field is greyed out - check setupm in SM31

2) If field is enabled

Put in the value

- Doesit directly refuse the value with an e-message?

-> then you value violated a domain or foreign key

- does it not directly complain - try to save

-> if you now get an message it might be either

+ you violated a secondary unique index on the table ( check indexes in SE11 )

+ There might be an "exit implementation" before saving if it is a

generated maintenenance view or view cluster

-> check the view in SE11 and search the menu for "exits"

Hope that helps,

Marcel

Edited by: Marcel Wahl on May 29, 2010 4:28 AM

Re: Custom table modify problem

Former Member — Mon, 31 May 2010 09:15:52 GMT

Hi,

Thx for the answers. Originally this table did not have a maintenance view. I created one and it works but this certain field does not accept entries. When I select the relevant line and enter a value to this BELNR field I save and receive no error message. But when I rerun SM30 the previous data I typed in is gone!!

Thx again,

Ali