Customizing the Domain for Key Figures

[Former Member]

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.

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.

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.

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

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

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

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

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.