topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Mon, 05 Feb 2007 12:17:52 GMT

Dear experts

I am using the below query but i am getting the error

pls suggest any other way to satify all the conditions

SELECT likp_{vbeln lips}werks lips_{lfimg lips}matnr

INTO CORRESPONDING FIELDS OF TABLE i_c FROM likp

INNER JOIN lips ON likp_{vbeln = lips}vbeln

for all entries in i_rework

WHERE

werks = i_rework=werks

likp_{vbeln IN p_vbeln AND likp}lfart = 'LR'.

Thanks in advance

karthik

Re: select query

Former Member — Mon, 05 Feb 2007 12:19:13 GMT

hi,

change the bolded one:

SELECT likp_{vbeln lips}werks lips_{lfimg lips}matnr

INTO CORRESPONDING FIELDS OF TABLE i_c FROM likp

INNER JOIN lips ON likp_{vbeln = lips}vbeln

for all entries in i_rework

WHERE

werks = i_rework<b>-</b>werks

likp_{vbeln IN p_vbeln AND likp}lfart = 'LR'.

regards,

madhu

Re: select query

Former Member — Mon, 05 Feb 2007 12:20:07 GMT

Hi,

Take a look :

SELECT likp~vbeln
 lips~werks
 lips~lfimg
 lips~matnr
INTO CORRESPONDING FIELDS OF TABLE i_c
FROM likp INNER JOIN lips
 ON likp~vbeln = lips~vbeln
for all entries in i_rework
WHERE 
werks = i_rework-werks
AND likp~vbeln IN p_vbeln
AND likp~lfart = 'LR'.

Erwan

Re: select query

Former Member — Mon, 05 Feb 2007 12:20:28 GMT

Change this line:

werks = i_rework=werks

werks = i_rework-werks

Regards,

Ravi

Re: select query

Former Member — Mon, 05 Feb 2007 12:25:14 GMT

Hi erwan

if i use your query i am getting the error "The column name has two meanings"

regards

karthik

Re: select query

Former Member — Mon, 05 Feb 2007 12:27:01 GMT

hi karthik

have u changed the ON condition. '=' has to be replaced with '-'.

regards,

madhu

Re: select query

Former Member — Mon, 05 Feb 2007 12:28:38 GMT

Hi Karthik,

Use this code:

SELECT likp_{vbeln lips}werks lips_{lfimg lips}matnr

INTO CORRESPONDING FIELDS OF TABLE i_c FROM likp

INNER JOIN lips ON likp_{vbeln = lips}vbeln

for all entries in i_rework

WHERE

<b>likp~werks = i_rework-werks</b>

likp_{vbeln IN p_vbeln AND likp}lfart = 'LR'.

REgards,

Ravi

Re: select query

Former Member — Mon, 05 Feb 2007 13:00:31 GMT

good

your select statement is wrong

SELECT likp_{vbeln lips}werks lips_{lfimg lips}matnr

INTO CORRESPONDING FIELDS OF TABLE i_c FROM likp

INNER JOIN lips ON likp_{vbeln = lips}vbeln

for all entries in i_rework

WHERE

werks = i_rework=werks

likp_{vbeln IN p_vbeln AND likp}lfart = 'LR'.

Use like this.

Since these 2 tables a re logically joined by the airln field, it is advisable to use the inner join.

Select a_{airln a}lnnam b_{fligh b}cntry into table int_airdet

From zairln as a inner join zflight as b on a_{airln = b}airln.

thanks

mrutyun^