Connection between RSZELTXREF and RERREPDIR

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