cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Pattern [*] Operator in Select Option

Former Member
0 Likes
3,657

Hi All,

In any standard search help criteria or our own developed select options, when we enter some character in the name field, it automatically takes = (Single Value) operator. Which is ok.

Now when we put * (Star) before the characters, it Does not change to [*] operator. While in R3 Screen it does. It is very difficult for the end users to select the operator from the list, and each time, it is very common to search by name, then if forgot to put * before or in the end, then put the star, change the operator manually and then proceed.

Is there any way to automatically change it, the moment we put *. (Same like SAP R3 Screen does).

Please help. Its urgent.

Thanks & Regards,

Arvind

View Entire Topic
Shivesh
Product and Topic Expert
Product and Topic Expert
0 Likes

HI Arvind,

REPLACE ALL OCCURRENCES OF '*' IN lv_pernr WITH '%' .
       REPLACE ALL OCCURRENCES OF '*' IN lv_name WITH '%' .


SELECT pernr ename  FROM pa0001 INTO TABLE lt_select_list
         WHERE ( pernr LIKE lv_pernr AND
                
     ename LIKE lv_name ).

This will resolve your query.

Regard's,

Shivesh Ranjan.

Former Member
0 Likes

Hi Shivesh,

Thanks for reply,

but i am talking about changing the = opetrator to [*] autmoatically, the moment i put * in name.

I want to work this in same way is SAP R3 Screen selet option.

Thanks & Rrgards,

Arvind Patel

Shivesh
Product and Topic Expert
Product and Topic Expert
0 Likes

HI Arvind,

    It will work same way, along with OVS. U can use OVS for that.

Regard's,

Shivesh Ranjan.