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, parameter2}
  
  Enclose in Curly Braces: Make sure that the parameter list is enclosed in curly braces {}.
  Validate the SDL: After making corrections, validate the SDL to ensure there are no further syntax errors.
  
  Example:
  If your SDL code looks like this:
  FUNCTION myFunction
  RETURNS
  You should modify it to:
  FUNCTION myFunction
  RETURNS {param1, param2}
  Related Information:
  
  Documentation: Refer to the SAP documentation for Security Definition Language (SDL) for detailed syntax rules and examples.
  SAP Notes: Check for any relevant SAP Notes that might address specific issues or provide additional guidance on SDL syntax.
  Testing: After making changes, test the SDL to ensure that it behaves as expected and that the error is resolved.
  
  If you continue to experience issues after making these changes, consider reaching out to your SAP support team or consulting with an SAP expert for further assistance.