topic Re: Getting dump from search help in Application Development and Automation Discussions

Getting dump from search help

Former Member — Fri, 28 Jan 2011 14:59:03 GMT

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

Re: Getting dump from search help

Former Member — Tue, 01 Feb 2011 06:36:11 GMT

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

Re: Getting dump from search help

Former Member — Thu, 26 May 2011 14:37:07 GMT

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