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
Showing results for 
Search instead for 
Did you mean: 

Conversion of book dimension from decimal to fraction

former_member204024
Participant
0 Kudos

Hi,

I am a crystal report developer and new to SAP R3 environment. I am creating reports with SAP BW queries as source. I am working for a publishing client. They are storing the material (Book) details in the SAP system (Material table). SAP has a provision to capture physical properties of the book like width, height and thickness. They are entering details upto 3 decimal places precision in inches or in specified unit of measure.

When some extracts are generated from SAP System the values like 10.380 is converted as 10-3/8. But the actual 10-3/8 value is 10.375. The rounding is not uniform when I checked with few other values. I came to know from SAP experts these conversion are happened in an IDOC. I don't know much about this.

Can anyone help me in this conversion logic. Since I have to implement the same in my Crystal report. My BW query is just giving it in the decimals, my users are interested in seeing it as fraction since the other exports from SAP is showing it in fraction.

Thanks and Regards,

Subbu S.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

In the user exit of Outbound Idoc, they might have used some custom logic to implement the given logic.

It may vary on other factors as well. In your case, that should be verified or cross checked in your system only.

For converting the decimal to fraction in SAP, you can refer the below function module.

'CONVERT_TO_FRACTION'

1 REPLY 1

Former Member
0 Kudos

In the user exit of Outbound Idoc, they might have used some custom logic to implement the given logic.

It may vary on other factors as well. In your case, that should be verified or cross checked in your system only.

For converting the decimal to fraction in SAP, you can refer the below function module.

'CONVERT_TO_FRACTION'