SAP BW: Product Hierarchy load from ERP - attach base members

[former_member517731]

Hi all,

We are using the embedded BW (version 7.52) within S/4HANA (1709) as part of a planning & consolidation development. In general master data & hierarchies in the embedded BW are virtually read from S/4 via HANA views provided by SAP. For the /ERP/MATERIAL object, there is no HANA view provided by SAP for the hierarchy, so we are using the standard BI content datasources / extractors to physically load the hierarchy from S/4 into BW. This works the same way as if it was a standard ERP -> BW load.

We have used datasource 0MATERIAL_LPRH_HIER to load the hierarchy from S/4 to /ERP/MATERIAL (similar to the 0MATERIAL object). This has loaded the hierarchy from levels 0PRODH1 to 0PRODH9 correctly, however the base level materials are not attached to the bottom level of the hierarchy. See example screenshot below.

Is there another datasource / extractor that can be used to load the last level of the hierarchy, assigning base level members to their immediate parents? If not, how should this requirement be met?

Thanks,

Hugh Gledhill

[former_member517731 · Accepted solution]

Update: we did eventually solve this issue by writing a routine in the hierarchy load process. Essentially the extractor expects the object to be called "0MATERIAL" as opposed to "/ERP/MATERIAL", so that needed a small piece of custom logic to address.