Select Query!!!

[Former Member]

Hi All,

Am using the following query to retrieve a record from a customized infotype table.

But the highlighted portion in the query is not allowed in the Select statement it seems.

Any suggestions, how can i retrieve the data based on the following conditions, and omitting all the records of subtypes starting with 'Z'????

Please help...!!!!

SELECT SINGLE zz_rc_no FROM pa9235 INTO gwa_9180_emp-zzrecall_id

WHERE begda <= gwa_claims-g_trg_start AND

endda >= gwa_claims-g_trg_end AND

<b>subty+0(1) <> 'Z' AND</b>

( zz_os = '01' OR zz_os = '43' OR zz_os = '53' ).

Thanks!!!

Regards,

Sundar.

[Former Member]

subty not like 'Z%' AND

regards

shiba dutta

[JozsefSzikszai]

hi Sundar,

you cannot do that, replace the bold line:

subty IN range

your range has to contain one line:

sign : E (stands for Exclude)

option : EQ

low : Z*

hope this helps

ec

[Former Member]

Thanks a lot!!! Indeed that was a stupid question

Thanks anywayss....