topic Re: combining internal tables in Application Development and Automation Discussions

combining internal tables

Former Member — Mon, 27 Aug 2007 07:09:51 GMT

I HAVE 2 INTERNAL TABLES ITABLE AND ITABLE1.

I HAVE TO PRINT THE FIELDS FOUND IN BOTH ITABLE AND

ITABLE1.

COULD YOU PLS GIVE ME THE CODE TO COMBINE AND TO PRINT THOSE FIELDS !!!

THANKS IN ADVANCE

Re: combining internal tables

Former Member — Mon, 27 Aug 2007 07:15:00 GMT

Declear another internal table (final) containing all fields of ITAB n ITAB1.

Now looping the two table(condition Both common fields in that two ITAB n ITAB1) push all the data in to final table.

Display all the field of final table.

Message was edited by:

Kaushik Datta

Re: combining internal tables

Former Member — Mon, 27 Aug 2007 07:18:53 GMT

pl. check this sample report

DATA: BEGIN OF wa,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

fldate TYPE sflight-fldate,

bookid TYPE sbook-bookid,

END OF wa,

itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY carrid connid fldate bookid.

SELECT p_{carrid p}connid f_{fldate b}bookid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( spfli AS p

INNER JOIN sflight AS f ON p_{carrid = f}carrid AND

p_{connid = f}connid )

INNER JOIN sbook AS b ON b_{carrid = f}carrid AND

b_{connid = f}connid AND

b_{fldate = f}fldate )

WHERE p~cityfrom = 'FRANKFURT' AND

p~cityto = 'NEW YORK' AND

f_{seatsmax > f}seatsocc.

LOOP AT itab INTO wa.

AT NEW fldate.

WRITE: / wa-carrid, wa-connid, wa-fldate.

ENDAT.

WRITE / wa-bookid.

ENDLOOP.

Re: combining internal tables

former_member554803 — Mon, 27 Aug 2007 07:19:03 GMT

u can do like this

loop at ITABLE .

read table ITABLE1 with key F1 = ITABLE-F1.

if sy-subrc = 0 .

move-corresponding to ITABLE to ITABLE2

move-corresponding to ITABLE1 to ITABLE2

append ITABLE2.

endif.

endloop

where ITABLE2 is canting common fields which u need ..form ITABLE and ITABLE1 .

this will help ..if u want u can ask for clarification ... if is helpfull .. reward with some points...

Re: combining internal tables

Former Member — Mon, 27 Aug 2007 07:40:59 GMT

WHETHER I HAVE TO INCLUDE FIELDS IN BETWEEN THE CODE

MOVE CORRESPONDING ?????