Code for select

[Former Member]

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?

[Former Member]

Select lfa1_{regio lfa1}ekorg

wyt3~adrnr

FROM ( lfa1

INNER JOIN wyt3

ON wyt3_{lifnr = lfa1}LIFN2 )

INTO TABLE itab

WHERE .....

Regards,

John.

[Former Member]

Hi,

Use Innerjoin or Forallentry joining statement.

Regards,

Bhaskar

[Former Member]

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

[ferry_lianto]

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

[Former Member]

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 ?

[ferry_lianto]

Hi,

What is the field from ADRC?

Regards,

Ferry Lianto

[Former Member]

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

[ferry_lianto]

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