topic Re: intersection from 3 tables in Application Development and Automation Discussions

intersection from 3 tables

Former Member — Tue, 14 Nov 2006 13:50:52 GMT

Hellow I have an 3 selects and n all select I doing iNTO CORRESPONDING FIELDS OF TABLE itab (1,2,3) how can Iintersection from the 3 tables (values I wont) into one table .example is very help regards

Re: intersection from 3 tables

Former Member — Tue, 14 Nov 2006 13:54:50 GMT

Hello,

Declare one final table...

LOOP AT ITAB1.

MOVE-CORRESPONDING TO ITAB1 to ITAB_FINAL.

READ TABLE ITAB2 WITH KEY FILED1 = ITAB1-FIELD1.

if sy-subrc = 0.

MOVE-CORRESPONDING TO ITAB2 to ITAB_FINAL.

endif,

READ TABLE ITAB3 WITH KEY FILED1 = ITAB1-FIELD1.

if sy-subrc = 0.

MOVE-CORRESPONDING TO ITAB2 to ITAB_FINAL.

endif,

append itab_final.

clear itab_final.

endloop

If useful reward,

Vasanth

Re: intersection from 3 tables

anversha_s — Tue, 14 Nov 2006 13:55:17 GMT

hi,

check this code.

data : begin of itab1 occurs 0. "itab with work area.
key_field1 like ztable1-key_field1,
field1 like ztable1-field1,
field2 like ztable1-field2,
endof itab1. 

data : begin of itab2 occurs 0. "itab with work area.
key_field2 like ztable2-key_field2,
field3 like ztable2-field3,
field4 like ztable2-field4,
endof itab2. 

data : begin of itab_final occurs 0.
key_field1 like ztable1-key_field1,
field1 like ztable1-field1,
field2 like ztable1-field2,
field3 like ztable2-field3,
field4 like ztable2-field4,
endof itab_final. 


put the date final(merged) internal table
*****************************************
1. loop at itab1.
read table itab2 with key keyfield2 = itab1-keyfield1.
if sy-surc = 0.
itab_final-key_field1 = itab1-keyfield1
itab_final-field1 = itab1-field1.
itab_final-field2 = itab1-keyfield2.
itab_final-field3 = itab2-field2.
itab_final-field4 = itab2-keyfield2.
append itab_final.
clear itab_final.
endif.
endloop.

Regards

Anver

if hlped pls mark points

Re: intersection from 3 tables

Former Member — Tue, 14 Nov 2006 13:56:07 GMT

Check this code you can put into the internal table

SELECT a_{equnr a}bis a_{ab a}devloc b_{zzmun c}matnr

FROM egerh AS a INNER JOIN

iflot AS b

ON a_{devloc EQ b}tplnr

INNER JOIN equi AS c

ON a_{equnr EQ c}equnr

INTO TABLE i_dpoint

FOR ALL ENTRIES IN i_bill_reg

WHERE a~equnr EQ i_bill_reg-equnr .

Re: intersection from 3 tables

Former Member — Tue, 14 Nov 2006 13:56:26 GMT

Hi..

You can try joining two of the tables and then use for all entries for third table.

or otherwise you can write two jon statements in single select statement.

e.g.

Select *

from (

INNER JOIN AFIH "afih: Maint order header

ON AFIH_{AUFNR = AUFK}AUFNR

INNER JOIN ILOA "iloa: PM Obj Loc & Acct Assgmt

ON ILOA_{ILOAN = AFIH}ILOAN

INNER JOIN AFVV "afvv: qty/dates in operation

ON AFVV_{AUFPL = AFKO}AUFPL

) where condition.

Re: intersection from 3 tables

Former Member — Tue, 14 Nov 2006 13:57:27 GMT

Code like this

<b>select p1_{field1 p2}field2 p3_{field3 from tab1 as p1 inner join tab2 as p2 on p1}field = p2_{field inner join tab3 as p3 on p3}field = p1~field into corresponding fields of table itab.</b>

Mark points if helpful.

Regs

Manas Ranjan Panda

Re: intersection from 3 tables

Former Member — Tue, 14 Nov 2006 14:01:59 GMT

hi,

declare all internal table what u required,

LOOP AT ITAB1.

MOVE-CORRESPONDING TO ITAB1 to ITAB_FINAL.

READ TABLE ITAB2 WITH KEY FILED1 = ITAB1-FIELD1.

if sy-subrc = 0.

MOVE-CORRESPONDING TO ITAB2 to ITAB_FINAL.

endif,

READ TABLE ITAB3 WITH KEY FILED1 = ITAB1-FIELD1.

if sy-subrc = 0.

MOVE-CORRESPONDING TO ITAB2 to ITAB_FINAL.

endif,

append itab_final.

clear itab_final.

endloop