Unable to change the entries in SM30

[Former Member]

Hi all,

In my program i am inserting records using MODIFY DBTAB.

COMMIT WORK.

After the prog execution i hv to change the entries in the DBTAB.

I am unable to change the created records.

Can u pls explain me what is happening here?

Thanks in advance

Praveen

[former_member589029]

To be able to use SM30 to modify any data in a database table you need to have a maintenance dialog generated for that table.

If you have one generated depending on the type of the dialog (maintenance allowed with restrictions) you will still not be able to modify the data.

If you need to change data through SM30 you should either create (or change to maintenance allowed without restrictions) and regenerate the table maintenance dialog. Make sure that the existing dialog doesn't have any customization to it because that will all be lost after regeneration.

The other option to change the data is would be through SE16 and debugger or through a program.

Hope that helps,

Michael

[Former Member]

Hi Michel

You are right. Table maintainance is there for the table and i am able to create, change the entries manually.

Once i update the table through program,i am unable to change the updated entries. Is this because of commit work or something else?

[Former Member]

Something else.

Is maintenance allowed in SE11?

rob

[Former Member]

Hi rob

Table maintainance allowed in se11

[Former Member]

Hi,

Primary key fields can't be changed, If possible can you please pass the table structure.

Regards,

Satya

[Former Member]

Hi satya,

when i create a table entry in sm30 i can able to make changes those the entries in sm30.

when i create an entry through program using MODIFY DBTAB.

COMMIT WORK.

it is not possible to change the values of non primary keys. eventhough it allow us to change & save , when i display the table again in sm30 the changes which i hv done are not there.

IS THERE ANY LOCKING BECAUSE OF COMMIT WORK.

[Former Member]

Are you using any Events in order to call your own code of saving the data?

If yes, then which data are you reading and saving to the DB? Are you sure you have read the 'changed' data from the screen?

[Former Member]

Hello,

I am facing a similar problem...could you pls let me know how did you resolve it?

Thanks.

Shina

[Former Member]

Praveen,

Go se11 and check in attributes whether

table maintainnance allowed Or Not.

If check box not ticked you can not chnage you values.

Pls, reward if useful....

[Former Member]

I think because of the commit work, its locking the database. Check transaction <sm12> for lock entries.

siddu

[Former Member]

give the code and the structure of the table with field types length etc....

it will be easy to solve you problem...

[franck_guillemin2]

This issue can happened if you have a numeric field in the key.

This field is store in the database as VARCHAR2 and if you load the table without fill the field with 0 the update could not be done because SM30 do that :

update <table> set fieldtext='xxxxxx' where fieldkey='001'

commit work on connection 0

no data are update but no error

in se16 you can see the table <table>

fieldkey 1

fieldtext yyyyyyy

You must have

fieldkey 001

fieldtext yyyyyyy