DBIF_RSQL_INVALID_RSQL (FAE AND IN cause this error)

What can you do?

    Note down which actions and inputs caused the error.

 

    To process the problem further, contact you SAP system

    administrator.

 

    Using Transaction ST22 for ABAP Dump Analysis, you can look

    at and manage termination messages, and you can also

    keep them for a long time.

    Note which actions and input led to the error.

 

    For further help in handling the problem, contact your SAP a

    .

 

    You can use the ABAP dump analysis transaction ST22 to view

    termination messages, in particular for long term reference.

 

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "GET_EKPO" "(FORM)", nor was it propagated by a RAISING clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    The SQL statement generated from the SAP Open SQL statement violates a

    restriction imposed by the underlying database system of the ABAP

    system.

 

    Possible error causes:

     o The maximum size of an SQL statement was exceeded.

     o The statement contains too many input variables.

     o The input data requires more space than is available.

     o ...

 

    You can generally find details in the system log (SM21) and in the

    developer trace of the relevant work process (ST11).

    In the case of an error, current restrictions are frequently displayed

    in the developer trace.

 

 

How to correct the error

    The SAP Open SQL statement concerned must be divided into several

    smaller units.

    If the problem occurred due to the use of an excessively large table

    in an IN itab construct, you can use FOR ALL ENTRIES instead.

    When you use this addition, the statement is split into smaller units

    according to the restrictions of the database system used.

 

 

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

 

    "DBIF_RSQL_INVALID_RSQL" "CX_SY_OPEN_SQL_DB"

    "ZRFI122" or "ZRFI122"

    "GET_EKPO"

 

 

 

    The exception must either be prevented, caught within proedure

    "GET_EKPO" "(FORM)", or its possible occurrence must be declared in the

    RAISING clause of the procedure.

    To prevent the exception, note the following:

 

S_xblnr   has  more than 300 records

S_so        has 1121 records

 

 

Why this clause happen error? I think  the data of FAE and IN  is  summed , then exceed the maximal records.

FORM  GET_EKPO .
   sort it_bkpf by  xblnr.
   loop at  it_bkpf.
     s_xblnr- sign = 'I' .
     s_xblnr-option =  'EQ' .
     s_xblnr-low = it_bkpf-xblnr.
      collect  s_xblnr.
   endloop .
   if s_xblnr[] is not initial .
     select ebeln matnr from  ekpo into table  it_ekpo
       for all entries in  s_xblnr
       where  ebeln = s_xblnr-low
        and matnr in  s_so
        and bukrs = '6010'.
     sort it_ekpo by  ebeln matnr.
     delete adjacent duplicates from  it_ekpo.
   endif .


   sort it_bkpf2 by  xblnr.
   clear  s_xblnr[].
   loop at  it_bkpf2.     
     s_xblnr- sign = 'I' .
     s_xblnr-option =  'EQ' .
     s_xblnr-low = it_bkpf2-xblnr.
      collect  s_xblnr.
   endloop .
   if s_xblnr[] is not initial .
     select ebeln matnr from  ekpo into table  it_ekpo2
       for all entries in  s_xblnr
       where  ebeln = s_xblnr-low
        and matnr in  s_so
        and bukrs = '6010' .
     sort it_ekpo2 by  ebeln matnr.
     delete adjacent duplicates from  it_ekpo2.
   endif .
   clear : s_xblnr[], s_belnr[].

ENDFORM.                    " GET_EKPO

 

I think  the data of “FAE and IN”  can’t be used together when the condition record exceed the maximal records permitted by database .

S_xblnr   has  more than 300 records

S_so        has 1121 records