Skip to Content

Business need:

Business might wish to see few Key metrics of Data type (Amount, Quantity, Numbers)  with more than 2 or 3 decimal places at the Report Level..

Use/Purpose:

Ideally when a new key figure is created of type Amt, Qua and Num, the Standard

Domain of the Key Figure SAP would show upto 0 or 2 decimal places by default.

When the business would want to look at the key metrics with more than 2 or 3 decimals,

We will neither be able to change it at the Report level nor at the key figure level because

Standard domain created for the Amount, Quantity and number type keyfigures will be 2 or

3 decimal places.

To address the above issue we have the below workaround to change the decimal place.

Key figures with the data type ‘DEC’, ‘CURR’ or
‘QUAN’ are created in BW with a fixed length and a fixed number of decimal
places.

The key figures are generated with a fixed
domain, that is, a fixed length.
The domain depends on the type and data type of
the key figure:

Data Type Domain Character Decimal Place
AMO RSKYFAMO 17 2
QUA RSKYFQUA 17 3
NUM RSKYFNUM 17 3

These values are not sufficient for many requirements.

Below is the standard domain maintained for
all Amount type of Keyfigures.

S1.png

We can make use of the same keyfigures in such
scenario with the new Domain Creation

Proposed Solution:

We can make use of the same keyfigures in such
scenario with the new Domain Creation.

This involves the below steps

  • Creation of new Customized Domain.

  • Maintaining the entry of new domain in table
    RSDKYF for the Key Figures

Procedure:

Creation of New Domain

  • Go to SE11 and create a new Domain copying the
    existing standard domain.

Screenshot2.png

Screenshot3.png


You can provide the decimal places as per the requirement. 6
Decimal Places is given as an example here.

  • Activate the
    domain and collect in a request as you have to send this domain to other
    Systems
  • We do not have
    authorization to replace the Standard Domain with the new Customized Domain
    directly in the data element of the key figure. We will be able to do that in
    debugging mode by going to RSDKYF Table.
  • Hence Replacing
    the existing Standard Domain with the new Domain can be done as below
  • Go to zse16 and enter the table RSDKYF and
    give selection of your Key figure.

Screenshot4.png

Ensure that the display is SE16 Standard list by following the
below steps.

Screenshot5.png

Screenshot6.png

Edit the Key metric (Both M and A Versions)
and enter the new customized domain and save.

Screenshot7.png

Now re-activate the Keyfigure then the new
domain will be reflected.

Screenshot8.png

If the authorization to edit the table
entry we have the other workaround to change the domain.
Steps to be followed:

  1. Select the row from the table ,
    enter /h->enter-> enter
  2. You can find the else if code
    -> double click there

Screenshot9.png

3.     Change the code from SHOW to
         EDIT and press enter and F8.

4.     Change the domain and Save the same

5.      Now go to rsa1 and activate the
         key figure.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply