topic Re: Select Query!!! in Application Development and Automation Discussions

Select Query!!!

Former Member — Mon, 12 Nov 2007 07:48:18 GMT

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 — Mon, 12 Nov 2007 07:50:08 GMT

subty not like 'Z%' AND

regards

shiba dutta

JozsefSzikszai — Mon, 12 Nov 2007 07:51:51 GMT

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

Former Member — Mon, 12 Nov 2007 07:52:19 GMT

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

Thanks anywayss....