How To Fix SDDL_PARSER_MSG107 - RETURNS must be followed by a parameter list in '{}'

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 107

• Message text: RETURNS must be followed by a parameter list in '{}'

What causes this issue?

The return value of a table function is a list of return parameters that
are enclosed within curly brackets '<ZH> { } </>':
<EX> [<(><<)>Annotation_1>] <(><<)>r_par_1>:<(><<)>Namespace_1>.<(>
<<)>Typ_1> [<(><<)>Post_Annotation_1>];
...
[<(><<)>Annotation_n>] <(><<)>r_par_n>:<(><<)>Namespace_n>.<(><<)>Typ_n>
[<(><<)>Post_Annotation_n>]; </>
Each parameter specification must be closed with ';' (
<DS:ABEN.CDS_F1_DEFINE_TABLE_FUNCTION>CDS Table Functions</>)

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SDDL_PARSER_MSG107 - RETURNS must be followed by a parameter list in '{}' ?

  The SAP error message SDDL_PARSER_MSG107 indicates that there is a syntax issue in the Security Definition Language (SDL) used in your SAP system. Specifically, the error message states that the RETURNS keyword must be followed by a parameter list enclosed in curly braces {}. This typically occurs when defining a function or method in the context of security policies or roles.
  
  Cause:
  The error is caused by an incorrect syntax in the SDL where the RETURNS clause is not properly formatted. This can happen if:
  
  The RETURNS clause is missing the required parameter list.
  The parameter list is not enclosed in curly braces {}.
  There are typographical errors or misplaced characters in the SDL code.
  
  
  Solution:
  To resolve this error, you should:
  
  Check the SDL Syntax: Review the SDL code where the RETURNS clause is used. Ensure that it is correctly formatted.
  Add Parameter List: If the RETURNS clause is missing a parameter list, add it. For example:RETURNS {parameter1,