topic select different fields into same internal table from two different db tab in Application Development and Automation Discussions

select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:05:58 GMT

Hi,

I'm selecting 3 fields from a DB table to an internal table .

there after i have to select one more field from another DB tables into same internal table.

But the second select is overwriting 1st record.

I want both to sustain as a single record.

How to do it?

Re: select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:07:16 GMT

hi,

use modify.

loop at <internal table> into <work area>.

select ur fields in work area.

modify <internal table> from <work area> transporting <that fields>

endloop.

I think it can solve ur problem.

Message was edited by:

Dhwani shah

Re: select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:08:10 GMT

You need to do a select....appending table.

You cannot modify the single record. You would need to select into another table and then modify the first table based on the data of the second.

Re: select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:10:36 GMT

Define itab1with 3 fields.

Define itab2 with 2 fields. <One field for connecting itab1 and itab2>

Get the details from table1 into itab1.

Get the details from table2 into itab2.

Loop at itab1.

l_index = sy-tabix.

read table itab2 with key <Condition>.

if sy-subrc eq 0.

Move the value from itab2 to itab1.

modify itab1 with index l_index.

endif.

endloop.

Re: select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:13:54 GMT

Hi,

refer to my code as under:

Loop at itab.

read table itab1 with key mblnr = itab-mblnr

mjahr = itab-mjahr binary search.

if sy-subrc = 0.

move-corresponding itab1 to itab.

endif.

read table itab2 with key mblnr = itab-mblnr

mjahr = itab-mjahr binary search.

if sy-subrc = 0.

move-corresponding itab2 to itab.

endif.

modify itab transporting WERKS LGORT BUDAT OIB_BLTIME.

clear: itab, itab1, itab2.

Endloop.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: select different fields into same internal table from two different db tab

Former Member — Mon, 10 Sep 2007 13:28:54 GMT

hi,

while declaring a final table.

data : begin of itab_mara occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

end of itab_mara.

data : begin of itab_marc occurs 0,

matnr like marc-matnr,

werks like marc-werks,

end of itab_marc.

data : begin of itab_final occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

matnr1 like marc-matnr, " declaration of matnr in final table

werks like marc-werks,

end of itab_final.

Reward with points if helpful.

Re: select different fields into same internal table from two different db tab

Former Member — Tue, 11 Sep 2007 13:22:15 GMT

Any reason you can't use a join?

Re: select different fields into same internal table from two different db tab

Former Member — Sat, 15 Sep 2007 12:33:02 GMT

data : begin of itab_final occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

matnr1 like marc-matnr, " declaration of matnr in final table

werks like marc-werks,

end of itab_final.

selection-screen. "using selection -screen is a good way of writing code, even if it is not necessary.

start-of-selection.

select mara~matnr

mara~ernam

marc~werks

marc~matnr

from mara as mara

inner join marc as marc on

mara_{matnr eq marc}matnr into table itab_final.

loop at itab_final.

write:/ itab_final.

endloop.

reward points, if useful.