ignorning includes which starts with %

[Former Member]

Hi All,

I am fetching Program name, and Include from the Table D010INC. but in the resulted output

there are some includes that are begining with the symbol %. I don't want to display them in the final

output.

my select query is as follws.

SELECT master include FROM d010inc INTO TABLE itab_d010inc

WHERE master IN s_mast AND

include IN s_incl and

master NOT LIKE '%___________________' and

include NOT LIKE '%___________________' and

include NOT LIKE '<%>'.

how do add not like % condition in the where clause ?

Thanks in advance'

Kr

[Former Member]

Hi,

select all the entries from the table and delete the entries from the table which are not required.

Eg: DELETE itab where field CS '%'.

Hope it helps...

Regards,

Pavan

[Former Member]

Hi Vishnu,

Thanks for quick replay. Your solution also works fine, but i want to include that condition in the where clause (like other conditions). is it possible to do it ?

[Former Member]

Hi,

CS cannot be used in where clause.

Regards,

Pavan

[Former Member]

Hi KR,

SELECT master include FROM d010inc INTO TABLE itab_d010inc

WHERE master IN s_mast .

loop at itab_d010inc.

if itab_d010inc-master(1) = '%'.

delete itab_d010inc.

endif.

endloop.

[Former Member]

Did you try with offset ? Take the first Character and compare whether it is '%' .

[sujeet2918]

Hi KR,

Please write the code as i hve given below :

SELECT master include FROM d010inc INTO TABLE itab_d010inc

WHERE master IN s_mast .

IF itab_d010inc[] IS NOT INITIAL.

DELETE itab_d010inc where master CS '%'

OR INCLUDE CS '%'.

ENDIF.

Hope It will solve your problem..

if not then get back to me..there are so many way..you can delete.

Thanks,

Sujeet