cancel
Showing results for 
Search instead for 
Did you mean: 

How to change Decimal places?

Former Member
0 Kudos

We have an InfoObject called Unit Cost:

Type/Data Type = Amount

Data Type = CURR - Currency field, stored as DEC

I copyed this template in PSA. It displayed like this:

Field Desciption Template Data Type Lngth Decimal Format

/BIC/USUNTCST Unit Cost USUNTCST CURR 17 2 External

I need to see 0.1234 instead of 0.12. How to fix this?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can change the decimal places in the Infoobject maintenance (Business Explorer tab). Also, you can change the settings in the properties of the key figure (Unit Cost) in the query.

Thanks

Former Member
0 Kudos

I saw that. But I want to change the decimal places from 2 to 4 when data gets loaded to PSA.

Former Member
0 Kudos

Hello Zheng,

I also have similar issue. Also have posted following messge in SDN:

In case u get some solution, please update my thread also.

Thanks,

Mainak

Former Member
0 Kudos

I wonder why you want that to happen in PSA. We do not use PSA data for any reporting purpose directly. Can you please let me know the criticality of this in PSA.

Regards

Pradip

Former Member
0 Kudos

Hello Pradip,

This is actually same issue I am having in

We need to integrate non-SAP and SAP sales data. The non SAP data comes in 4-5 decimal places. Currently I can show only till 2 or 3 decimal places.

Please advise. U can update my posting also.

Regards,

Mainak

Former Member
0 Kudos

First we are loading data from CSV to PSA (Mandotory). CSV file shows 4 decimal places. After loaded, we only take 2 decimal places which is in-correct. I still don't know how to fix this yet.

Answers (1)

Answers (1)

Former Member
0 Kudos

You can change the data element on a key figure. a custom data element can have any number of decimal places.

Create a data element in SE11, and use the info below to extend your infoobject.

Changing the data element of a key figure.

From OSS note 460652 Extending Key Figures in BW

You can change the data element of a key figure and use your own domain. In principal, you can define the number of characters freely according to your requirements. The following restrictions apply:

u2022 The domain MUST HAVE the same data type as the one that the system assigned to the key figure in the standard case. In other words: The data type must not be changed when you assign your own domain.

u2022 For example: If the BW system provides the domain RSKYFAMO with the data type CURR for a key figure, you can only assign domains that also have the data type CURR.

u2022 If you have already posted data for this key figure, you must convert the tables.

u2022 In releases prior to BW 2.0B/2.1C, you must readjust the domain of the key figure after each transport and activation.

u2022 For an amount key figure or a quantity key figure, you may only change the number of characters before the decimal point and not the number of decimal places.

Procedure for Release BW 3.0 and higher

Change the field DOMANM in the table RSDKYF and enter your own domain here. You then have to activate the key figure. The key figure can then be transported and is also generated in the target system with this domain. The prerequisite is, of course, that the domain exists in the target system.

Correction option 2: Special handling for the key figures 0LATITUDE and 0LONGITUDE

The two key figures 0LATITUDE and 0LONGITUDE use a specific domain: RSKYFGIS. If the problem described above occurs, you should enhance the domain directly using transaction SE11.

Former Member
0 Kudos

I would be very careful when checking decimal places for currencies within any SAP table BW or not

All SAP and BW tables hold decimals for currency fields to 2 decimal places - BUT on output they use the TCURX table to reformat the output

In ABAP this is achieved using a write currency statement - and in BW the standard Bex output tools via the OLAP BAPI will automatically do this

eg 100.00 can be expressed in output as 10000 or 10.000 or 100.00 depending on whether the currency attached to it has a TCURX entry of 0, 3 or not exists... (ie if it doesnt exist in TCURX it is defaulted to 2 dp)