topic Re: Decimal issue while displaying output in Application Development and Automation Discussions

Decimal issue while displaying output

sreekanth_n2 — Thu, 05 May 2016 14:52:12 GMT

Hi Experts,

Im fetching amount BSEG-DMBTR to display in Report output.

to field catalog , passing DMBTR as reference only.

Even during debugging I observed that the amount in the internal table is same as FB03 document/BSEG-DMBTR. But in output, decimal is being removed and displaying the whole amount i.e., amount is being multplied by 100.

Please help in resolving the issue.

Regards,

Sree

Re: Decimal issue while displaying output

shruthi_nr — Thu, 05 May 2016 15:01:42 GMT

Hello Sreekanth,

you can try using WRITE statement rather MOVE for amount fields while filling output table.

Regards,

Shruthi

Re: Decimal issue while displaying output

Former Member — Thu, 05 May 2016 15:05:56 GMT

With currencies, you have to specify the currency to be used when displaying the value. With the WRITE statement this is done using the CURRENCY clause, in ALV grids, this is done by naming the associated currency field in the CFIELDNAME (?) field in the Field Catalog.

The same applies to quantities where the UNIT clause for the WRITE command is used, or the QFIELDNAME field in the field catalog for ALV grids.

Rich

Re: Decimal issue while displaying output

shruthi_nr — Thu, 05 May 2016 15:22:26 GMT

Hi,

Could you please provide the field catalogue details what exactly its filled for DMBTR field?

Re: Decimal issue while displaying output

prajeshdesai — Thu, 05 May 2016 15:45:44 GMT

You need to add your currency field in your catalog,


FIELD_CAT-CFIELDNAME = FIELDNAME.       "DMBTR in your case

also look at problem in currency in fieldcatalog | SCN

Hope this helps.

Re: Decimal issue while displaying output

Clemenss — Thu, 05 May 2016 16:55:46 GMT

Use CURRENCY addition of WRITE statement which will control the number of decimals.

in ALV/SALV: google helps

Basic question.

Regards Clemens

Re: Decimal issue while displaying output

Former Member — Fri, 06 May 2016 08:03:33 GMT

Or read my reply.....