topic Re: underscore not allowed as a table key ? in Application Development and Automation Discussions

underscore not allowed as a table key ?

Former Member — Thu, 07 Oct 2010 09:35:34 GMT

Hello

We haee created a table whose primary key is a specific data-type (ZCHAR) this data-type is defined has beeing a single character, upper and lower cas allowed. However when filling the table via sm30 using the generated table manager, we are not able to enter a single underscore in this field. This entry is reverted to a space when we press "enter".

Does any have any idea of what we're doing wrong and/or how we can work around this problem ?

regards

Guillaume PATRY

Re: underscore not allowed as a table key ?

Former Member — Thu, 07 Oct 2010 09:55:40 GMT

I think underscore is not allowed.i have the same situation in my system

Thanks

Bala Duvvuri

Re: underscore not allowed as a table key ?

Former Member — Thu, 07 Oct 2010 10:00:22 GMT

Hi!

Wildcard characters can be used to create the pattern in dobj, where "%" represents any character string, even an empty one, and "_" represents any character.

See more in ABAP help for SELECT - WHERE - LIKE

I think, you cannot use wildcard characters because of there specific meaning in database selection

Regards,

Klaus

Edited by: Klaus Babl on Oct 7, 2010 12:02 PM

Re: underscore not allowed as a table key ?

Former Member — Thu, 07 Oct 2010 11:51:15 GMT

thanks for the help. we're going to to this using ABAP program, since its the entrie that block the _ (also the %, as mentionned).

regards