export internal table to excel...

[Former Member]

Hello everyone!

I have an ALV with one column like this:

netwr LIKE vbrp-netwr

In the ALV Catalog, i allready tried this options:

  CLEAR fieldcat_linha.
  fieldcat_linha-fieldname = 'NETWR'.
*  fieldcat_linha-ref_tabname = 'VBRP'.
*  fieldcat_linha-ref_fieldname = 'NETWR'.
  fieldcat_linha-reptext_ddic = text-126.
  fieldcat_linha-decimals_out = '2'.
  APPEND fieldcat_linha TO fieldcat_tab.

The problem is, when i export this to an excel file, i get 2 decimals only in values like this: '1.000,00'

If the value is '200,00' the export returns only '200' in the excel file. Does anyone know how to round this problem?

Thank you.

Message was edited by: Nuno Santos

[Former Member]

I dont think this is the problem with ABAP. Try changing the customising settings for excel from control panel.

Ankur Bhandari

p.s Rewqard appropriate points if the answer helped

Message was edited by: Ankur Bhandari

[Former Member]

You probably need to reference the currency code in the field catalog. If the field in your table is called WAERS....

fieldcat_linha-currency = 'WAERS'.