vendor_add_data badi or enhancement

hai to all experts,

i have a requirement when we create vendor (xk01) if the city is hyderabad then in the lfa1 table the vendor number should be saved as

example 'hyd96554' .

i have already writen the code in include ZXF05U01 in function module EXIT_SAPMF02K_001.

*code:*

if i_lfa1-ORT01 = 'hyderabad'.

shift i_lfa1-lifnr left deleting leading '0'.

concatenate 'hyd' i_lfa1-lifnr into i_lfa1-lifnr .

endif.

the code is excuting well and in i_lfa1-lifnr the desired value (hyd7684)

is getting saved.

but in lfa1 table it is getting saved as 000007684.

what should i do?