topic Re: Configure Data Type to avoid wrong Entries in Application Development and Automation Discussions

Configure Data Type to avoid wrong Entries

Former Member — Thu, 02 Feb 2006 13:55:08 GMT

Hi,

is it possible to configure a data type to avoid non corresponding entries?

For example a field like CCNN.NNNN-NN.NNNN

C should be a Character, N a number. All differences should be rejected.

Regards,

Udo

Re: Configure Data Type to avoid wrong Entries

RichHeilman — Thu, 02 Feb 2006 14:13:46 GMT

You can't set up a datatype like that, but you can do this with a little coding.




report zrich_0002 .

data: s type string.
data: length type i.

s = 'A11234A6789'.
length = strlen( s ).

if s+0(2) ca '1234567890'.
  write:/ 'first two characters are not characters'.
endif.

length = length - 2.
if  s+2(length) ca sy-abcde.
  write:/ 'other characters are not numbers'.
endif.

Regards,

Rich Heilman

Re: Configure Data Type to avoid wrong Entries

Former Member — Thu, 02 Feb 2006 14:18:07 GMT

Hi,

Create a number range object using SNRO transaction

for table field.

Regards

Amole

Re: Configure Data Type to avoid wrong Entries

Former Member — Thu, 02 Feb 2006 16:19:04 GMT

Hi,

If you want to configure such a data type in dictionay then you can attach conversion routine to that field in domain. Sample code provided by rich may help you in writing routine. You can flash messages when there is any error in input to that filed through conversion routine.

Regards,

Ramesh