ALV Problem

[Former Member]

Hi

My Alv program extracted some employee details. The program output is displaying correctely. when i try to download the data to excel some employee numbers missing. Anybody know what cause is this?

[Former Member]

Hi Kumar,

have you tried to download the data in other file format? Is the same issue there?

Regards,

Atish

[Former Member]

Hi Atish

I tried in HTML format. It is ok. Only excel got problem

Thanks

Kumar

[Former Member]

Please try to avoid any leading zeros in ALV output. In other words use conversion exits like 'CONVERSION_EXIT_ALPHA_OUTPUT' before displaying the ALV output

siddu.

[venkat_o]

Hi,

Try to avoid leading zeros. you can avoid leading zero while building field catalog

Check below sample code.

w_fieldcat-fieldname = 'PERNR'.
  w_fieldcat-tabname   = 'I_PA0001'.
  w_fieldcat-seltext_m = 'Employee No'.
  w_fieldcat-no_zero   = 'X'.                   "Set X here not to display leading zeros
  APPEND w_fieldcat TO i_fieldcat.
  CLEAR w_fieldcat.

Thanks

Venkat.O