inner join

[Former Member]

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.

[Former Member]

Yes use For all entries

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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.