topic Decimal error in Application Development and Automation Discussions

Decimal error

Former Member — Wed, 06 Dec 2006 15:01:44 GMT

Hi friends ,

This sounds weird anyways here is the issue . I am calculating a value and appending it to an internal table say itab1 . Later I move the value from itab1 to output_table for printing in the report . When the value is in itab1 it shows as 0.22 but now when the value is in output_table the value is 0.000022. How is this possible when I defined the value in both internal tables as same . Please advise .

Here is a sample code .

Begin of itab1 .

value TYPE p DECIMALS 2,

end of itab1.

Begin of output_table.

value TYPE p DECIMALS 6,

end of output_table.

Start of selection

Append itab1 to output_table .

end of selection .

Thanks ,

Hari

Re: Decimal error

sridhar_k1 — Wed, 06 Dec 2006 15:10:13 GMT

try move-corresponding itab1 to output_table and append output_table .

regards

Sridhar

Re: Decimal error

Former Member — Wed, 06 Dec 2006 15:13:22 GMT

Hi Hari,

Maintain same type declaration for VALUE in both internal tables ITAB1 and OUTPUT_TABLE.

Change the type declaration of OUTPUT_TABLE for VALUE as in bold.

Begin of itab1 .

value TYPE p DECIMALS 2,

end of itab1.

Begin of output_table.

*value TYPE p DECIMALS 6,

<b>value TYPE p DECIMALS 2,</b>

end of output_table.

Thanks,

Vinay

Re: Decimal error

Former Member — Wed, 06 Dec 2006 15:16:30 GMT

i think ur final table has been declared as some database field which has 6 decimals....u need to declare this field as type P decimals 2...

so when u move it moves 0.22 and report shows as 0.22

Re: Decimal error

Former Member — Wed, 06 Dec 2006 15:20:32 GMT

Hi hari,

Make field type same in both itab1 and output_table.

Then u will get ur required o/p.

If it helps, close the thread by giving points to all useful answers.

Regards,

Kumar