topic Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Thu, 30 Nov 2006 00:50:45 GMT

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.

Re: Inner Join

gopi_narendra — Thu, 30 Nov 2006 00:55:33 GMT

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

Re: Inner Join

former_member758419 — Thu, 30 Nov 2006 04:18:49 GMT

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

Re: Inner Join

Former Member — Thu, 30 Nov 2006 04:55:38 GMT

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