topic Re: Modify custom table from internal table in Application Development and Automation Discussions

Modify custom table from internal table

pradeep_grandhi — Thu, 13 Nov 2014 17:06:29 GMT

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.

Re: Modify custom table from internal table

roberto_vacca2 — Thu, 13 Nov 2014 17:19:13 GMT

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.

Re: Modify custom table from internal table

pradeep_grandhi — Thu, 13 Nov 2014 18:29:00 GMT

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.

Re: Modify custom table from internal table

Former Member — Fri, 14 Nov 2014 07:13:50 GMT

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.

Re: Modify custom table from internal table

roberto_vacca2 — Fri, 14 Nov 2014 17:29:29 GMT

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