topic Re: Problem Populating Internal table in Application Development and Automation Discussions

Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:12:21 GMT

I have a small problem filling my internal table.I have some 10 fields in my internal table.I am filling some 5 fields in the internal table using a join and i have to fill the other 5 fields seperately ie modify the internal table after the first select query...So without looping can we do it in any easy way...

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:14:47 GMT

example:

data: begin of itab occurs 0,

field1(10),

field2(10),

end of itab.

itab-field1 = 'hello'.

modify itab transporting field1 where ....

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:17:07 GMT

select ... into (<fields>) from ...

endselect.

You will have one loop between select and endselect.

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:21:15 GMT

Hi Mavreck,

I think its not possible to modify an internal table's multiple rows without looping.

Regards,

Narinder Singh

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:23:11 GMT

hi Narinder ,

did you check the transporting option in modify?

You can modify multiple rows without looping

Re: Problem Populating Internal table

jayanthi_jayaraman — Wed, 27 Jul 2005 11:26:44 GMT

Hi,

If you are going to modify the same values[say field2 = 'ABC'] for all the records,then without loop you can do that.

Otherwise,if you need to modify it differently for each record,then

select...Endselect is the best approach.

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:40:02 GMT

Hi Joseph,

Thanks for correcting, But using transporting what i understand is that all records can only be modified with same values only. What if user want to modify each record

with different valus, he has to use loop???

Regards,

Narinder Singh

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 11:41:52 GMT

hi Narinder,

You right! sorry, i didn't thought about this possibility.

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 12:36:00 GMT

If i use modify itab transporting field bt select... endselect....Its going 4 short dump...

Re: Problem Populating Internal table

Former Member — Wed, 27 Jul 2005 12:39:31 GMT

Hi,

Actually modify ... and select ... endselect are 2 different options to solve your problem. It depends on the values that you want to modify with.

Re: Problem Populating Internal table

athavanraja — Wed, 27 Jul 2005 12:42:29 GMT

if you use modify of an itab within the select endselect, you need to tell the modify stt , that which line should be updated . something like modify .. index 5 .(to modify the 5th record) or

modify .... where <logical expression>.

Regards

Raja

Re: Problem Populating Internal table

RichHeilman — Wed, 27 Jul 2005 12:56:08 GMT

I think your best bet is to do a loop. Why would you want to hit the database more than once if you don't have to. What I mean is, doing a SELECT ENDSELECT will cause you to hit the database n times where n is the number of records that you are selecting. Why not do an array fetch, then loop at the the itab and get the rest of your fields then modify your itab. You know, LOOPS are not such a bad thing.

data: begin of itab occurs 0,
      f1 type c,
      f2 type c,
      f3 type c,
      f4 type c,      
      f5 type c,
      f6 type c,
      f7 type c,
      f8 type c,
      f9 type c,
      f10 type c,
      end of itab.

select * into corresponding fields of table itab
       from Some_Table
               where field = p_field.

loop at itab.

select Single * from some_table
        into xsome_table
                where fld1 = itab-fld1.
itab-fld6 = xsome_table-fld6.

" More code here


Modify itab.



endloop.

Regards,

Rich Heilman

Re: Problem Populating Internal table

former_member181959 — Thu, 28 Jul 2005 05:51:13 GMT

i think for that you need to use inner join.

i am giving you a sample inner join statement.

with this statement we can retrieve data from

3 tables and we can populate in a single table...

SELECT A~EBELN

A~LIFNR

A~AEDAT

B~EBELP

B~MATNR

B~NETPR

C~ETENR

C~MENGE

C~WEMNG

FROM ( EKKO AS A INNER JOIN EKPO AS B

ON A_{EBELN = B}EBELN )

INNER JOIN EKET AS C

ON A_{EBELN = C}EBELN

AND B_{EBELP = C}EBELP

INTO TABLE ITAB

WHERE A~EBELN IN PNO.

i hope it will help you.

bye...

regards,

prasad

Re: Problem Populating Internal table

Former Member — Thu, 28 Jul 2005 06:11:52 GMT

Hey,

Ths only way is to use MOVE CORRESPONDING FIELDS in the select query. And the loop that internal table.

Since if u use SELECT...END SELECT...performance will be bad. Since unnecessary access to database will take place "N" times.

Regs,

Venkat