topic Modify dbtab from itab. in Application Development and Automation Discussions

Modify dbtab from itab.

Former Member — Wed, 20 Dec 2006 04:39:14 GMT

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.

Re: Modify dbtab from itab.

Former Member — Wed, 20 Dec 2006 04:42:11 GMT

USE STATEMENT LIKE -

MODIFY dbtab FROM TABLE itab.

reward points if helpful

Re: Modify dbtab from itab.

Former Member — Wed, 20 Dec 2006 04:42:38 GMT

try to use this

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

Addition:

... CLIENT SPECIFIED

regards

shiba dutta

Re: Modify dbtab from itab.

Former Member — Wed, 20 Dec 2006 04:48:37 GMT

Hi,

suppose ur table is Mara

Do like this

Modify mara from table itab

Re: Modify dbtab from itab.

Former Member — Wed, 20 Dec 2006 04:48:37 GMT

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>