topic Re: Table Join in Application Development and Automation Discussions

Table Join

Former Member — Tue, 25 Mar 2008 11:21:31 GMT

Hi,

I have to join 4 ztables . The joining is based on one common key.How can I do it?

regards..

Re: Table Join

Former Member — Tue, 25 Mar 2008 11:24:38 GMT

Hi ,

Check ths example qurey...

SELECT COUNT( * ) AS dcases

a_{trntyp a}exdat

SUM( b~exbas ) AS exbas

SUM( b~exbed ) AS exbed

SUM( b~exaddtax1 ) AS exaddtax1

SUM( b~menge ) AS menge

SUM( b~ecs ) AS ecs

INTO CORRESPONDING FIELDS OF TABLE it_stock

FROM ( ( j_1iexchdr AS a

INNER JOIN j_1iexcdtl AS b

ON a_{exnum EQ b}exnum

AND a_{exdat EQ b}exdat

AND a_{docno EQ b}docno

AND a_{docyr EQ b}docyr )

INNER JOIN mara AS c

ON b_{matnr EQ c}matnr )

WHERE a~exgrp EQ '11'

AND a~trntyp IN ('DLFC','CEIV','OTHR')

AND a~srgrp IN ('01','08')

AND a~expind NE 'D'

AND a~exdat IN s_budat

AND b_{matnr EQ c}matnr

AND c~spart IN ('11','12')

GROUP BY a_{trntyp a}exdat.

you can write your qurey similar to this...

<b>reward if useful</b>

Regards,

sunil kairam.

Re: Table Join

Former Member — Tue, 25 Mar 2008 11:25:16 GMT

look this example

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.

Regards

Aditya

Re: Table Join

dhruv_shah3 — Tue, 25 Mar 2008 11:25:49 GMT

HI,

use for all entries statement and every time compare that key with the internal table key field.

Eg.

select * from <tablename>

for all entries in <internal table>

where table field = internal table field.

HTH

Regards,

Dhruv Shah

Re: Table Join

Former Member — Tue, 25 Mar 2008 11:27:45 GMT

HI,

SELECT a~ebeln

*c~lifnr

a~bukrs
*c~name1
a~lifnr
*c~sortl
b~ebelp
*c~land1
b~matnr
b~werks
b~netpr
b~menge
INTO CORRESPONDING FIELDS OF TABLE t_data
FROM ekko as a
inner join ekpo as b on a~ebeln = b~ebeln
*inner join lfa1 as c on a~lifnr = c~lifnr
WHERE a~ebeln in s_ebeln
 AND a~lifnr in s_lifnr

Regards,

S.Nehru