please chk the code

[Former Member]

hi

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...

[Former Member]

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><b>u NEED TO GIVE IN CAPITALS.</b></u>

AND parvw EQ 'LS'.

IF sy-subrc EQ 0.

endif.

reward if it helps u...

sai ramesh

[Former Member]

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

[Former Member]

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'

<b>AND parnr IN ('S7DCLNT200', 'S7QCLNT450', 'S7PCLNT450')</b>

AND parvw EQ 'LS'.

IF sy-subrc EQ 0.

endif.

Thanks,

Vinay

[Former Member]

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.