topic Re: ALV Problem in Application Development and Automation Discussions

ALV Problem

Former Member — Thu, 27 Mar 2008 01:31:48 GMT

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?

Re: ALV Problem

Former Member — Thu, 27 Mar 2008 01:49:43 GMT

Hi Kumar,

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

Regards,

Atish

Re: ALV Problem

Former Member — Thu, 27 Mar 2008 01:55:44 GMT

Hi Atish

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

Thanks

Kumar

Re: ALV Problem

Former Member — Thu, 27 Mar 2008 02:56:36 GMT

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.

Re: ALV Problem

venkat_o — Thu, 27 Mar 2008 09:14:15 GMT

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