Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Retrieve decimal values from a table

Go to solution
Former Member

‎09-20-2010 5:29 PM

0 Kudos

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.

.

1 ACCEPTED SOLUTION

Go to solution
brad_bohn
Active Contributor

‎09-20-2010 6:15 PM

0 Kudos

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

2 REPLIES 2

Go to solution
brad_bohn
Active Contributor

‎09-20-2010 6:15 PM

0 Kudos

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

Go to solution
Former Member

‎09-20-2010 10:01 PM

0 Kudos

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