topic Re: Like operation in loop in Application Development and Automation Discussions

Like operation in loop

Former Member — Fri, 23 Jan 2015 08:05:32 GMT

Hi All

I am passing to date and from date as input and fetching records from ekko into lt_ekko.

Now ,i had field 'customername' in output screen(importing parameter of a function module).

LT_ekko has field verkf (customername) values as SDN SAP - 10 records.and SAP - 10 records and SDN - 10 records

My query is if the user gives input as SAP.i need to display SDN SAP records(along with SAP records) and delete SDN records from lt_ekko as it is my final table.

I am giving ranges

IF iv_customername IS NOT INITIAL.

ls_r_custname-sign = 'I'.

ls_r_custname-option = 'NP'.

ls_r_custname-low = iv_customername.

APPEND ls_r_custname TO lt_r_custname.

ENDIF.

DELETE lt_ekko WHERE verkf IN lt_r_custname.

this delete statement is not working ,not deleting entries of SDN records.

Thanks

Vamsi

Re: Like operation in loop

Former Member — Fri, 23 Jan 2015 08:16:00 GMT

hi mohan

with CP or NP there must be atleast one masking character.

can you insert this before above code and try.

concatenate iv_customername '*' into iv_customername.

Re: Like operation in loop

vinodkumar_thangavel — Fri, 23 Jan 2015 08:21:00 GMT

Hi,

Instead u can try using DELETE lt_ekko WHERE verkf NE iv_customername.

Regards,

Vinodkumar.

Re: Like operation in loop

Former Member — Fri, 23 Jan 2015 08:36:59 GMT

Vinodh

if i do verkf NE iv_customername, SDN SAP records also gets deleted.i need SAP & SDN SAP records

Re: Like operation in loop

Former Member — Fri, 23 Jan 2015 08:40:18 GMT

Hi Adbul

Tried ,but not worked,sy-subrc = 4

Re: Like operation in loop

Former Member — Fri, 23 Jan 2015 08:51:13 GMT

Hi Mohan,

Make following changes to your code snippet -

IF iv_customername IS NOT INITIAL.

ls_r_custname-sign = 'I'.

ls_r_custname-option = 'EQ'.

ls_r_custname-low = iv_customername.

APPEND ls_r_custname TO lt_r_custname.

ENDIF.

DELETE lt_ekko WHERE verkf IN lt_r_custname.

Let me know incase of any help.

Thanks & Regards

Richa

Re: Like operation in loop

RaymondGiuseppi — Fri, 23 Jan 2015 09:01:11 GMT

If you use a range (IN, select-option) you could concatenate "*" at start and end of string, if you are using LIKE statement, use "%".

But for internal table criteria you could also use operator NS Contains No String, DELETE lt_ekko WHERE verkf NS string. (log_exp - Comparison Operators for Character-Like Data Types)

Regards,

Raymond