Custom table modify problem

[Former Member]

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

[ThomasZloch]

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

[former_member214857]

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

[Marcel_Wahl]

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

[Former Member]

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