topic Re: How to modify table record inside the loop in Application Development and Automation Discussions

How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:30:00 GMT

Hi all,

I have a problem which is to be solved urgently.

Please help me out.

I am using hashed table (which i should), and i am in the loop. for some records i have to modify the records in the table. but while i am calling modify it is going to dump.

the code is like this.

LOOP AT t_bsisbsas.

READ TABLE t_bsidbsad6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad6-kunnr.

t_bsisbsas-maber = t_bsidbsad6-maber.

MODIFY t_bsisbsas TRANSPORTING maber kunnr.

CLEAR t_bsisbsas.

ELSE.

READ TABLE t_bsidbsad_ob6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad_ob6-kunnr.

t_bsisbsas-maber = t_bsidbsad_ob6-maber.

MODIFY t_bsisbsas TRANSPORTING maber kunnr.

CLEAR t_bsisbsas.

ENDIF.

ENDLOOP.

Thanks in advance,

Umesh Vaidya

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:31:38 GMT

1)READ TABLE t_bsidbsad6

WITH table KEY bukrs = t_bsisbsas-bukrs

note.---

HASHED table will not differ in anyway id doing any operations on the table as compared to a standard table. The difference lies in when you have a READ statement the system internally uses a HASH key which will improve the performance.

use like thta..

ex...

read table i_droplist

with table key gpart = p_gpart

vkont = p_vkont.

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:34:15 GMT

Thanks Kishan,

i want to modify the record for which i am in a loop.

please look at code , where i have put "modify".

I am getting dump at there.

Thanks

Umesh Vaidya

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:34:23 GMT

change the modify statement like this and try

MODIFY <b>table</b> t_bsisbsas TRANSPORTING maber kunnr.

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:34:57 GMT

Hello Umesh,

When u r modifying an hashed table u should not use key tables in the transportation addition.

You may not use a key field as a TRANSPORTING field with HASHED or SORTED tables.

If useful reward.

Vasanth

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:35:46 GMT

you have to use where condition

MODIFY itab TRANSPORTING f1 ... fn WHERE cond.

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:36:36 GMT

Hi Umesh,

try this:

LOOP AT t_bsisbsas.

idx = sy-tabix.

READ TABLE t_bsidbsad6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad6-kunnr.

t_bsisbsas-maber = t_bsidbsad6-maber.

MODIFY t_bsisbsas TRANSPORTING maber kunnr index idx.

CLEAR t_bsisbsas.

ELSE.

READ TABLE t_bsidbsad_ob6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad_ob6-kunnr.

t_bsisbsas-maber = t_bsidbsad_ob6-maber.

MODIFY t_bsisbsas TRANSPORTING maber kunnr index idx.

CLEAR t_bsisbsas.

ENDIF.

ENDLOOP.

Regards, Dieter

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:36:48 GMT

LOOP AT t_bsisbsas.
READ TABLE t_bsidbsad6
WITH table KEY bukrs = t_bsisbsas-bukrs
gjahr = t_bsisbsas-gjahr
belnr = t_bsisbsas-belnr.
IF sy-subrc EQ 0.
t_bsisbsas-kunnr = t_bsidbsad6-kunnr.
t_bsisbsas-maber = t_bsidbsad6-maber.
MODIFY table t_bsisbsas TRANSPORTING maber kunnr.
CLEAR t_bsisbsas.
ELSE.
READ TABLE t_bsidbsad_ob6
WITH table  KEY bukrs = t_bsisbsas-bukrs
gjahr = t_bsisbsas-gjahr
belnr = t_bsisbsas-belnr.
IF sy-subrc EQ 0.
t_bsisbsas-kunnr = t_bsidbsad_ob6-kunnr.
t_bsisbsas-maber = t_bsidbsad_ob6-maber.
MODIFY table t_bsisbsas TRANSPORTING maber kunnr.
CLEAR t_bsisbsas.
ENDIF.
ENDIF.
ENDLOOP.

Re: How to modify table record inside the loop

anversha_s — Wed, 13 Sep 2006 09:37:26 GMT

hi,

chnage ur code like this.

LOOP AT t_bsisbsas.

READ TABLE t_bsidbsad6

WITH TABLE KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad6-kunnr.

t_bsisbsas-maber = t_bsidbsad6-maber.

ELSE.

READ TABLE t_bsidbsad_ob6

WITH TABLE KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad_ob6-kunnr.

t_bsisbsas-maber = t_bsidbsad_ob6-maber.

ENDIF.

MODIFY t_bsisbsas TRANSPORTING maber kunnr.

CLEAR t_bsisbsas.

ENDLOOP.

rgds

anver

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:40:18 GMT

Hi umesh,

1. Minor mistake

2. The problem is with tabix,

which gets modified with the latest value,

when READ is done.

3. so do like this.

DATA : TABIX LIKE SY-TABIX.

LOOP AT t_bsisbsas.

TABIX = SY-TABIX.

******

MODIFY t_bsisbsas INDEX TABIX.

******

MODIFY t_bsisbsas INDEX TABIX.

ENDLOOP.

regards,

amit m.

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:40:20 GMT

Hi,

LOOP AT t_bsisbsas.

READ TABLE t_bsidbsad6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad6-kunnr.

t_bsisbsas-maber = t_bsidbsad6-maber.

MODIFY t_bsisbsas .CLEAR t_bsisbsas.

ELSE.

READ TABLE t_bsidbsad_ob6

WITH KEY bukrs = t_bsisbsas-bukrs

gjahr = t_bsisbsas-gjahr

belnr = t_bsisbsas-belnr.

IF sy-subrc EQ 0.

t_bsisbsas-kunnr = t_bsidbsad_ob6-kunnr.

t_bsisbsas-maber = t_bsidbsad_ob6-maber.

MODIFY t_bsisbsas .

CLEAR t_bsisbsas.

ENDIF.

ENDLOOP.

use modify itab index sy-tabix.

Regards

amole

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:43:27 GMT

Thanks,

but i am using hashed table as i mentioned.

i got the solution.

I have to use

"modify table <tab_name> from <wa> transporting f1,..fn"

Thanks for the answer

Umesh

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:46:59 GMT

Thanks Amit for your answer.

But I am using hashed table, where you cant use explicit/implicit index mechanism.

I got the answer from chandrashekar jagarlamudi.

i have to use

"modify table <tab_name> from <wa> transporting f1,...fn."

Thanks

Umesh Vaidya

Re: How to modify table record inside the loop

Former Member — Wed, 13 Sep 2006 09:49:47 GMT

Thanks Amole for your answer.

But I am using hashed table, where you cant use explicit/implicit index mechanism.

I got the answer from chandrashekar jagarlamudi.

i have to use

"modify table <tab_name> from <wa> transporting f1,...fn."

Thanks

Umesh Vaidya