APD export to PCFile

[Former Member]

Hi,

I am generating a file using APD query and the formulas in the query are exported as 'exponential values' although in the query properties they are set as 2 decimal places. This is happening only for formulas calculated in the query (I have tried with calculated key figures but even they are bahaving the same way), regular key figures are displaying as 2 decimal places in the generated file. Any inputs appreciated.

Note: All key figures are currency values with 2 decimal places.

Thanks!

[former_member231709]

For example, var formatted_text for output (you must put a transformation before saving to file):

DATA: float          TYPE f,
      formatted_text TYPE c LENGTH 6.
WRITE  float TO formatted_text EXPONENT 0 DECIMALS 0.

[s_anusha]

Any solution for this please?

[Former Member]

Hi experts,

Any advice on this issue? I have the same problem, exactly the same. The only thing that comes to my mind is to include an abap routine before the extract file definition, and multiply all these key figures by a variable with two decimal, with value 1.00

I'm not sure if this is going to work..

please help!

thanks!

[Former Member]

I am also looking for a resolution to this same exact issue. Did you guys find one? Does anyone else know of a way around this?