modifying internal table

[Former Member]

Hi friends i have the follwing reuiremnet

In ITAB1 i have matnr and some fields.

now iam selecting further data.

if itab[] is not initial.

SELECT a~matnr

werks

prctr

bklas

stprs

peinh

FROM marc AS a INNER JOIN mbew AS b

ON a_{matnr = b}matnr

INTO TABLE it_detail

FOR ALL ENTRIES IN itab

WHERE a~matnr = itab-matnr.

endif.

next iam fetching further data.

if it_detail[] is not initial.

select matnr

maktx

from makt into table it_makt

for all entries in it_detail

where matnr = it_detail-matnr.

i dont want the values in different internal table.

but i want in only one internal table.

how can i get in one internal table.

Reagrds,

priyanka.

[Former Member]

Use

INTO CORRESPONDING FIELDS OF

Regards,

Bhupal

[Former Member]

Hi,

Create one more internal table as final table and stire the values based on the the above internal tables you got.

we dont use the corresponding fields option as it is a performance issue.

Regards

Lekha

[Former Member]

after getting all relevant data do this way...

data: l_tabix like sy-tabix.

loop at itab1.

l_tabix = sy-tabix.

read table it_detail with key matnr = itab1-matnr.

if sy-subrc = 0.

move fields of it_detail to itab1 fields.

endif.

read table it_makt with key matnr = ita1-matnr.

if sy-subrc = 0.

move fields of it_makt to itab1 fields.

endif.

modify itab1 index l_tabix.

clear: itab1, it_detail, it_makt.

endloop.

[former_member745780]

Hello

Create main internal table which contain composite structure and then use

use statement

MOVE-CORRESPONDING itab to main_itab.
append main_itab.

hope this will help you.

Thanks

Anirudh

[Former Member]

use appending fields in query.

more help press F1 on appending fields and read SAP help.

[Former Member]

Hi Priyanka ,

After fetching the details in both the tables ,

Loop at itab1 .

read itab2 with key fld1 = itab-fld.

move all the required fields into final table .

Endloop.

Regards,

Chitra

[Former Member]

Hi,

first itab1 one should have all the fields....

Loop at itab1 into wa1.

read table it_detail into wa_detail with key matnr = itab1-matnr.

'if u want only few fields...

wa1-field1 = it_detail-field1.

.

.

.

.

endloop.

all the fields vil b in one internal table...