underscore not allowed as a table key ?

[Former Member]

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

[Former Member]

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

Thanks

Bala Duvvuri

[Former Member]

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

[Former Member]

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