How To Fix 28110 - Keyword RESTRICTION: expected


28110 - Overview

  • Message type: E = Error

  • Message class: 28 - Configuration

  • Message number: 110

  • Message text: Keyword RESTRICTION: expected

  • Show details Hide details
  • What causes this issue?

    The syntax check could not identify the mandatory restriction part of a
    constraint. This may be because the keyword <ZH>RESTRICTIONS:</> was
    not found, or was not recognized because it was in the wrong place.

    System Response

    In a constraint, the sections OBJECTS: and RESTRICTIONS: are mandatory.
    As soon as you enter a keyword that cannot be interpreted or an
    incorrect punctuation mark ('.', ';', ',', ':', and so on) after an
    object, the system tells you that it expects the RESTRICTIONS: section.
    The cursor shows where the error in your entry occurs.

    How to fix this error?

    Check your entries:
    You may have entered an incorrect keyword under OBJECTS: or CONDITION:
    that leads the system to assume that you want to make entries for
    RESTRICTIONS:. Check the syntax and spelling of the keywords in these
    sections.
    If the keyword RESTRICTIONS: is missing or written incorrectly, correct
    the error.
    If the keyword is there, perhaps it could not be interpreted correctly.
    This could be, for example, because the preceding expression was not
    closed correctly. A section is closed either with or without a period.
    Several object declarations are separated by commas. Several
    characteristic declarations are separated by semicolons.
    If you enter several expressions under CONDITION: or RESTRICTIONS:,
    separate them with commas.

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message 28110 - Keyword RESTRICTION: expected ?
    The SAP error message 28110 with the keyword "RESTRICTION: expected" typically occurs in the context of SAP ABAP programming or when working with database queries. This error indicates that the system expected a restriction (or condition) to be specified in a query or selection statement, but it was not provided.
    
    Cause: Missing Restriction: The most common cause is that a query or selection statement is missing a WHERE clause or a condition that restricts the data being retrieved. Syntax Error: There may be a syntax error in the ABAP code or SQL statement that leads to the system not recognizing the expected restriction. Incorrect Use of Keywords: The use of certain keywords in the query may not align with the expected syntax, leading to confusion in the query parser.
    Solution: Check the Query: Review the SQL query or ABAP code where the error occurs. Ensure that all necessary restrictions (WHERE clauses) are included. Correct Syntax: Make sure

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant