Skip to Content
avatar image
Former Member

Retrieve decimal values from a table

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.

.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 20, 2010 at 05:15 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 09:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded