Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member
0 Kudos
204

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 "FETCH_DATA" "(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:

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

SELECT bdzei into CORRESPONDING FIELDS OF TABLE it_bdzei

     from pbed

     where PDATU in so_date.

     SORT it_bdzei ASCENDING.

     delete ADJACENT DUPLICATES FROM it_bdzei COMPARING bdzei.

>>>>  SELECT matnr werks INTO CORRESPONDING FIELDS OF TABLE it_header      "gives dump

          FROM pbim

*         PACKAGE SIZE 1000

          FOR ALL ENTRIES IN it_bdzei

          WHERE bdzei = it_bdzei-bdzei and

           werks in so_werks and

           versb eq p_vers.

Can anyone pls give any suggestions so i can fix this problem?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
81

Hi Anushka,

Can you plese share the declaration of IT_HEADER ?

Thanks,

bhaskar

5 REPLIES 5

Former Member
0 Kudos
82

Hi Anushka,

Can you plese share the declaration of IT_HEADER ?

Thanks,

bhaskar

0 Kudos
81

Hiii Bhaskar,

TYPES: BEGIN OF ty_header,

        matnr TYPE matnr,

        plnmg TYPE plnmg,

        werks TYPE werks,

        END OF ty_header.

data: it_header TYPE STANDARD TABLE OF ty_header,

       wa_header LIKE LINE OF it_header.

0 Kudos
81

Hi,

It is very simple check your declarations, you have refereed the plant in a wrong way

TYPES: BEGIN OF ty_header,

        matnr TYPE matnr,

        plnmg TYPE plnmg,

        werks TYPE werks_d,

        END OF ty_header.

It should work.!

Kiran

0 Kudos
81

OMG Kiran, you are so correct! Cant believe i didnt notice

Thank you so very much!

0 Kudos
81

Cool, it's human error, some times Happen!!!!