select query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi erwan

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

regards

karthik

[Former Member]

hi karthik

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

regards,

madhu

[Former Member]

Change this line:

werks = i_rework=werks

to

werks = i_rework-werks

Regards,

Ravi

[Former Member]

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

[Former Member]

hi

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^