topic Re: Internal Table Entry in Application Development and Automation Discussions

Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:21:29 GMT

Prob: I want to insert a record into an Internal Table.

But the values of the fields of Internal Table are scattered in different tables.

The situation is like that I cannot use a join condition or for all entries here.

Query: Advise me how can I retrieve values and enter them to Internal Table fields in compliance with SELECT statements for different tables.

Thx

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:25:07 GMT

hi,

use for all entries

For ex:-

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ it_bkpf-bukrs AND

belnr EQ it_bkpf-belnr AND

gjahr EQ it_bkpf-gjahr.

Reward if useful

Regards

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:29:32 GMT

Sorry.. This is not possible in my requirement

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:31:37 GMT

Hi, Santo.

I think we can select values from different tables into a work area, may be use many 'select' statements, then append or insert this work area to the internal table.

Regards,

feng.

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:32:18 GMT

use

loop at internaltablename into wa.

modify finalinternaltable from wa.

endloop.

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:32:58 GMT

use data extract to get the fields....

each row will fetch the fields in different tables ...

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:33:03 GMT

Hi,

Loop the internal table and fetch data from the tables for each record and modify the table.

Loop at itab.

select f1 into itab-f1

from Zxxx

where f2 = itab-f2.

modify itab transporting f1.

endloop.

Hope this helps you.

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:33:25 GMT

Hi,

Use subqueries.

Regards,

Renjith Michael.

Re: Internal Table Entry

Vijay — Fri, 11 Jan 2008 07:36:17 GMT

hi,

you can select fields from one table into an internal table and then can use

FOR ALL ENTRIES IN to fetch the data from another database table based on the field in the internal table.

for ex....

select A B C from db_table

into it_tab.

select X Y Z from db_table2

into it_tab2

for all entries in it_tab

where x = it_tab-A.

IF u have to fetch the fields from db_table based on the fields from more then one table then u can use range and fetch based on both range and for all entries in.

for ex.

select X Y Z from db_table2

into it_tab2

for all entries in it_tab

where x = it_tab-A and

y in r_range.

regards

vijay

reward points if helpfull

Re: Internal Table Entry

RoySayak — Fri, 11 Jan 2008 07:44:08 GMT

Hi Santo,

You can try it...

SELECT f1 f2 f3 f4 f5

FROM main1 INTO TABLE it_main1

WHERE f1 IN <S1>.

SORT it_main1 BY f1.

IF it_main1[] IS NOT INITIAL.

SELECT a1 a2 a3 a4 a5

FROM table1 INTO TABLE it_table1

FOR ALL ENTRIES IN it_main1

WHERE a1 = it_main1-f1.

SELECT ******

******

SELECT******

*****

******

ENDIF.

LOOP AT it_table1 INTO wa_table1.

READ TABLE it_main1 INTO wa_main1 WITH KEY f1 = wa_table1-a1.

wa_final-x1 = wa_table1-a1.

wa_final-x2 = wa_table1-a2.

wa_final-x3 = wa_main1-f2.

wa_final-x4 = wa_main1-f3.

wa_final-x5 = wa_main1-f5.

wa_final-x6 = wa_table2-p1.

wa_final-x7 = wa_table2-p6.

APPEND wa_final TO it_final.

ENDLOOP.

Regards,

Sayak... ..."reward if it is helpful"

Re: Internal Table Entry

Former Member — Fri, 11 Jan 2008 07:53:07 GMT

Not Solved the problem!