topic Re: update internal table in Application Development and Automation Discussions

update internal table

Former Member — Wed, 10 Oct 2007 13:49:19 GMT

Hi!

How can I change values from an existing internal table.

Itab has in the field named FIXKZ where are set. And

now they have been to be unset. Is it possible to make

that:

UPDATE itab

SET space

WHERE FIXKZ = 'X'.

reagards

erdem

Re: update internal table

Former Member — Wed, 10 Oct 2007 13:56:45 GMT

HI,

try this:


SORT itab BY FIXKZ.
LOOP itab ASSIGNING <itab> WHERE FIXKZ  EQ 'X'.
clear <itab>-FIXKZ.
ENDLOOP.

regs

Re: update internal table

Former Member — Wed, 10 Oct 2007 13:56:47 GMT

Hi Erdem,

First declare the work area with same structure as internal table.

Loop at Itab into workarea.

Workarea-fixkz = ‘ ’.

Modify itab form workarea index sy-tabix.

Endloop.

Use the above logic, if you are facing any problems please let me know.

Regards,

Ramakrishna kotha.

Re: update internal table

abdulazeez12 — Wed, 10 Oct 2007 13:57:05 GMT

What other key fields u have in the internal table??

if u want to reset all the FIXKZ fields in the internal table then use:

loop at itab where FIXKZ = 'X'.

itab-FIXKZ = ' '.

modify itab.

endloop.

Re: update internal table

Former Member — Wed, 10 Oct 2007 13:57:47 GMT

LOOP AT ITAB WHERE FIXKZ = 'X'.

ITAB-FIXKZ = SPACE.

MODIFY ITAB INDEX SY-TABIX.

ENDLOOP.

Re: update internal table

Former Member — Wed, 10 Oct 2007 13:58:23 GMT

Hi,

U cannot use this.

Instead use this.

data: wa type same as itab.

wa-fixkz = ' '.

modify itab from wa transporting fixkz where fixkz = 'X'.

Thank you.

Award points if found useful