doubt in internal table.

[Former Member]

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

[Former Member]

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

[former_member195698]

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

[Former Member]

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

[SuhaSaha]

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

BR,

Suhas

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.