Skip to Content
Apr 11, 2010 at 06:12 PM

Conversion of book dimension from decimal to fraction



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.