topic Re: modifying internal table in Application Development and Automation Discussions

modifying internal table

Former Member — Tue, 19 Aug 2008 13:03:47 GMT

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.

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:07:15 GMT

Use

INTO CORRESPONDING FIELDS OF

Regards,

Bhupal

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:07:37 GMT

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

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:08:13 GMT

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.

Re: modifying internal table

former_member745780 — Tue, 19 Aug 2008 13:10:22 GMT

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

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:11:06 GMT

use appending fields in query.

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

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:11:42 GMT

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

Re: modifying internal table

Former Member — Tue, 19 Aug 2008 13:13:24 GMT

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...