topic Re: please chk the code in Application Development and Automation Discussions

please chk the code

Former Member — Thu, 15 Mar 2007 14:02:58 GMT

SELECT SINGLE objky

FROM nast

INTO lv_objky

WHERE kappl EQ 'EF'

AND objky EQ lv_var

AND spras EQ 'EN'

AND parnr IN ('s7dclnt200', 's7qclnt450', 's7pclnt450')

AND parvw EQ 'LS'.

IF sy-subrc EQ 0.

endif.

this is my select query ..

in database i have the entry but i m getting sy-subrc not equal to 0. please let me know...

Re: please chk the code

Former Member — Thu, 15 Mar 2007 14:05:54 GMT

SELECT SINGLE objky

FROM nast

INTO lv_objky

WHERE kappl EQ 'EF'

AND objky EQ lv_var

AND spras EQ 'EN'

AND parnr IN ('S7DCLNT200', 'S7QCLNT450', 'S7PCLNT450')---> u NEED TO GIVE IN CAPITALS.

AND parvw EQ 'LS'.

IF sy-subrc EQ 0.

endif.

reward if it helps u...

sai ramesh

Re: please chk the code

Former Member — Thu, 15 Mar 2007 14:06:07 GMT

Hello Neha,



Here the Variable lv_var  should be similar to the value in that table.
Check this
SELECT SINGLE objky
FROM nast
INTO lv_objky
WHERE kappl EQ 'EF'
AND objky EQ lv_var             " Chekc here
AND spras EQ 'EN'
AND parnr IN ('s7dclnt200', 's7qclnt450', 's7pclnt450')
AND parvw EQ 'LS'.
IF sy-subrc EQ 0.
endif.

REgards,

Vasanth

Re: please chk the code

Former Member — Thu, 15 Mar 2007 14:07:10 GMT

Hi Neha,

I have a doubt that PARNR values are stored in Capital letters,so try as follows.

SELECT SINGLE objky

FROM nast

INTO lv_objky

WHERE kappl EQ 'EF'

AND objky EQ lv_var

AND spras EQ 'EN'

AND parnr IN ('S7DCLNT200', 'S7QCLNT450', 'S7PCLNT450')

AND parvw EQ 'LS'.

IF sy-subrc EQ 0.

endif.

Thanks,

Vinay

Re: please chk the code

Former Member — Thu, 15 Mar 2007 14:07:39 GMT

build a range table for parnr

ranges : s_parnr for objky-parnr.

s_parnr-sign = 'I'.
s_parnr-option = 'BT'.
s_parnr-low = 's7dclnt200'.
append s_parnr.
clear s_parnr.

s_parnr-sign = 'I'.
s_parnr-option = 'BT'.
s_parnr-low = 's7qclnt450'.
append s_parnr.
clear s_parnr.

s_parnr-sign = 'I'.
s_parnr-option = 'BT'.
s_parnr-low = 's7pclnt450'.
append s_parnr.
clear s_parnr.


SELECT SINGLE objky
FROM nast
INTO lv_objky
WHERE kappl EQ 'EF'
AND objky EQ lv_var     "<-------also check if leading zeroes are coming here if any
AND spras EQ 'EN'
AND parnr IN s_parnr
AND parvw EQ 'LS'.
IF sy-subrc EQ 0.
endif.