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'????
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' ).