Replace zeros with blank using FM

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi ramesh,

1. We can use the standard conversion exit FM.

2. CONVERSION_EXIT_ALPHA_OUTPUT

00055 --> 55

regards,

amit m.