topic S_Tcode Should not be * in Application Development and Automation Discussions

S_Tcode Should not be *

Former Member — Thu, 09 Apr 2009 02:35:45 GMT

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

Re: S_Tcode Should not be *

Former Member — Thu, 09 Apr 2009 03:02:47 GMT

Dear Karthika,

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

Regards,

Re: S_Tcode Should not be *

Former Member — Thu, 09 Apr 2009 03:07:46 GMT

Thanks a Lot!

Re: S_Tcode Should not be *

Former Member — Mon, 13 Apr 2009 09:18:39 GMT

Hi Lakshmi ,

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

Regards

Kanti

Re: S_Tcode Should not be *

jurjen_heeck — Mon, 13 Apr 2009 09:33:01 GMT

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:

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.

Re: S_Tcode Should not be *

Former Member — Mon, 13 Apr 2009 09:37:13 GMT

Thank you