3780737 - Replication flow fails to fetch CDS view definition with "Error in getDisConnectionDetails. Getting dataset definition failed" due to missing authorization

• An error occurs when trying to fetch data using a replication flow for a CDS view via S/4HANA on-premise connection.
• Error message occurs: "Failed to fetch the data. Error in getDisConnectionDetails. Getting dataset definition failed for /CDS_EXTRACTION/...".
• Network trace details: code "getCsnDefinitionFailed" and cause entry in Response body:  message "No authorization for object - access denied".

SAP Datasphere

1. Create a new replication flow.
2. Select the S/4HANA on-premise source connection.
3. Choose the source container /CDS_EXTRACTION.
4. Add a <CDS view> as the source object.
5. Observe that zero objects are imported and one object fails to import.
6. Capture a network trace while reproducing the error by following SAP Note 3405253 - How to collect network trace using “Developers Tools”.
7. Observe the below error in the Response:

"code": "getCsnDefinitionFailed",
   ...
        "message": "Failed to fetch the data.  Error in getDisConnectionDetails. Getting dataset definition failed for /CDS_EXTRACTION/<CDS view>",
       ...
            "causes": [
                {
                    "code": "99999",
                    "message": "No authorization for object - access denied: <CDS view> => No authorization for reading definition <CDS view>",

Missing authorization in the ABAP source system for the remote user to read the CDS view definition, leading to access denied during CSN definition retrieval.

1. Check the ABAP source system for authorization errors when accessing the CDS view (use STAUTHTRACE, SU53 or SLG1).
   For reference: How to check STAUTHTRACE, SU53 and SLG1 in SAP ABAP Based Systems.
2. Review the complete security setup of the user in connection management as per SAP S/4HANA and Other ABAP Sources for Replication Flows | SAP Help Portal.
3. Implement the required ABAP integration security setup for the remote connection user, ensuring all roles/authorizations are correctly assigned. For reference see below SAP notes:
   • 3100673 - SAP Data Intelligence / SAP Datasphere - ABAP Integration - Security Settings
   • 3306011 - New security role SAP_DI_ABAP_REMOTE as part of TCI 7.56 - SAP Data Intelligence
4. Retry adding/importing the CDS view in the replication flow and confirm the object can be read and imported.
5. If the issue persists, capture a network trace using the "Developers Tools" while reproducing the error and provide it to SAP Support. Further details can be found in SAP Note 3405253.

• How to check STAUTHTRACE, SU53 and SLG1 in SAP ABAP Based Systems
• SAP Note 3405253 - How to collect network trace using “Developers Tools”
• SAP Note 2854764 - Guidelines for SAP Datasphere Cases

getDisConnectionDetails, getting dataset definition failed, no authorization for object, cds extraction, cds view, getcsndefinitionfailed, getdisconnectiondetails, authorization error, abap integration, remote source, import failed, "99999" , KBA , DS-DI-RF , Replication Flow Runtime , Problem