cancel
Showing results for 
Search instead for 
Did you mean: 

Connection between RSZELTXREF and RERREPDIR

Former Member
0 Kudos
1,131

Hi BW Experts,

we want to identify all of our 3.5 Querys which uses Calculated Key Figures. And for the identified CKFs we want to see which one uses the calculation before or after Aggregation option/flag.

The background for this is, that we want to migrate our 3.5 Querys towards 7.x. To avoid display problems with the changed aggrationmode in 7.x we want to identify these querys in beforehand.

This is what I could achieve so far:

- Buid up a APD which joins the neccessary RSZ* Tables. (please see screenshot attached)

Join conditions:

Join:

RSZCALC-ELTUID = RSZELTDIR-ELTUID

Used fields:

RSZCALC-CALLATE (Aggregation Mode) -> X or NULL

RSZELTDIR- DEFTP -> CKF (Calculated Keyfigure)

--> Works!

Join:

RSZELTDIR-ELTUID = RSZELTXREF-TELTUID

Used Fields:

RSZELTXREF-SELTUID -> link towards RSRREPDIR?

--> Works!

Join:

RSZELTXREF-SELTUID = RSRREPDIR-COMPUID

Used Fields:

RSRREPDIR-GENUID

RSRREPDIR-INFOCUBE

...

--> Here the Join fails an does not deliver any data.

Do I missed here something? Or is there some more mapping Table between RSZELTXREF and RSRREPDIR?

Help would be highly appreciated.

Best regards

Christian

Accepted Solutions (1)

Accepted Solutions (1)

former_member185132
Active Contributor
0 Kudos

Join:

RSZELTXREF-SELTUID = RSRREPDIR-COMPUID

This will not always work. RSZELTXREF is a parent-child relation table, which basically stores the tree-like structure of query elements.

In case of a simple local formula, the RSZELTXREF contains one record with TELTUID = formula and SELTUID = KF_structure, because the KF structure is the formula's parent. Then there will be another record with TELTUID = KF_structure and SELTUID = query.

In case of a CKF, when it gets added to a query what actually happens is that the CKF comes under a local selection, which is in turn a child of the KF structure, which is in turn the child of the query element. So just finding a record with TELTUID = CKF and taking the SELTUID of that record will not really be a robust solution.

The above example is out of my memory; in reality there could be many levels of parent-childs in a query and the query may not always be the CKF's direct parent. I think your requirement is solvable only if you write some ABAP code to recursively walk through the XREF table to figure out the query.

Former Member
0 Kudos

Hi Suhas,

thanks for your reply. I already thought that it might not that easy to get it done...

Thanks for the clarification.

Best regards

Christian

Answers (2)

Answers (2)

former_member213275
Contributor
0 Kudos

Hi,

Fetch varuniid from table RSZGLOBV and then fetch seltuid from table "RSZELTXREF" where

TELTUID =  RSZGLOBV-VARUNIID and then fetch compid FROM RSRREPDIR where COMPUID =

RSZGLOBV-VARUNIID.

Srikanth.

Former Member
0 Kudos

Hi Srikanth,

I´ve tried your approach.

The Link between:

RSZELTXREF-TELTUID =  RSZGLOBV-VARUNIID

--> Works

But Link between:

RSZGLOBV-VARUNIID = RSRREPDIR-COMPUID

--> Unfortunately does not work

Also I don´t need variable informations. Just the Calculation Time before or after Aggregation:

RSZCALC-CALLATE

This information for each CKF in our Query would be helpfull.

Best regards

Christian

former_member182470
Active Contributor
0 Kudos

Hi Christina,

This will definitely help you.

http://scn.sap.com/thread/422821

former_member182470
Active Contributor
0 Kudos

I think the fields which you have used are not the right fields.

Try to display the data from both the tables and compare the data for the selected fields. You have to ensure the same nature of data is coming in both fields from both the tables.

Why don't you create simple views instead of APDs?

Former Member
0 Kudos

Hi Suman,

thanks for your reply.

Can you explain in detail what field you would use instead?

Im using APD because its easy to use and for extracting data in CSV.

best regards

Christian

former_member182470
Active Contributor
0 Kudos

I am not in front of my PC to check and tell you. Please follow my suggestion to identify the right fields.

This may help you :  http://scn.sap.com/thread/1725644