deleting zeroes

[Former Member]

Hi Abapers,

Thanks in advance and will give points to the responders,

Iam trying to replace '000000000' in one filed for 10000 customers. with my logic i am able to change for 1000 customers. please help me on to change for 10000 customers at a time. am using UPDATE command.

[Former Member]

hi govardhan,

try using, it might help you

CONVERSION_EXIT_ALPHA_OUTPUT : Eliminate zeros to the number at the left

reward if useful..

[Former Member]

hi,

just follow dis link and ur problem is definately solved.

plzz do give points too.

regards,

ric.s

[Former Member]

dis d link and u will get solution to the problem,plzz do give points tooo.

regards,

ric.s

[Former Member]

Hi Ric .s,

There is no link in ur reply.Plz give me the lionk so that i will go through it.

[Former Member]

hi govardhan,

plzz follow dis link and it will solve ur problem..

just double click it or paste it in ur adress bar.

plzz do give points too.

regrads ,

ric.s

[Former Member]

THIS IS NOT ADVISABLE, TRY TO RUN A BDC FOR <b>XD02</b> TRANSACTION AND POPULATE THE SAME FIELD.

[Former Member]

Hi govardhan,

Can u be more specific? u want delete the leading zeros of a field in db table? or to replace '0000000000' by something else?

Regards,

Amine

[Former Member]

Hi Amine,

Actually i have more than 10,000 records in a table. a particular field is having '0000000000' as the entry in all records. so from my report i need to replace that field in all the records with Blank.Iam replacing upto 1000 records in a singleshot.but i want it for 10000 records in a single shot

Please help me out.

[Former Member]

Hi govardhan,

Did u try this?

UPDATE <i>your_table</i>

SET <i>your_field</i> = space.

Reward if useful.

Regards,

Amine

[Former Member]

Hi Amine,

as i told u, i used the same command but it is allowing me upto 1000 records only. but if i use more than thousand it is not allowing me

[Former Member]

Hi again govardhan,

Where do you specify a 1000 records?

And then what do you write exactly in your UPDATE command?

You have only to execute the instruction as i told u, and there will be no limitation!

[Former Member]

Hi amine,

yeah i know that one but in my case it is not behaving like that.

UPDATE kna1 SET zmedfunc = ''

zappcode = ''

WHERE kunnr IN s_kunnr

AND zmedfunc = p_zmedfc

AND zappcode = p_zappce.

this is what i used.

[Former Member]

OK, that looks good.

is it giving you an error message?

[Former Member]

no amine it is not giving any error message. but as i told u itz only allowing me to update upto 1000 records. but not for more than 1000