3512305 - The entity import with Data Access Option "Replication Flow to Local Table" is failing with "Can't follow unmanaged association" - SAP Datasphere

• When importing the entity with Data Access: "Replication Flow to Local Table" from S/4HANA on-premise, it is failing with the following error:
  
  CSN Compilation failed with following messages: 
  
  Errors(ORIGINAL):
  (in entity:“Remote.<connection name>.<entity name>”/select/mixin:“<association name>”/on) Can't follow unmanaged association “<association name>”
  in path “$projection.<association name>.<>” in an ON-condition
  
  
• This error is NOT occurring in case Data Access: "Remote tables" is selected. 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Datasphere

From Semantic Onboarding, the Repository Explorer or the Data Builder:

1. Click-> Import-> Import Entities
2. Select connection type: SAP S/4HANA On-Premise
3. Select Target Space
4. Select Connection
5. Select Entities
6. Review Entities
7. Start Import and Deploy
8. Check the notifications for the status of the import or Deployment Monitor

• An association is defined as "Target-to-Source" instead of "Source-to-Target" in the CSN join conditions on backend side.
• Check the view definition of the entity shown in the error message from the source system using tcode: SE11 or /nSE11 or SDDLAR or /nSDDLAR
  then it can be confirmed the association caused the error is defined as backwards, differently from others.

Example:
=====
define view I_Customer
  as select from kna1
  association [1..1] to I_CustomerToBusinessPartner   as _CustomerToBusinessPartner    on  $projection.Customer = _CustomerToBusinessPartner.Customer
  association [0..1] to I_Supplier                               as _CorrespondingSupplier            on  _CorrespondingSupplier.Supplier = $projection.Supplier
  association [0..*] to I_CustomerAccountGroupText   as _CustomerAccountGroupText     on  $projection.CustomerAccountGroup = _CustomerAccountGroupText.CustomerAccountGroup
  association [0..1] to I_CustomerClassification          as _CustomerClassification             on  $projection.CustomerClassification = _CustomerClassification.CustomerClassification
  association [0..*] to I_CustomerClassificationText    as _CustomerClassificationText       on  $projection.CustomerClassification = _CustomerClassificationText.CustomerClassification
=====

• Fix is planned to be available via the next SAP Datasphere wave (Wave 2024.19). 
  Please see SAP Note 2984828 regarding the planned availability of the fix.
  
  
• It is always recommended to import small, self-contained entities separately first - before importing the larger entities with the references to the smaller ones. 
• Currently it is possible to select entities with modeling pattern Cube for import. Note: this is against our recommendation.  
• It is not recommended to import Cubes because they bring too many dependencies.
• Deployment always checks everything and one undeployable entity in the scope causes the whole deployment to fail.
  If import of Cubes causes too many failures, it might be that we have to exclude Cubes from the import in future
  (as it is the case in the S/4HANA Cloud scenario). 

• 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"
• 2984828 - SAP Datasphere Release & Delivery Schedule

Replication Flow to Local Tables,  CSN Compilation failed with following messages, /select/mixin, Can't follow unmanaged association, import the entity, entity import , KBA , DS-MD-ESH , Repository Explorer , Problem