Do you have any question about this error?
Stop googling SAP errors. Use our Free Essentials plan instead - no credit card needed. Start Now →
Message type: E = Error
Message class: SDDL_PARSER_MSG - Message Class for DDL Parser
Message number: 020
Message text: Selection list must not consist solely of $$EXTENSION
Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.
To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.
Unfortunately, there isn't any extra information in this error notice.
First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).
Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.
You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.
SDDL_PARSER_MSG020
- Selection list must not consist solely of $$EXTENSION ?The SAP error message SDDL_PARSER_MSG020 indicates that there is an issue with the selection list in a query or report where it consists solely of the placeholder
$$EXTENSION
. This typically occurs in the context of SAP's data selection or reporting tools, such as SAP Query or ABAP programs, where the selection criteria are not properly defined.Cause:
The error arises when the selection criteria for a report or query are not set up correctly. Specifically, it means that the selection list is empty or only contains the
$$EXTENSION
placeholder, which is not valid for executing a query or report. This can happen due to:
- Misconfiguration: The selection criteria were not properly defined in the query or report.
- Missing Data: The data source may not have any valid fields or values to select from.
- Incorrect Use of Placeholders: The use of
$$EXTENSION
without any actual fields or values to extend.Solution:
To resolve this error, you can take the following steps:
Check Selection Criteria:
- Open the query or report definition in the SAP Query or ABAP program.
- Ensure that the selection criteria are properly defined and include valid fields and values.
Remove or Replace
$$EXTENSION
:
- If
$$EXTENSION
is present in the selection list, consider removing it or replacing it with actual fields that are relevant to your query.Add Valid Fields:
- Ensure that the selection list includes at least one valid field that can be used for filtering data. This could be a field from the database table that you are querying.
Test the Query:
- After making changes, test the query or report to ensure that it runs without errors.
Consult Documentation:
- If you are unsure about how to configure the selection criteria, refer to SAP documentation or help resources related to the specific module you are working with.
Related Information:
By following these steps, you should be able to resolve the SDDL_PARSER_MSG020 error and successfully execute your query or report.
Get instant SAP help. Sign up for our Free Essentials Plan.
SDDL_PARSER_MSG019
$$EXTENSION is not allowed within unions
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SDDL_PARSER_MSG018
Number of fields in selection lists in unions must be the same
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SDDL_PARSER_MSG021
Only field names are allowed in GROUP BY
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SDDL_PARSER_MSG022
obsolete: $$EXTENSION and GROUP BY are not valid together
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
Click on this link to search all SAP messages.