Inner Join

[Former Member]

HI Group,

I need to Pick up field VSTELl and HAUS from table EVBS.

For each HAUS I need to pick up PLTXT from IFLOTX table

Can any body suggest me how to do this using Inner Join.

[gopi_narendra]

select VSTELI HAUS from EVBS

into table IT_EVBS

where <COND>.

if sy-subrc = 0.

select PLTXT from IFLOTX

into IT_IFLOTX

for all entries in IT_EVBS

where HAUS = IT_EVBS-HAUS.

endif.

I do not have SAP now, so havent gone thru the tables, plz check the tables and follow the key validations also.

Regards

- Gopi

[former_member758419]

Hi,

Try this code,

DATA: BEGIN OF wa,

HAUS TYPE EVBS-HAUS,

STELl TYPE EVBS-VSTELl,

PLTXT TYPE IFLOTX-PLTXT,

END OF wa.

DATA: itab LIKE SORTED TABLE OF wa WITH UNIQUE KEY HAUS.

SELECT a_{HAUS a}VSTELI b~PLTXT

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( EVBS AS a INNER JOIN IFLOTX AS b ON a_{HAUS = b}HAUS ).

Hope this helps,

Regards,

Sachidanand.B

Pls award points for helpful answers

Message was edited by:

Sachidanand B

[Former Member]

Hi,

Use the following code,

DATA: BEGIN OF str,

HAUS TYPE EVBS-HAUS,

VSTELl TYPE EVBS-VSTELl,

PLTXT TYPE IFLOTX-PLTXT,

END OF str.

DATA : itab LIKE TABLE OF str with header line.

SELECT a_{HAUS a}VSTELI b~PLTXT

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( EVBS AS a

INNER JOIN IFLOTX AS b ON a_{HAUS = b}HAUS ).

Reward Points if it works.

Regards,

Rajesh Kumar