‎2011 Jan 28 2:59 PM
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
‎2011 Feb 01 6:36 AM
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
‎2011 May 26 3:37 PM
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