Symptom
On SAP Datasphere, the "Replication Flow to Local Table" method for semantic onboarding using "Import Entities" from S/4HANA On-premise system for a CDS view entity, fails with following error:
Error while deploying data layer objects messages: Review the following errors: CSN Compilation failed with following messages: Errors(ORIGINAL): (in entity:“Remote.ABC_Model_Import.entity#2”/select/mixin:“_CorrespondingSupplier”/on) Can't follow unmanaged association “_CorrespondingSupplier” in path “$projection._CorrespondingSupplier.Supplier” in an ON-condition Errors(FORMATTED): (in entity:“Remote.ABC_Model_Import.entity#2”/select/mixin:“_CorrespondingSupplier”/on) Can't follow unmanaged association “_CorrespondingSupplier” in path “$projection._CorrespondingSupplier.Supplier” in an ON-condition
Following notes are already present on the S/4HANA On-premise source system:
- 3312236: DWC Import Manager: Error when importing CDS entities due to incorrect ON CONDITIONS in CSN document
- 3081998 - Metadata import of CSN entities from SAP S/4HANA, on-premise edition to SAP Datasphere Cloud - central initial note
- 3463326 - SAP Datasphere: Metadata Import from SAP S/4HANA On-Premise via "CSN Exposure" Service - New Deployment Option "Replication Flow to Local Table"
Environment
SAP Datasphere
Cause
Metadata import of large entities of type "Cubes" is not excluded (and incorrectly allowed) in the S/4HANA On-Premise Import Scenario.
Resolution
To address this issue, check SAP Note 3512195 - SAP Dataspere Metadata Import from S/4HANA On-Premise: Restrict the Metadata Import of Cubes.
See Also
SAP KBA 3512305 - The entity import with Data Access Option "Replication Flow to Local Table" is failing with "Can't follow unmanaged association" - SAP Datasphere.
Keywords
import entities, semantic onboarding, CDS, entities, import, metadata import, ON-condition, associations , KBA , DS-MD-ESH , Repository Explorer , Problem