Modify dbtab from itab.

[Former Member]

Hello everyone.

I have a small issue. I am trying to modify the dbtab from itab. My itab have, say, 5 records. when i am using;

MODIFY dbtab FROM itab.

if sy-subrc eq 0.

commit work.

endif.

its just inserting one line (header line) from itab.

but if i use :-

LOOP AT ITAB.

MODIFY dbtab FROM itab.

if sy-subrc eq 0.

commit work.

endif.

ENDLOOP.

its inserting all the 5 records in dbtab. But i guess that, this lead to performance issue as iam hitting the dbtab as many times as my record in my itab . How to rectify this.

Regards.

[Former Member]

USE STATEMENT LIKE -

MODIFY dbtab FROM TABLE itab.

reward points if helpful

[Former Member]

try to use this

MODIFY dbtab FROM TABLE itab.or MODIFY (dbtabname) FROM TABLE itab.

Addition:

... CLIENT SPECIFIED

regards

shiba dutta

[Former Member]

Hi,

suppose ur table is Mara

Do like this

Modify mara from table itab

[Former Member]

hi,

just after endloop statement add <b>MODIFY target FROM TABLE itab</b> statement.

here u r not hitting dbtable for each loop.

eg.

loop at itab.

• chnage values in itab.

endloop.

<b>MODIFY dbtab FROM TABLE itab.</b>