SAP Knowledge Base Article - Preview

2669135 - Using class cl_shdb_seltab method combine_seltabs

Symptom

You are using the ABAP class 'cl_shdb_seltab' for converting selection tables into SQL WHERE clause.

When you execute your program, it fails with a short dump like the following:

Category               ABAP programming error
Runtime Errors         SAPSQL_PARSE_ERROR
Except.                CX_SY_DYNAMIC_OSQL_SYNTAX
ABAP Program           XXXXXX
Application Component  Not assigned
Short Text
An error has occurred while parsing a dynamic entry.
Error analysis
An exception has occurred which is explained in more detail below. The
exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SYNTAX' was not
caught and therefore caused a runtime error. The reason for the exception is:
The current ABAP program attempted to execute an Open SQL statement
containing a dynamic entry. The parser returned the following error:
     ""AND" is not valid here."

The part of the code which fails is similar to the following:

24 DATA(lv_where) = cl_shdb_seltab=>combine_seltabs(
25                  it_named_seltabs = VALUE #(
26                 ( name = 'VBELN' dref = REF #( vbeln[] ) )
27                 ( name = 'AUART' dref = REF #( auart[] ) ) ) ).
28
>>>>>          select single * from vbak into wa_vbak
30                  where (lv_where).


Read more...

Environment

  • SAP Systems based on SAP NetWeaver;
  • SAP HANA Database;

Product

SAP HANA, platform edition all versions ; SAP NetWeaver all versions

Keywords

AMDP, SELTAB, ABAP, SQL-WHERE, CX_SY_DYNAMIC_OSQL_SYNTAX, DUMP, SAPSQL_PARSE_ERROR , KBA , BC-DB-HDB-POR , Dictionary & Consistency checks for SAP HANA , HAN-DB , SAP HANA Database , BC-ABA , ABAP Runtime Environment - ABAP Language Issues Only , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.