Zeros in a File Download

[Former Member]

Hi All,

In ALV list display, we can restrict the ZERO valued cells as space with NO-ZERO addition. Like that how to replace the ZERO with space in downloading a table to an EXCEL file...?

Thanks in advance.

[Former Member]

hi,

for this you can use function module :

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = wa_crrb_audit-cust_acct_id

IMPORTING

output = wa_crrb_audit-cust_acct_id.

hope it will help you

regars

rahul sharma

[Former Member]

Hi,

In the sense that what i want is zeros should be replaced as space while downloading it.

It is known that it can ve done for a variable with conversion exits.

Regards,

R.Nagarajan.

[Former Member]

Hi,

Here, we can't change the data type for replacing zeros with space.

We can't condense an internal table.

Regards,

R.Nagarajan

[Former Member]

Hi Moorthy,

One thing important to remember is that, depending upon the data type you are using for refering the field will play the important role.

Eg: data: field1(10) type n.

data: field2(10) type c.

If field1 = 1234567, the internal format will be 0001234567

if you want to remove the zeros you have to move field1 to field2 which of character type and you will get output as 1234567.

[Former Member]

hi ,

1) For removing the zero u can a function 'coversion_exit_alfa_output'

this will remove number of zero which are extra from type of the field

declared.

2). The data type you are using for refering the field will play the important role.

If data = XXXX, the internal format will be 0000XXXX

if u have declared ,DATA(8) TYPE N.

if you want to remove the zeros you have to move DATAto DATA1 which of character type and you will get output as XXXX.

Edited by: Prashant singh on Sep 11, 2008 7:02 AM

[Former Member]

HI,

you can condense the final internal table with NO-GAPS after populating records in it.

this will remove the zeros in case you do not have conversion exit for that field.

hope this will work.