topic Re: select single and join in Application Development and Automation Discussions

select single and join

Former Member — Fri, 13 Jul 2007 12:34:51 GMT

some problem at INTO. 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

Raj.

Re: select single and join

Former Member — Fri, 13 Jul 2007 12:43:36 GMT

Hi,

Use Join statement as follows:

SELECT A_{EQUNR B}DATAB B_{ILOAN C}SWERK

INTO TABLE ITEQ

FROM ( EQUI AS A INNER JOIN EQUZ AS B

ON A_{EQUNR = B}EQUNR ) INNER JOIN ILOA AS C

ON B_{ILOAN = C}ILOAN

WHERE A~EQART = 'ESTPL'

AND B~IWERK = 'M011'

AND B~INGRP = 'SLM'

AND B_{DATAB GE SDATE-LOW AND B}DATAB LE SDATE-HIGH

AND C~SWERK IN S_WERK.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: select single and join

Former Member — Fri, 13 Jul 2007 12:43:37 GMT

Hi Raj,

You are trying to use the character '~' which should be used only if you are using alias name for the table. Otherwise you should be using '-' between the table names and the field names.

Try the below code in your case and it shall work,

select single a_{vbeln b}kunnr

into (lips-vbeln, vbak-kunnr)

from lips as a

inner join vbak as b

on ( b_{vbeln eq a}vgbel )

where a_{vbeln eq b}vbeln.

Please do not forget to reward points if this helps,

Kiran

Re: select single and join

Former Member — Fri, 13 Jul 2007 12:46:07 GMT

Hello,

Check this :-

TABLES: lips,vbak.

DATA: p_vbeln TYPE vbeln.
DATA: wa_vbeln TYPE vbeln,
      wa_kunnr TYPE kunnr.

SELECT SINGLE a~vbeln
              b~kunnr
       INTO (wa_vbeln,wa_kunnr)
       FROM lips AS a INNER JOIN vbak AS b
       ON a~vbeln = b~vbeln
       WHERE a~vbeln = p_vbeln.

Regards,

Deepu.K

Re: select single and join

Former Member — Fri, 13 Jul 2007 13:47:28 GMT

select single lips~vbeln

from lips

inner join vbak

on ( vbak_{vbeln eq lips}vgbel )

into likp-vbeln

where lips~vbeln eq likp-vbeln

The above seletct statement already exist, i dont want to create work area for VBAK-VBELN as it is used many areas in the program. i just wanted to get KUNNR from VBAK for that i am coding

select single lips~vbeln VBAK ~VBELN

from lips

inner join vbak

on ( vbak_{vbeln eq lips}vgbel )

into (likp-vbeln,VBAK-KUNNR)

where lips~vbeln eq likp-vbeln .

But is throwing erro.

Thanks.

Raj