topic Selection Criteria in Application Development and Automation Discussions

Selection Criteria

Former Member — Fri, 21 Jul 2006 03:35:36 GMT

Hi All,

I have to select the records from table ADRC into my internal table where one of the fields - Search Term 2 should have only first 2 characters as 'SP'. How do i do it. Kindly help me.

Regards,

T. Karthikeyan

Re: Selection Criteria

Former Member — Fri, 21 Jul 2006 03:40:01 GMT

Hi Karthik,

Please use select with wildcard search.

Check this sample codes.

select cretime 
into table i_table
from apqi
for all entries in i_tab
where groupid like 'VP*'.

ranges r_id for apqi-groupid.
r_id-low = 'VP*'.
r_id-sign = 'I'.
r_id-option = 'CP'.
append r_id.

select cretime 
into table i_table
from apqi
for all entries in i_tab
where groupid in r_id.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Re: Selection Criteria

naimesh_patel — Fri, 21 Jul 2006 03:44:07 GMT

Hello,

Use like <b>Field like 'SP%'</b> in your where condition of the select query.

Regards,

Naimesh

Re: Selection Criteria

Former Member — Fri, 21 Jul 2006 03:50:34 GMT

Hi,

Please try this:

DATA : IT_ADRC TYPE ADRC.

SELECT FIELD1

FIELD2

FROM ADRC

INTO TABLE IT_ADRC

WHERE SEARCH FIELD LIKE 'SP%'.

Regards,

Sujana