3538304 - Error " Missing Authorization for Service S_PRIVILEGED" when validate S/4HANA Cloud connection in Datasphere

The connection type is SAP S/4HANA Cloud. When validating connection, the error occurs:

----------------------------------------------------------------------------------

Connection "S4HANA_CLOUD" is valid, but not all features are available.
- Data flows are enabled.
- Replication flows are enabled.
- Remote tables can’t be used because of errors in the connection.
- Model Import is disabled.

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: Missing Authorization for Service S_PRIVILEGED., Code: 5921, SQL State: HY000
----------------------------------------------------------------------------------

SAP Datasphere

Lack of appropriate authority.

Please follow Using ABAP SQL Services for Accessing Data from SAP S/4HANA Cloud | SAP Help Portal. Especially Data Federation With Remote Tables.

=== Quote ===

• To expose the SQL service to get privileged access to the CDS view entities with a communication user, a communication arrangement is required. This involves the following steps:

  1. An SAP S/4HANA Cloud business user has created a custom communication scenario in the ABAP Development Tools.

     When filling out the authorizations for authorization object S_SQL_VIEW in the communication scenario, note the following:

     • On the Sources tab of the Data Builder view editors in SAP Datasphere, the service binding name from the SQL_SCHEMA authorization field is visible as (virtual) schema.

     • In the SQL_VIEWOP authorization field, select the option SELECT to grant federated access.

  2. An administrator has created a communication system and user in the SAP Fiori launchpad of the ABAP environment.

     Note

     The same communication user must be added to all communication arrangements you're using for the connection.

  3. An administrator has created a communication arrangement for exposing the SQL service in the SAP Fiori launchpad of the ABAP environment.

  For more information, see Exposing the SQL Service for Data Federation and Replication with Privileged Access in the ABAP Cloud documentation.

=== End Quote ===

SAP Datasphere, SAP S/4HANA Cloud, Integration, Connection, S_PRIVILEGED

DWC, DS, S4HC, HC , KBA , DS-DI-CON , Connections , Problem