3757649 - Some Source Object Types not Visible via Remote Table When Using SAP S/4HANA On-Premise Connection in SAP Datasphere

• When using an SAP S/4HANA On-Premise connection in SAP Datasphere, certain data types are not visible or cannot be accessed via Remote Tables, even though the data exists in the source system.
• When validating the connection, the Remote Tables feature is shown as enabled.

• SAP Datasphere (Cloud)
• SAP S/4HANA On-Premise

1. Create an SAP S/4HANA On-Premise connection in SAP Datasphere.
2. Validate the connection, the Remote Tables feature is shown as enabled.
3. Go to 'Data Builder' to import remote table, select the connection.
4. The expected data is not visible.

The Data Provisioning Option selected in the SAP S/4HANA On-Premise connection configuration determines which data source types are accessible via Remote Tables. The two options support different data types:

If Cloud Connector is selected as the Data Provisioning Option, only CDS View Entities exposed via the ABAP SQL service are accessible. ODP sources and ABAP Dictionary tables are not available with this option.

If Data Provisioning Agent is selected, CDS View Entities via the ABAP SQL service are not accessible through this option. Instead, ODP sources (federation and replication) and ABAP Dictionary tables (federation and replication) become available.

Select the appropriate Data Provisioning Option based on the data you need to access:

• To access CDS View Entities via ABAP SQL Service (recommended for federation scenarios): Set Data Provisioning Option to Cloud Connector.
  
  Note: If Cloud Connector is used but CDS View Entities exposed via the ABAP SQL Service are still not visible, refer to KBA 3723407 for further troubleshooting steps.

• To access ODP sources or SAP ABAP Dictionary tables (federation and replication): Set Data Provisioning Option to Data Provisioning Agent, and ensure a Data Provisioning Agent is configured for your SAP Datasphere tenant.
  
  Note: These two options are mutually exclusive for Remote Tables. If you require both CDS view federation (via ABAP SQL service) and replication/ODP access, consider creating separate connections with different Data Provisioning Options.

• SAP S/4HANA On-Premise Connections (SAP Help Portal)
• Prepare Connectivity to SAP S/4HANA On-Premise

Datasphere, S/4HANA On-Premise, Remote Table, Data Provisioning Option, Cloud Connector, Data Provisioning Agent, ODP, ABAP Dictionary, CDS View, ABAP SQL Service, federation, replication, data not visible , KBA , DS-DI-CON , Connections , DS-DI-RT , Remote Tables , Problem