topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Fri, 27 Feb 2009 09:41:06 GMT

Is it possible to get output without using inner join?

select a_{bukrs b}netwr b_{mwsbk b}vbeln b~kunrg

c_{kunnr c}lifnr

a_{lifnr a}xblnr

into corresponding fields of table itab1

from vbrk as b

inner join bsik as a on b_{vbeln = a}xblnr

inner join kna1 as c on b_{kunrg = c}kunnr

where a~bukrs IN s_bukrs.

Re: inner join

Former Member — Fri, 27 Feb 2009 09:42:10 GMT

Yes use For all entries

Re: inner join

Former Member — Fri, 27 Feb 2009 09:46:37 GMT

Hi,

Split the Select and use the For All Entries.

select bukrs lifnr xblnr
into corresponding fields of table itab1
from bsik 
where a~bukrs IN s_bukrs.

select netwr mwsbk vbeln kunrg
into corresponding fields of table itab2
from vbrk 
for all entries in itab1
where vbeln =  itab1-xblnr

select kunnr lifnr
into corresponding fields of table itab3
from kna1 wherekunnr = itab3-kunrg

Re: inner join

Former Member — Fri, 27 Feb 2009 09:51:53 GMT

hi,

Dont use inner join for three table unless all the joining keys are not primary key.

use for all entries.

Check the syntes from f1 help or abapdocu.

Cheers,

Rudhir

Re: inner join

Former Member — Fri, 27 Feb 2009 10:45:06 GMT

Try This

SELECT BUKRS

LIFNR

XBLNR

FROM BSIK

INTO CORRESPONDING FIELDS OF TABLE ITAB1

WHERE BUKRS IN S_BUKRS.

IF ITAB1[] IS NOT INITIAL.

SELECT VBELN

KUNRG

NETWR

MWSBK

FROM VBRK

INTO TABLE ITAB2

WHERE VBELN = ITAB1-XBLNR.

ENDIF.

IF ITAB2[] IS NOT INITIAL.

SELECT KUNNR

LIFNR

FROM KNA1

INTO TABLE ITAB3

FOR ALL ENTRIES IN ITAB1

WHERE KUNNR = ITAB1-KUNRG.

ENDIF.