topic Re: Join tables in Application Development and Automation Discussions

Join tables

Former Member — Mon, 21 Apr 2008 04:25:51 GMT

Hi All,

How to join tables without having common fields,I am facing this problem several times I don't know how to fetch the data from these tables.

Thanks&regds,

sree.

Re: Join tables

Former Member — Mon, 21 Apr 2008 04:32:26 GMT

Hi,

Why do you want to join tables if you dont have any condition specified. Select the entries separately and proceed with the query.

If you have such a query,post the requirement here.We could try and help your problem get solved.

Thanks,

Anon

Re: Join tables

Former Member — Mon, 21 Apr 2008 04:43:14 GMT

Hi,

Find the check table of the promary keys of the tables.

Try to find the common fields from one of the check tables of the primary keys.

Example,

If you want to join tables A and B.

Both tables don't contain common fields.

A has primary key fields X and Y.

go to check table of X or Y.

Let check table of X is C.

check any field in C which are exist in table B.

Join tables A and C.

Based on this pick the data from B.

Regards,

Re: Join tables

Former Member — Mon, 21 Apr 2008 04:49:54 GMT

Hi All,

Here is my query ,I am using ADDRNUMBER to join LFA1 and ADRC but LFA1 having the field ADRNR how to join these tables,I need to join LFM1,ADRC,ADR6.

REPORT ZMMTEST2.

tables:lfm1,lfa1,adrc,adr6.

data : itab1 type lfm1 occurs 0.

data : itab2 type lfa1 occurs 0.

data : itab3 type adrc occurs 0.

data : itab4 type adr6 occurs 0.

data : begin of Itab occurs 0,

lifnr like lfm1-lifnr,

ekorg like lfm1-ekorg,

ernam like lfm1-ernam,

ekgrp like lfm1-ekgrp,

lifnr like lfa1-lifnr,

adrnr like lfa1-adrnr,

addrnumber like adrc-addrnumber,

addrnumber like adr6-addrnumber,

smtp_addr like adr6-smtp_addr,

end of itab.

SELECT a_{lifnr a}ekorg a_{ernam a}ekgrp b_{lifnr b}adrnr c_{ADDRNUMBER d}ADDRNUMBER d~SMTP_ADDR

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( lfm1 AS a

INNER JOIN lfa1 AS b ON a_{lifnr = b}lifnr )

INNER JOIN lfm1 AS c ON b_{adrnr = c}ADDRNUMBER )

INNER JOIN adrc AS d ON c_{ADDRNUMBER = d}ADDRNUMBER ).

Thanks&regds,

Sree.