Ansicht
Dokumentation

ABAPOPEN_SQL_EXCEPTIONS - OPEN SQL EXCEPTIONS

TXBHW - Original Tax Base Amount in Local Currency   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Exceptions in Open SQL

Catchable Exceptions

CX_SY_OPEN_SQL_DB

• Cause: A general database error occurred.
  Runtime Error: DBIF_RSQL_SQL_ERROR
  
• Cause: A statement is too large.
  Runtime Error: DBIF_RSQL_INVALID_REQUEST
  
• Cause: A conversion error occurred.
  Runtime Error: DBIF_RSQL_INVALID_REQUEST
  
• Cause: The length restriction of a string was violated.
  Runtime Error: DBIF_RSQL_INVALID_REQUEST
  
• Cause: No resources available for further database connections.
  Runtime Error: DBIF_RSQL_INVALID_REQUEST
  
• Cause: You want to add a record but a record with the same key already exists in the database.
  Runtime Error: DBIF_RSQL_KEY_ALREADY_EXISTS
  
• Cause: The database cursor used is invalid.
  Runtime Error: DBIF_RSQL_INVALID_CURSOR
  

CX_SY_DYNAMIC_OSQL_SEMANTICS

• Cause: The database column whose values you want to aggregate does not have a numeric type.
  Runtime Error: SAPSQL_HAVING_AVG_TYPE
  
• Cause: The database column whose values you want to aggregate does not have a numeric type.
  Runtime Error: SAPSQL_HAVING_SUM_TYPE
  
• Cause: A search pattern is not specified in a text literal.
  Runtime Error: SAPSQL_LIKE_VAL_TYPE
  
• Cause: A token cannot be interpreted as a literal or variable name valid in the current context.
  Runtime Error: SAPSQL_WHERE_ILLEGAL_VALUE und SAPSQL_SET_ILLEGAL_VALUE
  
• Cause: A table name is too long.
  Runtime Error: SAPSQL_TABNAME_TO_LONG
  
• Runtime Error: A field name is too long.
  Runtime Error: SAPSQL_FIELDNAME_TOO_LONG
  
• Cause: A table with the name specified does not exist.
  Runtime Error: SAPSQL_INVALID_TABNAME
  
• Cause: A field name is not unique.
  Runtime Error: SAPSQL_AMBIGUOUS_FIELDNAME
  
• Cause: A column with the name specified does not exist.
  Runtime Error: SAPSQL_INVALID_FIELDNAME
  
• Cause: The table specified is not declared as a table or view in the ABAP Dictionary.
  Runtime Error: SAPSQL_NO_DBTAB_OR_VIEW
  
• Cause: You want to select the total of a non-numeric field.
  Runtime Error: SAPSQL_FIELDLIST_SUM_TYPE
  
• Cause: You want to select the average of a non-numeric field.
  Runtime Error: SAPSQL_FIELDLIST_AVG_TYPE
  
• Cause: You want to apply an aggregate function to a LOB column.
  Runtime Error: SAPSQL_AGGREGATE_LOB
  
• Cause: You want to sort data according to the values of a LOB column.
  Runtime Error: SAPSQL_ORDER_BY_LOB
  
• Cause: You want to apply the DISTINCT addition to a LOB column.
  Runtime Error: SAPSQL_DISTINCT_AND_LOB
  
• Cause: An alias is too long.
  Runtime Error: SAPSQL_ALIASNAME_TOO_LONG
  
• Cause: You want to group data acccording to the value of a LOB column.
  Runtime Error: SAPSQL_GROUP_BY_LOB
  
• Cause: You want to use a LOB column in a logical condition.
  Runtime Error: SAPSQL_BOUND_LONG_STRING
  
• Cause: A pattern specified for LIKE is too long.
  Runtime Error: SAPSQL_LIKE_PATTERN_TOO_LONG und SAPSQL_LIKE_PATTERN_TOO_LONG
  
• Cause: You want to select data from a non-transparent table using the addition DISTINCT.
  Runtime Error: SAPSQL_ILLEGAL_DISTINCT
  
• Cause: A field whose value you want to change with + or - has a non-numeric type.
  Runtime Error: SAPSQL_SET_PLUS_MINUS_TYPE
  
• Cause: On a pooled table, LIKE is used with the ESCAPE addition.
  Runtime Error: SAPSQL_ESCAPE_WITH_POOLTABLE
  
• Cause: You want to access a pooled or cluster table using a secondary database connection.
  Runtime Error: SAPSQL_CONNECTION_ILL_TABTYPECX_SY_DYNAMIC_OSQL_SYNTAX
  
• Cause: The keyword AND is missing after the lower comparison value of the operator BETWEEN.
  Runtime Error: SAPSQL_BETWEEN_MISSING_AND
  
• Cause: The parentheses of the logical condition are not correct.
  Runtime Error: SAPSQL_HAVING_PARENTHESES
  
• Cause: An unknown aggregate function was found.
  Runtime Error: SAPSQL_ILLEGAL_AGGREGATE
  
• Cause: The operator IS NULL is not followed by the keyword NULL.
  Runtime Error: SAPSQL_ILLEGAL_IS_NULL
  
• Cause: The parentheses are not correct for the operator IN.
  Runtime Error: SAPSQL_IN_ILLEGAL_LIST
  
• Cause: The logical condition contains a text literal in which the closing quotation mark is missing.
  Runtime Error: SAPSQL_LIKE_QUOTES
  
• Cause: The logical condition ends unexpectedly.
  Runtime Error: SAPSQL_WHERE_MISSING_CONDITION
  
• Cause: The Escape character is missing after the addition ESCAPE.
  Runtime Error: SAPSQL_WHERE_MISSING_ESCAPE
  
• Cause: An operator is missing in the logical condition.
  Runtime Error: SAPSQL_WHERE_MISSING_OPERATOR
  
• Cause: A literal or the name of an ABAP variable is missing in the logical condition.
  Runtime Error: SAPSQL_WHERE_MISSING_VALUE
  
• Cause: The parentheses of the logical condition are not correct.
  Runtime Error: SAPSQL_WHERE_PARENTHESES
  
• Cause: The logical condition contains a text literal in which the closing quotation mark is missing.
  Runtime Error: SAPSQL_WHERE_QUOTES
  
• Cause: An unknown operator is used in the logical condition.
  Runtime Error: SAPSQL_WHERE_UNKNOWN_OPERATOR
  
• Cause: An alias is missing.
  Runtime Error: SAPSQL_MISSING_ALIAS
  
• Cause: A column on the right side of a LEFT OUTER JOIN is used in a WHERE condition.
  Runtime Error: SAPSQL_ACCESS_TO_RHS_TABLE
  
  
  

The following exceptions can only occur for the statement UPDATE:

• Cause: You attempted to modify a database field with an operator other than + or -.
  Runtime Error: SAPSQL_SET_NOT_PLUS_MINUS
  
• Cause: An unknown operator is used in the SET statement.
  Runtime Error: SAPSQL_SET_UNKWNON_OPERATOR
  
• Cause: A literal or the name of an ABAP variable is missing in the SET statement.
  Runtime Error: SAPSQL_SET_MISSING_VALUE
  
• Cause: The SET statement contains a text literal in which the closing quotation mark is missing.
  Runtime Error: SAPSQL_SET_QUOTES
  

PERFORM Short Reference   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 11886 Date: 20240426 Time: 032922     sap01-206 ( 130 ms )