Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Getting dump from search help

Former Member
0 Likes
710

Hello Experts,

I have created a ZMM* search help and included it to MAT1 search help. Everthing works fine unless you put a '*' (star) alongwith other input, otherwise getting dump.

Fields i use in sh ;

MATNR

EXTWG

MATKL

BISMT

MFRPN

MAKTX

If you put a number without '' into the matnr it works fine. However when you put '2100' for example, its getting dump stating;

Runtime Errors SAPSQL_LIKE_PATTERN_TOO_LONG

Except. CX_SY_DYNAMIC_OSQL_SEMANTICS

ABAP/4 Open SQL statement with WHERE ... LIKE and pattern too long.

Any help will be aappreciated,

Thanks in advance.

Yasin

2 REPLIES 2
Read only

Former Member
0 Likes
461

Hi ysnbdr

If you know, in SAP search * after any word means you are looking for further chanracters in the field same way you should not use * as a search help selection critaria.

EG.

In Material master MM01 if you know material starts from MAT but you don't know exact Material Name then what you do you will press F4 then in search help write MAT* then press enter.

Now you will get multiple entries for MAT* from this table, same way I think your search help is facing the probllem as % and *** are selection symbol for string.

Regards,

Umang Mehta

Read only

Former Member
0 Likes
461

hi sir,

you can't create symbols in dictionary so you have created ,so have you activated you would have selected activate any way so your facing errors so create once again with out any symbols added to it

thanking you