topic Re: Alpha numeric characters in Data element in Application Development and Automation Discussions

Alpha numeric characters in Data element

Former Member — Tue, 08 Mar 2011 03:26:12 GMT

Hello abap gurus:

I created a table in which i declared a data element is of type character length 9, so that it will allow both numeric and alpha characters,

but now in testing it is also allowing special characters like @#_&*) etc.

So please let me know how to remove this speical characters and it should allow both numeric and alphabets.

Waiting for the response.

Thanks,

Ratnakar.

Re: Alpha numeric characters in Data element

Sandeep_Panghal — Tue, 08 Mar 2011 03:49:37 GMT

The Special characters are also char type so it will allow these values .

You can do validations at selection-screen.

Re: Alpha numeric characters in Data element

Former Member — Tue, 08 Mar 2011 05:19:31 GMT

Thanks for reply Sandeep.

It is for a data element in custom table.

So do you want me to validate the field in maintenance screen source code??

Thanks,

Ratnakar.

Re: Alpha numeric characters in Data element

Sandeep_Panghal — Tue, 08 Mar 2011 05:53:40 GMT

If you have maintenance generator for this table , you can do the validation on save under events.

Re: Alpha numeric characters in Data element

Former Member — Tue, 08 Mar 2011 06:07:58 GMT

Hi,

Try using LRAW as Data Type for your data element.

Regards,

Gopal

Re: Alpha numeric characters in Data element

AnjaneyaBhardwaj — Tue, 08 Mar 2011 07:34:11 GMT

Hi If you are updating the table using the table maintenace generator then you need to put the code in the events 01 of table maintenance . in this define event you will get an option of creating include where you can put your validation code .

Re: Alpha numeric characters in Data element

RaymondGiuseppi — Tue, 08 Mar 2011 07:55:30 GMT

You could assign a customer [conversion exit|http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ee19446011d189700000e8322d00/frameset.htm] to the [domain|http://help.sap.com/saphelp_nw70/helpdata/en/cf/21edf2446011d189700000e8322d00/frameset.htm] of the data element.

Suppose you name it ZALPHA

- Create a Function group

- Create a FM CONVERSION_EXIT_ZALPHA_INPUT (*) - there code work area = INPUT, remove not allowed characters, condense and then OUTPUT = work area.

- Create a FM CONVERSION_EXIT_ZALPHA_OUPUT (*) - there just code OUTPUT = INPUT.

Now affect the conversion exit to the domain.

Regards,

Raymond

(*) Use any SAP conversion exit as a template.

Re: Alpha numeric characters in Data element

Former Member — Tue, 08 Mar 2011 10:34:32 GMT

Hi Ratna,

Write a coversion routine( used to vakidate the field ) and assign it at data element level.

Thanks

Re: Alpha numeric characters in Data element

Former Member — Tue, 08 Mar 2011 12:23:34 GMT

HI,

Check this [link.|] This should help you.

Re: Alpha numeric characters in Data element

Former Member — Mon, 14 Mar 2011 06:47:08 GMT

Hi Ratna,

If you want to Remove the special character during the save operation in your Z-table, if you have TMG you can do validate in the TMG Coding by including the validation in Event, and remove the Special character using the function Module.

If you want to remove the Sepcial character in your report you can use this function module - SF_SPECIALCHAR_DELETE

Regards,

Ragunathan.R

Re: Alpha numeric characters in Data element

Former Member — Wed, 16 Mar 2011 14:10:13 GMT

Hi,

Try using NUMC as data type. It may restrict those special characters.

Regards,

Uday.

Re: Alpha numeric characters in Data element

Former Member — Thu, 17 Mar 2011 12:52:45 GMT

Hi,

You can try LRAW data type for data element else you can write constraint at time of save data through Table maintance Generator.

In Event01(check before save), write Function module SF_SPECIALCHAR_DELETE.

Both the way you can delete special character from your data.

Regards,

Kunjan