How To Fix SADL_GW_DT_CDS054 - CDS views cannot be analytical and transactional at the same time.

SADL_GW_DT_CDS054 - Overview

• Message type: E = Error

• Message class: SADL_GW_DT_CDS - Messages CDS Checks

• Message number: 054

• Message text: CDS views cannot be analytical and transactional at the same time.

What causes this issue?

The CDS view is marked as transactional and Analytics.query.
Example:
@Analytics.query: true
@ObjectModel.transactionalProcessingEnabled: true

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

or
@Analytics.query: true
@ObjectModel.transactionalProcessingDelegated: true
This combination is not allowed in CDS views.

System Response

How to fix this error?

Use only one of the annotations.

Procedure for System Administrators

Contact the corresponding developer of the CDS view to correct the
error.

Error message extract from SAP system. Copyright SAP SE.

SADL_GW_DT_CDS054 - Details

• The SAP error message SADL_GW_DT_CDS054 indicates that a Core Data Services (CDS) view is being defined in a way that it cannot be both analytical and transactional at the same time. This is a common issue when working with CDS views in SAP, particularly when trying to create a view that serves multiple purposes.
  
  Cause:
  The error arises because:
  
  CDS View Type Conflict: A CDS view can either be defined as an analytical view (used for reporting and analytics) or as a transactional view (used for data manipulation and transactional operations). Attempting to combine both functionalities in a single CDS view leads to this error.
  Annotations: The annotations used in the CDS view definition may indicate that the view is intended for both analytical and transactional purposes, which is not allowed.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Separate Views: Create two separate CDS views:
  
  One for analytical purposes (using appropriate annotations like @Analytics.dataCategory: