topic Re: Internal table in Application Development and Automation Discussions

Internal table

Former Member — Thu, 25 Oct 2007 05:35:35 GMT

I have an internal table with four fields..Using query i filled the internal table with 5 records..like

field1 field2 field3 field4

12 14 12

32 43 43

7 4 5

4 55 4

8 85 91

But field4 is not filled..I want to take tht value from other table based on the field1 value as a key value for both the tables..So how can update tht particular one field..

So tht all the records will have four fields filled

Re: Internal table

Former Member — Thu, 25 Oct 2007 05:38:10 GMT

Hi Mahesh,

You can't achieve this using SELECT.

You need to get data in some other internal table and then use LOOP ..READ to move the data and MODIFY to modify the record in internal table.

Regards,

Atish

Re: Internal table

Former Member — Thu, 25 Oct 2007 05:39:28 GMT

can u plz give a sample code

Re: Internal table

former_member188827 — Thu, 25 Oct 2007 05:41:34 GMT

loop at itab.

select field4 from <table name> into itab-field4 where table_name-field1 = itab-field1.

modify itab transporting field4.

endloop.

plz reward points if ids helps

Re: Internal table

Former Member — Thu, 25 Oct 2007 05:41:43 GMT

Assume itab has field1, field2, field3, field4

ihead has field3, field4, field5

we want to moved data from ihead-field4 to itab-field4 based on common value Field3

sort ihead by field3.
loop at itab.
read table ihead with key field3 = itab-field3 binary search.
itab-field4 = ihead-field4.
modify itab.
endloop.

Re: Internal table

gopi_narendra — Thu, 25 Oct 2007 05:41:47 GMT

Check this sample code and do it accordingly

SELECT field1 field2 field3
       FROM table1
       INTO TABLE it_tab1.

SELECT field1 field4 field5
       FROM table2
       INTO TABLE it_tab2.

SORT it_tab1 BY field1.
SORT it_tab2 BY field1.

LOOP AT it_tab2.
  READ TABLE it_tab1 WITH KEY field1 = it_tab2-field1.
  IF sy-subrc = 0.
    MOVE it_tab1-field1 TO it_final.
    MOVE it_tab1-field2 TO it_final.
    MOVE it_tab1-field3 TO it_final.
    MOVE it_tab2-field4 TO it_final.
    MOVE it_tab2-field5 TO it_final.
    APPEND it_final.
  ENDIF.
  CLEAR : it_tab1, it_tab1, it_final.
ENDLOOP.

Regards

Gopi

Re: Internal table

Former Member — Thu, 25 Oct 2007 05:42:40 GMT

Hi Mahesh,

SELECT f2 f3 f4

INTO itab

FOR ALL ENTRIES iN itab1

WHERE f2 = itab1-f2

and f3 = itab1-f3.

LOOP AT itab1.

READ TABLE itab WITH KEY f2 = itab1-f2

f3 = itab1-f3.

MOVE itab-f4 to itab1-f3.

MODIFY itab1.

ENDLOOP.

Just do slight corrections

Regards,

Atish

Re: Internal table

Former Member — Thu, 25 Oct 2007 05:42:45 GMT

HI,

do like this.

loop at itab.

select single <field4> into itab-field4 from <table> where field1 = itab-field1.

modify itab.

endloop.

rgds,

bharat.

Re: Internal table

former_member386202 — Thu, 25 Oct 2007 05:43:43 GMT

Hi,

Loop on internal table. then read second internal table using read table with key

and binary search. checke sy-subrc , if it is zero then pass that value to field4 and

modify the internal table with index.

Regards,

Prashant