topic Re: Internal table problem in Application Development and Automation Discussions

Internal table problem

Former Member — Thu, 24 Jul 2008 05:55:52 GMT

Hi there,

I know that there is a way of modifying a record in an internal table while looping. But is it possible to modify a record in itable without a loop? And only one field should only be modified. I want to modify a record in itab. I want to modify the customer number in itab, where the customer number is 9.

In sql it is

update table set cusno = 0 where cusno = 9.

Is it possible in an internal table

Re: Internal table problem

former_member673464 — Thu, 24 Jul 2008 05:58:49 GMT

hi,

You can use the modify statement after the read statement for your requirement.

read table itab where field = 9.

if sy-subrc eq 0.

modify itab transporting field.

endif.

Regards,

Veeresh

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 05:59:41 GMT

Hi Katrina Dy,

Write read statement first and then write update sytax.

Read table itab into fs_tab with key cusno = 9.

if sy-subrc eq 0.

itab-cusno = 0.

modify ifab from fs_tab.

endif.

Regards,

Mahi.

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:03:51 GMT

Try this way:

1. Read table (itab) into wa_itab with key customer = xxx.

2. If sy-subrc = 0, get sy-tabix (index of that record).

3. set the changes that you want to make in wa_itab.

4. Modify (itab) index sy-tabix from wa_itab.

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:04:06 GMT

Hi,

http://help.sap.com/saphelp_nw04/helpdata/en/d3/2e974d35c511d1829f0000e829fbfe/frameset.htm

Regards

Jagadeesh

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:08:32 GMT

Hi Katrina,

Try to use index for modifying internal table.To modify the internal table without loop can be done through READ Statement where you can use your key fields and get the record and also index value and hence modify the table.

Thanks

Sudharshan

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:11:10 GMT

hey

am not very clear but i can send you the sample code.

Just refer to this:

SELECT carrid

connid

price

FROM sflight

UP TO 10 ROWS

INTO TABLE itab.

READ TABLE itab INDEX 1.

itab-price = itab-price - 10.

MODIFY itab INDEX 1.

Hope this helps.

Incase you dont know the index , just store the sy-tabix value into another variable say v_tabix and then modify it. The sy-tabix value must be stored immediately after you write the read statement.

I dont know any other way

hope this helps.

regards,

Ravi

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:39:03 GMT

Read table itab into wa_tab with key cusno = 9.

If sy-subrc eq 0.
wa_tab-cusno = 0.
modify ifab from wa_tab index sy-tabix.
Endif.

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:48:30 GMT

If you don't use BINARY SEARCH or a sorted table, then you can also make the full loop, there is nt much difference.

And it is usually not posible to use READ with index because the index is not known.

But you should keep the index after the READ and do the MODIY with index.

Siegfried

Re: Internal table problem

Former Member — Thu, 24 Jul 2008 06:56:01 GMT

hello,

one good way is to read that record with key values and then write a modify stmt transporting the value to be modified with where cause.......

int_tab

F1 F2 F3

A C 5

B E 3

D F 1

so now if u want to modify F3 field from int_tab with value 22 where F1 = B and F2 = E

then

read table int_tab with key F1 = B

F2 = E.

if sy-subrc = 0.

int_tab-F3 = 22.

modify int_tab trnsporting F3 where F1 = B

and F2 = E.

Endif.

Mark the post answered once ur problem is solved ....