Modify custom table from internal table

[pradeep_grandhi]

Hi,

I am trying to modify the contents of a custom table from internal table. I used the below syntax for that:

modify <table_name> from table <internal_table>.

The above statement is working for modifying one record and 10 records ata time, but, when more than 100 records it is failing. The main problem is it is showing sy-dbcnt = 100 and sy-subrc = 0 after the above line execution.

Please need your help.

Regards,

Pradeep.

[roberto_vacca2]

Hi.

Please report and verify the DB custom TABLE technical settings. Bufferization, table dimension,etc.

There's something wrong in the context memory.

Hope to help,

bye.

[pradeep_grandhi]

Hi Roberto,

The size category of the table is 0 (0 to 6500). Now the table has 6436 entries.Also the table has not buffering allowed. So, will these be a criteria for not modifying the table?

Regards,

Pradeep.

[roberto_vacca2]

Hi.

Make a try. Try to loop inside your internal table and modify record by record your DB table. If something goes wrong ad 100 sy-dbcnt well, probably there's something more to check out.

The row dimension can probably make the difference when modify/updating.

Bye

[Former Member]

Hi Pradeep,

Modify Statement Does the following.

Inserts new lines or updates existing lines in a database table . If a line with the specified primary key already exists, an INSERT is executed. Otherwise, an UPDATE is performed.

If the Custom Table Has multiple Key Fields and you are modifying any one of the key fields the system consider it has new entry and it inserts a new record,So it might be in your Scenario where the records are exceeding then the provided limit hence its failing.

Regards, Suhas.