Issue with Decimal Values in Bex Reporting

[Former Member]

hello gurus,

I have extracted data from 2LIS_13_VDITM. In the ODS when I look at the Active data, column Billing Qty Sls Units - it shows "13,190 " and the Sales Unit is "KM".

ITEM SALES UNIT Billing Qty :Sales Unit

-

---

-

---

-

---

10 KM 13,190

20 KM 0,500

In R3 table VBRK also it stores in the above format.

But while reporting it rounds of the data as 13,000 and 1,000.

How can i get the actuals, in reporting also.

Pls advise. thanks in advance.

[Former Member · Accepted solution]

Hello Roberto. thanks for ur reply. cud u be more precise. i will tell u the settings in RSA1.

in the additional properties tab of info object (0INV_QTY):

Business Explorer

-

---

Decimal places - 0.000

Display - Not defined

Bex Description - Short Descp

Miscellaneous

-

---

Key Figures with Max Precision - (checkbox is unchecked)

Attribute Only -(checkbox is unchecked)

Now i just checked Key Figures with Max Precision and activated the infoobject. executed the report again. it still shows the same output. Do I need to extract data again.

rgds

[Former Member · Accepted solution]

Hi bw,

Roberto recommended to you to check the properties of your KF in BEx Query Designer.

Best regards,

Eugene

[Former Member · Accepted solution]

Hi dear,

I read several OSS Notes (569758 'Rounding error in the display', 155837 'Tips & tricks with decimal places', 377847 'Display of only rounded quantities',...), but nothing useful for you (but it's better if you check again...)

Anyway, table T006 controls the default setting of the individual units of measure. The T006-DECAN field gives the number of decimal places displayed and T006-ANDEC gives the number of decimal places on which you want to round the output.

Check the entries in table T006 in the Customizing.

To do this, select transaction SPRO:

-> BW Customizing Implementation Guide -> General settings -> Check units of measurement -> Select the Units of measurement button

Hope it helps !

Bye,

Roberto

[gerald_fuller · Accepted solution]

Hi

same issue et same solution as Roberto explained with CUNI transaction code (SPRO).

it works,

thx.

Gerald.

[Former Member]

Hello Roberto ,Eugene ,Somnath.

thanks a Ton. my issue is solved. all of u were right.

the reason i cud not find KM was b'cas i did not select Length in my Dimensions.

Now it is coming all right. Thanks Again

Points to all...

best regards,

TR PRADEEP

[Former Member]

Hi Eugene -Scaling it to 1 did not help.

Hi Roberto -> I had a look at the entries in T006 for KM (kilometers)and M(meters). this is what i got.

[Int. meas. unit] [Decimal.pl.rnd.] [Decimal places]

-

---

-

---

-

---

KM | 0 | 0

M | 2 | 0

And in SPRO in Src System and BW Sytem there is no mention of KM and meters.

Message was edited by: bw

Message was edited by: bw

Message was edited by: bw

[Former Member]

bw,

Have you tried what Somnath said?

In the screen according to Somnath path (or tcode CUNI) in the field for input using drop-down menu choose 'Length'. Then click on Units of measure button. In a new screen scroll up (if needed). Find 'KM' and do what Somnath recommended.

Best regards,

Eugene

[somnathkumar]

Hi,

In the BW system, goto SPRO -> SAP NetWeaver (if 3.5) -> General Settings -> Check Units of Measurement -> Units of Measurement -> Choose the unit corresponding to 'KM' -> Click on 'Details' button in the toolbar.

Look the field 'Decimal Pl rounding'. Change this to 3 or whatever value you choose and see if it works.

[Former Member]

hi Eugene,

i even checked the properties in bex query analyzer.

Constant Selection - no check

Scaling Factor - Nothing Defined

no of decimal places - 0.000

calculate result as - nothing defined

calculate single values as - nothing defined

is there anything wrong in the above settings.

thanks

[Former Member]

bw,

Set scaling factor to 1.

Best regards,

Eugene

[Former Member]

Take a look to the property of your KF in BEx and in RSA1 (in other properties there is checkbox...)