topic Alpha numeric serial No generator in Application Development and Automation Discussions

Alpha numeric serial No generator

Former Member — Mon, 10 Feb 2014 10:48:20 GMT

Hi Folks,

I want to know if there is any function module for generating Alpha Numeric serial Number for the specified range in SAP.

Thanks & Regards ,

Vikram

Re: Alpha numeric serial No generator

adrian_mejido — Mon, 10 Feb 2014 11:02:27 GMT

This message was moderated.

Re: Alpha numeric serial No generator

Former Member — Mon, 10 Feb 2014 11:19:11 GMT

Hi adrian,

i need to generate for 5 digits..any other way of generating nos.

Re: Alpha numeric serial No generator

adrian_mejido — Mon, 10 Feb 2014 11:35:13 GMT

Hi vikram,

You can use that example code an modify it to your purpose.

Re: Alpha numeric serial No generator

RaymondGiuseppi — Mon, 10 Feb 2014 12:19:18 GMT

You can convert a numeric value, generated with NUMBER_GET_NEXT on a classic number range, to an alphanumeric range with a FM like TB_LIMIT_CONVERT_DEC_TO_36.

Regards,

Raymond

Re: Alpha numeric serial No generator

Former Member — Fri, 14 Feb 2014 05:27:28 GMT

Thanks all ....used the below code.

REPORT YALPHASERIAL.

data: v_str(7) type c,

v_hx(1) type x,

v_len type i,

v_off type i.

field-symbols <fs>.

v_str = '12B345Z'.

*v_str = 'Z9Z99Z9'.

Do 10 TIMES.

write:/ 'Initial:', v_str.

v_len = strlen( v_str ).

v_off = v_len - 1.

do v_len times.

if v_str+v_off(1) between 'A' and 'Z'.

if v_str+v_off(1) lt 'Z'.

assign v_str+v_off(1) to <fs> casting type x.

add 1 to <fs>.

exit.

else.

v_str+v_off(1) = 'A'.

endif.

elseif v_str+v_off(1) between '0' and '9'.

if v_str+v_off(1) lt '9'.

v_str+v_off(1) = v_str+v_off(1) + 1.

exit.

else.

v_str+v_off(1) = '0'.

endif.

v_off = v_off - 1.

enddo.

write:/ 'Final:', v_str.

ENDDO.