want to get an additional field in the output screen using inner join

[Former Member]

i am having a select query.

Select v_{vbeln v}spart vtext

into corresponding fields of table it_tspat

from VBAP as v INNER JOIN TSPAT as t

ON v_{spart = t}spart

for all entries in it_zp1012_so_app_h

where spras = 'EN'

and vbeln = it_zp1012_so_app_h-vbeln+0(10).

now i have to retrieve BZIRK from table VBKD in the same select query above

and want to display vbeln,spart,vtext,bzirk in the output

[Former Member]

hi santosh i sending query for inner join for three ale...u ll get all ur answers..

select b_{ean11 a}matnr c_{maktx a}menge a_{meins a}dmbtr into

corresponding fields of table itab_main1 from ( ( makt as c inner join

mseg as a on c_{matnr = a}matnr ) inner join mara as b on a~matnr =

b~matnr ) where mblnr = pa.

[Former Member]

Select v~vbeln v~spart a~bzirk
                    into corresponding fields of table i_vbkd
                    from VBAP as v INNER JOIN VBKD as a
                   ON v~vbeln = a~vbeln
                   AND v~posnr = a~posnr
                   for all entries in it_zp1012_so_app_h
                   where v~vbeln = it_zp1012_so_app_h-vbeln+0(10).

if sy-subrc = 0.
 select vtext from tspat
                  into i_tspat
                 for all entries in i_vbkd
                 where spart = i_vbkd-spart
                  AND SPAS = 'EN'.
ENDIF.

LOOP AT i_vbkd.
READ TABLE i_tspat WITH KEY spart = i_vbkd=spart.
 if sy-subrc = 0.
 i_vbkd-vtext = i_tspat-vtext.
endif.
CLEAR i_vbkd.
ENDLOOP.

Hope this will oslve ir problem.

Reward if this helsp.

[Former Member]

Hi,

Join VBKD also with VBAP:

Select v_{vbeln v}spart v_{text c}bzirk

into corresponding fields of table it_tspat

from ( VBAP as v INNER JOIN TSPAT as t

ON v_{spart = t}spart ) join VBKD as c

on v_{vbeln = c}vbeln

for all entries in it_zp1012_so_app_h

where spras = 'EN'

and vbeln = it_zp1012_so_app_h-vbeln+0(10).

Regards,

Anji