Table to find Basic Key figure in a BW Formula

[former_member288225]

Hi,

I am trying to find a way to identify the basic keyfigures used in a BW formula (query designer). Do we have any tables or programs to identify the same.

I have already checked the below tables but unable to find the exact information.

1. I take Enterprise id of the formula and give that as in input in field ELTUID of table RSZCALC.

2. Used the Formula operand taken from RSZCALC in the field ELTUID of table RSZRANGE. This gave me few key figures under the field LOW. But I am expecting more than 20 basic key figures as an output.

May be I need to use a different approach in tables but not sure. Kindly help.

Tables Checked:

RSZCALC
RSZRANGE
RSAFORM
RSAFORMT

Regards,

Sarfaraz

[former_member288225 · Accepted solution]

Hello All,

The above mentioned issue has been solved.

The KF's used in the formula can be found under the field "LOW" in the table RSZRANGE. This field provides information of both basic key figures as well as CKF's. The infoobject name would be directly shown in case of basic KF's and Element ID in case of CKF's.

Below are the steps:

1. Element ID of the BW formula from Query Designer.

2. Input the Element ID in table RSZCALC and get the Formula Operand value.

3. Input the Formula Operand value as input in table RSZRANGE.

4. The KF's can be found under the field "LOW".

Regards,
Sarfaraz