topic Re: Using search option for case sensitive fields in Application Development and Automation Discussions

Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 16:42:53 GMT

Hi Guys,

I am having one situation where i have to pick all the line items which are containing "Equity" text. And I am giving this "Equity" text in one of the selection-screen of Bseg-sgtxt field. I am including this text filed as Equity in that selection-screen filed. So it has to pick all the line items from Bseg table which contains this "Equity" text.

Bseg is a cluster table , so i am not using this selecion in where condition of that select query except key fields.

After select query on Bseg, i am looping that Bseg internal table and reading selection table of s_sgtxt and using SEARCH option of that "Equity" text , if entered text in selection field contains Equity then it comes out of the loop otherwise if entered text is not contains Equity text then it will delete that row from Bseg internal table. So at last we are getting only those data which contains "Equity" text.

But whats the problem am gettig is its picking all the line items which are containing this Equity text irrespective of caps or small letters, its pulling equity, EQUITY etc...text line items. I want only those Line items which is exactly having "Equity" text. So how can I use this one in SEARCH option or any bosy plz help me in this.

Will get reward points for gud answer....:)

BALU.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 16:53:22 GMT

try to use FIND with addition "IGNORING CASE" to find every match "RESPECTING CASE" addition to find match with case sensitive.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 16:55:13 GMT

U can see my code also....

select bukrs

belnr

gjahr

shkzg

sgtxt

vbund

kostl

hkont

dmbtr

menge

abper into table g_t_bseg

from bseg

for all entries in g_t_bkpf

where belnr = g_t_bkpf-belnr

and bukrs = g_t_bkpf-bukrs

and gjahr = g_t_bkpf-gjahr.

here l_v2 is having "Equity" Text and s_text is selection-screen field for Bseg-sgtxt Text.

loop at g_t_bseg.

if not s_text is initial.

search g_t_bseg-sgtxt for l_v2.

if sy-subrc ne 0.

delete g_t_bseg.

continue.

endif.

So plz how can I write the code to select only line items which contains exactly "Equity" text.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 16:57:39 GMT

select bukrs

belnr

gjahr

shkzg

sgtxt

vbund

kostl

hkont

dmbtr

menge

abper into table g_t_bseg

from bseg

for all entries in g_t_bkpf

where belnr = g_t_bkpf-belnr

and bukrs = g_t_bkpf-bukrs

and gjahr = g_t_bkpf-gjahr.

here l_v2 is having "Equity" Text and s_text is selection-screen field for Bseg-sgtxt Text.

loop at g_t_bseg.

if not s_text is initial.

*search g_t_bseg-sgtxt for l_v2.

find g_t_bseg-sgtxt for lv_v2 respecting case. " new statement instead of search

if sy-subrc ne 0.

delete g_t_bseg.

continue.

endif.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:04:06 GMT

Hi 1st of all thnx for ur reply.

I tried ur code also, but its giving error as statement "FIND" is not defined,please check ur spelling.

So shalli have 2 define it or plz give me any suggestion.

Balu.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:05:52 GMT

hope this will work.................

loop at g_t_bseg.

if not s_text is initial.

*search g_t_bseg-sgtxt for l_v2.

find lv_v2 in g_t_bseg-sgtxt respecting case. " new statement instead of search

if sy-subrc ne 0.

delete g_t_bseg.

continue.

endif.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:07:27 GMT

No its still giving same error.... Plz help me

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:13:12 GMT

Plz Help

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:13:33 GMT

select bukrs

belnr

gjahr

shkzg

sgtxt

vbund

kostl

hkont

dmbtr

menge

abper into table g_t_bseg

from bseg

for all entries in g_t_bkpf

where belnr = g_t_bkpf-belnr

and bukrs = g_t_bkpf-bukrs

and gjahr = g_t_bkpf-gjahr.

data : lv_v2(6) type c value 'Equity'.

loop at g_t_bseg .

if not s_text is initial.

*search g_t_bseg-sgtxt for l_v2.

find lv_v2 in g_t_bseg-sgtxt respecting case. " new statement instead of search

if sy-subrc ne 0.

delete g_t_bseg.

continue.

endif.

endloop.

for me the program is syntactically correct.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:19:16 GMT

Its giving same error, i m using 4.6 version , is thr any version problem. and also is thr any other way 2 write the code.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:22:02 GMT

wht is the error u are exactly facing?

let me know.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:24:21 GMT

Its giving error as "statement "FIND" is not defined,please check ur spelling".

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:28:19 GMT

Hi,

in your loop use IF-statement with 'CP' option. to compare case sensitive you've had to add "#" in front of every character of the sequence to compare.

e.g.

lv_one = 'Hello, World'
lv_two = '#H#e#l#l#o'.

if lv_one cp lv_two.
"do whatevet you like
endif.

Should work with all releases.

Regards,

Daniel

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:28:33 GMT

did you do f1 on FIND and check what exactly its showing?

find should be there in 4.6 as well.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:31:05 GMT

No documentation is avaliable in 4.6 version, I checked with f1 option also.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 17:31:17 GMT

Hi,

As addition, the 'FIND' statement was introduced in release 6.10!

Regards,

Daniel

Re: Using search option for case sensitive fields

former_member1007904 — Mon, 07 Jul 2008 18:31:05 GMT

after the select from BSEG juss say

delete tb_bseg where sgxtxt ne 'Equity'.

all the records which dont match the exact string 'Equity' will be deleted.

Re: Using search option for case sensitive fields

Former Member — Mon, 07 Jul 2008 19:16:09 GMT

Simply do it all at once:

SELECT bukrs
belnr
gjahr
shkzg
sgtxt
vbund
kostl
hkont
dmbtr
menge
abper INTO TABLE g_t_bseg
FROM bseg
FOR ALL ENTRIES IN g_t_bkpf
WHERE belnr = g_t_bkpf-belnr
AND bukrs = g_t_bkpf-bukrs
AND gjahr = g_t_bkpf-gjahr
AND ( sgtxt LIKE '%Equity%'
 OR   sgtxt LIKE '%equity%'
 OR   sgtxt LIKE '%EQUITY%' ).

I have made it not case sensitive, but you can leave it the way it was.

Rob