Skip to Content
0
Former Member
Jul 16, 2008 at 05:31 PM

Error in Select Statement

24 Views

Hi,

I am getting error for this select statement

SELECT eine~evers INTO wa_eine-evers

FROM eina

JOIN eine ON einainfnr = eineinfnr

WHERE eina~matnr = wa_idata-matnr

AND eina~lifnr = wa_idata-lifnr

AND eine~esokz = wa_idata-esokz

AND eine~werks = wa_idata-werks

AND eine~evers = wa_idata-ship_inst.

Here the SY-SUBRC = 4.

But not for this select statement

SELECT eine~evers INTO eine-evers

FROM eina

JOIN eine ON einainfnr = eineinfnr

WHERE eina~matnr = wa_idata-matnr

AND eina~lifnr = wa_idata-lifnr

AND eine~esokz = wa_idata-esokz

AND eine~werks = wa_idata-werks

AND eine~evers = wa_idata-ship_inst.

Here SY-SUBRC = 0.

Can anyone tell the difference between these two select statement.and the cause for the error.

Thanks

Kumar