How To Fix SDDL_PARSER_MSG486 - Selection list must be specified after FROM clause in view entities

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 486

• Message text: Selection list must be specified after FROM clause in view entities

What causes this issue?

In view entities, the selection list must be specified in curly brackets
after the FROM clause:
<EX>SELECT FROM <(><<)>datasource> { <(><<)>select_list> }</>
The syntax
<EX>SELECT <(><<)>select_list> FROM <(><<)>datasource></>
familiar from SQL is invalid.

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SDDL_PARSER_MSG486 - Selection list must be specified after FROM clause in view entities ?

  The SAP error message SDDL_PARSER_MSG486 indicates that there is an issue with the syntax of a query in a CDS (Core Data Services) view. Specifically, the error states that a selection list must be specified after the FROM clause in the view entities. This typically occurs when the CDS view is not properly defined, particularly in the way it selects fields from the underlying database tables or views.
  Cause
  The error is usually caused by one of the following issues:
  
  Missing Selection List: The CDS view does not specify which fields to select after the FROM clause.
  Incorrect Syntax: There may be a syntax error in the definition of the CDS view, such as missing commas, incorrect use of keywords, or other structural issues.
  Improperly Defined Associations: If the view is trying to use associations or joins without properly defining them, it can lead to this error.
  
  Solution
  To resolve the error, you can follow these steps:
  
  
  Check