CRM - BPS Integration: Decimal places for Keyfigures of type Quantity

[Former Member]

Hi Friends,

Here is my issue:

I have a planning layout integrated with CRM Marketing Planner application. In this I am using some key figures of type Quantity and some of these are variable unit fields and some with fixed units. I have specified decimal places 3 in BPS Lay out and in Planning services settings also. But, it is not taking decimal places while entering the data in CRM. If I enter values with decimals, then it is rounding to next round figure. For eaxmple I have one Key figure Pounds per case and the value is 7.5 Lb, it is getting rounded to 8.

Even I have one more case for executing a planning function from CRM, in this if I execute the planning function from CRM then the derived value for Quantity is being rounded to next round value. If I run the same function module in BI, then it gives exact value with decimals.

Appreciate your inputs to over come this.

Thanks,

Ravi

[former_member93896 · Accepted solution]

Hello Ravi,

check the decimal settings for the unit of measure in transaction CUNI.

Regards,

Marc

SAP NetWeaver RIG

[Former Member · Accepted solution]

Hi Marc,

Thanks for the information.

I didn't find any relevant setting in t-code CUNI.

I tried with floating point number as my unit measure is always fixed to Lb, we are treating with keyfogure of type number which is giving the option to have 4 decimal places.

Tanks,

Ravi

[Former Member]

What setting you have for the key figure in BW ?

Ravi Thothadri

[Former Member]

Earlier I was having Keyfigure with Quantity and Fixed Unit of measure LB. This was allowing me to enter no decimals. If I try to enter decimals, it was rounding off.

Now I have Key figure with numbers.

[Former Member]

CAn you share the solution how you resolved this issue

[Former Member]

Hi Raveendra,

Instead changing a Data type of keyfigure from Qty to Number use FLTP - floating point number and adjust three decimal point from Additional information tab.

Or Try,

In CUNI T-code open LB unit and in Conversion frame adjust "Decimal pl. rounding" value for decimal point.

Hope this will help you.

Regards,

Kiran