select single with join

[Former Member]

Hi

some problem at <b>INTO</b>. Pls can any one suggest something.

the format of ( vbak_{vbeln eq lips}vgbel ) is not correct. It is problem with ( ) and space.

select single lips_{vbeln vbak}kunnr

from lips

inner join vbak

on ( vbak_{vbeln eq lips}vgbel )

into (lips-vbeln,vbak-kunnr)

where lips~vbeln eq likp-vbeln.

Regards

Thiru.

[Former Member]

See the example code :

report zxyz.

data : begin of wa_makt,

matnr like mara-matnr,

maktx like makt-maktx,

end of wa_makt.

parameters p_matnr like mara-matnr.

start-of-selection.

select single a_{matnr b}maktx into wa_makt

from mara as a inner join makt as b on b_{matnr = a}matnr

where a~matnr = p_matnr.

write:/ wa_makt.

Thanks

Seshu

[Former Member]

HI

IF YOU DON'T MIND CAN YOU TEL ME WHAT YOUR TRYING TO DO THERE

[alejandro_bindi]

Use the TABLES adition as in this code:

TABLES: likp,
        lips,
        vbak.

SELECT SINGLE lips~vbeln vbak~kunnr
FROM lips
INNER JOIN vbak
ON ( vbak~vbeln EQ lips~vgbel )
INTO (lips-vbeln,vbak-kunnr)
WHERE lips~vbeln EQ likp-vbeln.

Please reward points if this solves your problem.