Sequential number with alphanumeric combinations

[Former Member]

Hi all,

I have a requirement where I have to change the sequential number component of the reconciliation key:

"Sequential number u2013 starts with 00 and will continue to 99, after 99 it will need to start cycling through alpha numeric combinations, so the next number will be A1 and this will continue until ZZ is reached."

The reconciliation key is in this format ORIGIN KEYu2013DATEu2013SEQUENTIAL NUMBER (XX-YYMMDD-XX) I have the sequential number working from 00 to 99 but I don't know how to continue with the alphanumeric combination.

Please advice on how to do this.

Regards.

[kesavadas_thekkillath]

May be this link throws some light for you

link:[http://wiki.sdn.sap.com/wiki/display/Snippets/AlphaNumericNumberRange(0000toZZZZ)]