topic Re: Re: Replace zeros with blank using FM in Application Development and Automation Discussions

Re: Replace zeros with blank using FM

Former Member — Wed, 11 Oct 2006 11:15:29 GMT

Hi All,

We hav a requirement tht, while downloading the materail master from DB Table we need some field values to be blank instead of zeros.B'cas we may need to change more than 35 field's value from zero to blank.

Is there any Function Module avialable fr this, or is somebody has faced similar problm pls do suggest.

Help and Suggestion will be much appreciated.

Thanks & Reagrds

Ramesh.

Re: Re: Replace zeros with blank using FM

Former Member — Wed, 11 Oct 2006 11:22:04 GMT

U can just use the NO-ZERO option with WRITE..there is similar factiliy in ALV even, where you can initialise the no-zero field in the catalog to X.

In that case it would be blank if the value of the column is zero.

REgards

Anurag

Re: Re: Replace zeros with blank using FM

Former Member — Wed, 11 Oct 2006 11:23:58 GMT

Hi Ramesh,

I think following can help you

You can use the syntax 'REPLACE [{FIRST OCCURRENCE}|{ALL OCCURRENCES} OF] '

Here we you need to use a character field as the target field.

Thanks...

Preetham S

Re: Re: Replace zeros with blank using FM

Former Member — Wed, 11 Oct 2006 11:29:09 GMT

Hi Ramesh,

There is one keyword called 'OVERLAY'. By using this you can actually insert blanks in the place of 0's. Just before downloading the datas you can try using this command.

I do not know about any FM for it.

Regards,

Balaji

Re: Re: Replace zeros with blank using FM

Former Member — Wed, 11 Oct 2006 12:27:40 GMT

Hi ramesh,

1. We can use the standard conversion exit FM.

2. CONVERSION_EXIT_ALPHA_OUTPUT

00055 --> 55

regards,

amit m.