How To Fix APS_CKE_PARSER081 - Data source &1 is an External API and cannot be used in custom CDS views

SAP Error Message - Details

• Message type: E = Error

• Message class: APS_CKE_PARSER - CDS Key user tool - AST handler messages

• Message number: 081

• Message text: Data source &1 is an External API and cannot be used in custom CDS views

What causes this issue?

If data sources and included elements have been exposed in an external
API scenario, they can't be used as primary data sources for a custom
CDS View.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Select a different data source which has not been exposed as OData API.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message APS_CKE_PARSER081 - Data source &1 is an External API and cannot be used in custom CDS views ?

  The SAP error message APS_CKE_PARSER081 indicates that you are trying to use a data source that is classified as an "External API" in a custom Core Data Services (CDS) view. This is not allowed because CDS views are designed to work with database tables or views, and external APIs do not fit into this category.
  Cause:
  The error occurs when:
  
  You attempt to include an external API data source in a custom CDS view.
  The external API is not compatible with the CDS view framework, which expects data sources to be database tables or views.
  
  Solution:
  To resolve this issue, consider the following approaches:
  
  
  Use a Different Data Source: 
  
  If possible, replace the external API data source with a standard database table or view that contains the required data.
  
  
  
  Create a Wrapper:
  
  If you need to use data from the external API, consider creating a wrapper or a custom ABAP program that fetches the data from the API and stores it in a database table. You can then use this table in your CDS view.
  
  
  
  Use ABAP Managed Database Procedures (AMDP):
  
  If your scenario allows, you can use AMDP to call the external API and process the data. However, this approach may require additional coding and is not as straightforward as using a standard database table.
  
  
  
  Check for Alternative Data Sources:
  
  Sometimes, the data you need might be available through other standard data sources or views that are compatible with CDS views. Explore the available options in your SAP system.
  
  
  
  Consult Documentation:
  
  Review the SAP documentation for any updates or changes regarding the use of external APIs and CDS views. There may be new features or best practices that can help you.
  
  
  
  Related Information:
  
  CDS Views: Core Data Services (CDS) is a framework for defining semantically rich data models in SAP. CDS views are typically used for reporting and analytics.
  External APIs: These are interfaces that allow different software applications to communicate with each other over the internet. In SAP, external APIs can be used to fetch data from external systems.
  SAP Notes and Community: Check SAP Notes for any specific fixes or recommendations related to this error. The SAP Community forums can also be a valuable resource for finding solutions and discussing similar issues with other SAP users.
  
  By following these steps, you should be able to address the APS_CKE_PARSER081 error and successfully create your CDS view.