topic Re: Code for select in Application Development and Automation Discussions

Code for select

Former Member — Wed, 11 Apr 2007 15:21:20 GMT

Hi ,

I need to bring fields from 2 different tables into a single itab.

Data : begin of itab occurs 0,

F1 type lfa1-regio,

F2 type ekorg,

F3 type wyt3-adrnr,

End of itab.

First I need to check in for the field of LFA1 and fill the itab and then I must check the LIFN2 of LFA1 with WYT3-LIFNR and fill the F3.

How do I write the select statements?

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:25:01 GMT

Select lfa1_{regio lfa1}ekorg

wyt3~adrnr

FROM ( lfa1

INNER JOIN wyt3

ON wyt3_{lifnr = lfa1}LIFN2 )

INTO TABLE itab

WHERE .....

Regards,

John.

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:25:43 GMT

Hi,

Use Innerjoin or Forallentry joining statement.

Regards,

Bhaskar

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:26:30 GMT

HI ramana,

use inner join ........

SELECT LFA1_{REGIO LFA1}EKORG WYT3_{ADRNR INTO CORRESPONDING FIELDS OF TABLE ITAB FROM LFA1 INNER JOIN WYT3 ON LFA1}LIFN2 = WYT3~LIFNR WHERE ( UR CONDITION IF EXISTS ).

Regards

SAB

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:29:41 GMT

Hi,

Please try this.


SELECT A~REGIO B~EKORG A~ADRNR
INTO TABLE ITAB
FROM LFA1 AS A INNER JOIN WYT3 AS B
ON A~LIFNR = B~LIFN2
WHERE A~LIFNR IN S_LIFNR.

Regards,

Ferry Lianto

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:34:14 GMT

But Ferry ,

I need to pick somemore fields from ADRC table into field F4.What If I need to write another select stmt for the same ITAB ?

Re: Code for select

Former Member — Wed, 11 Apr 2007 15:48:13 GMT

Hi,

What is the field from ADRC?

Regards,

Ferry Lianto

Re: Code for select

Former Member — Wed, 11 Apr 2007 16:53:46 GMT

The logic is that I need to check LIFN2 with the LIFNR of LFA1 again and get NAME1 & ADRNR from LFA1 and then check it with the ADRNR of ADR6

Re: Code for select

Former Member — Wed, 11 Apr 2007 17:05:52 GMT

Hi,

Please try this.


SELECT A~REGIO B~EKORG A~ADRNR
INTO TABLE ITAB
FROM LFA1 AS A INNER JOIN WYT3 AS B
ON A~LIFNR = B~LIFN2
INNER JOIN ADRC AS C
ON A~ADRNR = C~ADDRNUMBER
WHERE A~LIFNR IN S_LIFNR.

Regards,

Ferry Lianto