topic Re: Retrieve decimal values from a table in Application Development and Automation Discussions

Retrieve decimal values from a table

Former Member — Mon, 20 Sep 2010 16:29:33 GMT

Hi,

I have a table field EBAN -menge with decimal as well as whole numbers.

Now,I want to retrieve and disply only decimal values from the table based on purchase requisition number.

Can anybody please provide me a solution.

Thanks,

Venkat.

brad_bohn — Mon, 20 Sep 2010 17:15:41 GMT

Use 'frac', 'trunc', and the other mathematical operators for numeric value analysis operations.

Former Member — Mon, 20 Sep 2010 21:01:33 GMT

Hi,

How about WRITEing the MENGE field to a character field with the additional clause UNIT EBAN-MEINS, ie.


DATA: L_MENGE(20)          TYPE C.
WRITE EBAN-MENGE TO L_MENGE UNIT EBAN-MEINS.

This should format per the number of decimals places in the unit in EBAN-MEINS, so EA would be 0 DP but other units may have >0 DP.

Regards, Andy