Symptom
DataSources activated in the source SAP ECC/ERP system are not available in SAP Datasphere for Replication Flow or Data Flow creation.
Environment
SAP Datasphere
Reproducing the Issue
Create a replication flow or data flow in Datasphere.
Cause
Certain HR-related DataSources based on the ODP SAPI framework require an explicit entry in table ROOSATTR on the source system before they can be exposed via ODP replication. Without this entry, the DataSources are active in RSA6 but are not published for consumption by SAP Datasphere.
Resolution
- Add the required DataSources to table ROOSATTR. Some DataSources are not released for ODP replication by default. To release them, an explicit entry must be added to table ROOSATTR on the SAP ECC source system.
Refer to the Excel file attached to SAP Note 2232584 - Release of SAP extractors for ODP replication (ODP SAPI) for the complete list of DataSources that require manual entries. After adding the entries, the DataSources will be visible in SAP Datasphere for Replication Flow and Data Flow creation. - Verify user authorizations for HR data extraction. Ensure the technical user configured in the SAP Datasphere connection has the required authorizations to extract HR data, as described in SAP Note 397208 - BW: Authorizations for extraction of HR data.
See Also
Keywords
KBA , DS-DI-RF , Replication Flow Runtime , Problem
Product
SAP Datasphere all versions
SAP Knowledge Base Article - Public