Not able to create provisional Hierarchy using Remote Hierarchy Class in S4 HANA

[Former Member]

Hello Experts,

I am trying create a provisional Hierarchy similar to creating a provisional Master data for planning purpose using Calculation views.

To start with we are using BPC Optimized on S/4 Hana, S/4 Version 1511 & BW version 7.5 SP 05

We are trying display 2 hierarchies of two individual Info-objects into one Info-object using a Calculation View, a Remote Hierarchy class that consists of an AMDP method.

Calculation View: Consists of union of 2 H tables having structure of output as :-

Hierarchy Class: has an AMDP method which has Select query to fetch data from the above Calculation View.

When i try to use the said Info-object in a BEX query and try to activate the Hierarchy Display it gives me a dump of ITAB_DUPLICATE_KEY

But when I try to only display one Hierarchy of its own, the AMDP method executes properly and it displays too.

So my assumption was that since I am using two Hierarchy ID to display in one info-object which as per the rule is not correct since BEX will not support, hence I am getting this dump.

But then I gave a try of displaying Hierarchy of second info-object into the first one which is also not working and after debugging it, I got some of the exception such as :-

“cannot use duplicate user-defined type name: Z_SAMPLE_HIER2=>M_AMDP_HIER2=>P00000#ttyp: line 2 col 3 (at pos 15): line 2 col 3 (at pos 15)”

Has anyone tried this scenario before and if someone can give some insight on how to proceed with this.

Thanks in advance