topic Re: doubt in internal table. in Application Development and Automation Discussions

doubt in internal table.

Former Member — Mon, 04 Aug 2008 09:20:55 GMT

I have populated the internal table INT_TAB1 from the excel sheet

After this internal table is filled I have another internal table INT_TAB2 with structure same as INT_TAB1 with 3 additional fields.

I have transferred the contents of INT_TAB1 to INT_TAB2.Now I WANT TO FILL THE REMAINING 3 FIELDS from 3 different database tables.There s no relationship between them.

How can I do this?

Regards,

Selva

Re: doubt in internal table.

former_member195698 — Mon, 04 Aug 2008 09:23:23 GMT

I don't think there is any way other than looping at the internal table 2 and populating the fields based on the requirement and modifying your internal table

Re: doubt in internal table.

Former Member — Mon, 04 Aug 2008 09:24:22 GMT

Hi,

Fetch the values from the database table individually based on the key field in the internal table INT_TAB1 into another internal table.

Then use modify statement inside the loop at internal table INT_TAB2 to fill the values in the INT_TAB2.

Sharin.

Edited by: sharin varghese on Aug 4, 2008 2:55 PM

Re: doubt in internal table.

SuhaSaha — Mon, 04 Aug 2008 09:25:33 GMT

Can you please explain your problem in detail. AS regards what data you r uploading & which DB tables are involved.

BR,

Suhas

Re: doubt in internal table.

Former Member — Mon, 04 Aug 2008 09:26:31 GMT

Hi,

you can do it in the following way,

let s_INT_TAB1 be structure for INT_TAB2

s_INT_TAB1-field1 = (field1 value).
s_INT_TAB1-field2 = (field2 value).
s_INT_TAB1-field3 = (field3 value).

APPEND s_INT_TAB1  to INT_TAB2.

Re: doubt in internal table.

Former Member — Mon, 04 Aug 2008 09:26:57 GMT

Hi,

loop at int_tab2.

select single ur fields

into int_tab2-filed.

where condition.

modify int_tab2 from ur fields.

endloop.

hope it helps you.

Re: doubt in internal table.

Former Member — Mon, 04 Aug 2008 09:28:35 GMT

Try fetching data from the three database tables in a loop (at int_tab2) and then modifying the three fields using the command


MODIFY int_tab2 TRANSPORTING field3 INDEX sy-tabix.