XK01 (Sys generates NR starting with 1 alphanumeric followed by number)

Hi,

We have 3 Vendor account groups:

1: Domestic

2:Import

3: Others

Now all these account groups have internal NR, i.e. Domestic account (10001-19999), Import (20001-29999), Others (30001-39999)

Now my Client wants when ever we save Vendor master record, System has to generate Number range starting with 1 alphanumeric letter followed by 5 numeric digits. Alphabet should be the first letter of the Vendors Name mentioned.

i.e. For Domestic vendor : Name: Raj, NR: R10001.

For Domestic vendor : Name: Rajeshwar, NR: R10002

For Domestic vendor : Name: Sameer , NR: S10001

How to do it.

Utsav