Runtime Error: DBIF_RSQL_INVALID_RSQL

[Former Member]

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?

[Former Member]

Hi Anushka,

Can you plese share the declaration of IT_HEADER ?

Thanks,

bhaskar

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Thank you so very much!

[Former Member]

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