S_Tcode Should not be *

[Former Member]

Hi,

I need to find the Roles which contains S_TCODE value as *.When I tried on SUIM & SE16(AGR_1251).It takes * as Wild Card Value and It displaying all the Roles.

Even I tried '' and "" also.But I didnt get the correct value.

Kindly help in sorting out this problem.

Regards

Karthika

[Former Member]

Dear Karthika,

Try giving #* or #** for the values of S_TCODE and run it.

Regards,

[Former Member]

Thanks a Lot!

[Former Member]

Hi Lakshmi ,

Could you please tell me what is the difference in giving * alone and or giving # or #* in place of *

Regards

Kanti

[jurjen_heeck]

In report selections * will look for any value, #* 'escapes' the star and will look for the value , #* 'escapes' the first star and will look for any value starting with a *.

This escaping is found in almost every system/programming language to be able to work with characters that have special meaning to the system.

In Excel it's the ~ (tilde) symbol. You can try this to see the difference:

Fill an empty sheet from cell A1 thru A5 with:

a

b

c

d

*

Now look at the different outcome if you type these formulas in another cell:

=COUNTIF(A1:A5;"*") to look for anything

=COUNTIF(A1:A5;"~*") with the star escaped.

[Former Member]

Thank you