Symptom
When creating a new Data Flow in Datasphere, upon opening the Source tab and expanding the S/4 HANA Connection, the CDS view is not displayed in the list.
The same issue exists when using an ABAP connection or when using Replication Flow.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Datasphere
Reproducing the Issue
- Create a new Data Flow in Data Builder.
- Open Source tab.
- Expand the S/4 HANA Connection.
- Some CDS Views are displayed, but the expected one cannot be found.
Cause
- The release status of the CDS View is not correct.
- The CDS View needs to be manually loaded into Datasphere.
Resolution
- The CDS view must be enabled for data extraction from SAP S/4HANA, CDS View I_DataExtractionEnabledView lists all of them.
- Run transaction code SE11.
- Select "View" radio button.
- Input the SQL name of CDS View I_DataExtractionEnabledView - "IXTRCTNENBLDVW".
- Click Display button. Click Contents button.Execute and check the result.
- If the CDS view cannot be found in I_DataExtractionEnabledView, check whether it has annotation @Analytics.dataextraction.enabled, and whether it is C1-released.
- If the CDS view can be found in I_DataExtractionEnabledView but it is still not displayed in Data Flow, it needs to be manually loaded into Datasphere, because Data Flow will only show the first 100 entries.
- To browse all available objects, click "Import from Connection" to open the Import Objects from Connection dialog.
- Expand "CDS_EXTRACTION", 150 objects will be displayed.
- Input CDS view's name and search.
Note: Only first 1000 entries can be displayed in the search result. - Select the expected CDS views and click the Next button. Then click "Add Selection" to finish the import.
- To browse all available objects, click "Import from Connection" to open the Import Objects from Connection dialog.
See Also
- CDS Views Enabled for Data Extraction:
https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/b7a5b8b72d3643b7a8ecf4cd695e0791.html - API State: Use System-Internally (C1):
https://help.sap.com/docs/abap-cloud/abap-development-tools-user-guide/use-system-internally-c1?version=sap_btp - Import Multiple Objects from a Connection:
https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/e720b1383b154bd6b0aac64baf52a10b.html - KBA 3332381 - Search in "Import Remote Tables" wizard
- SAP Note 3316806 Import of Remote Table from a connection (remote source) fails because of high number of remote objects or remote database schemas
Keywords
search CDS view, Data Flow's limitation, Replication Flow's limitation, cannot find CDS views, import CDS views , KBA , DS-DI-DF , Data Flows , CA-DI-IS-ABA , ABAP Integration , DS-DI-RF , Replication Flows , Problem
Product
SAP Datasphere all versions
Attachments
Pasted image.png |