Runtime Errors : - DBIF_RSQL_INVALID_RSQL

[Former Member]

Hey fellas,

Runtime Errors         DBIF_RSQL_INVALID_RSQL

Except.                   CX_SY_OPEN_SQL_DB

Already checked the forum for this issue there are many discussions regarding this but unable to find this variant so posted it.

Getting this error for this query :

START-OF-SELECTION.

     SELECT PERNR SUBTY ENDDA BEGDA AEDTM UNAME WAERS BET01 FROM PA0008

*       SELECT * FROM PA0008

     INTO CORRESPONDING FIELDS OF TABLE IT_PA0008

*      INTO TABLE IT_PA0008

     UP TO 15 ROWS.

Tried with commented lines also but same result.

Type of IT_PA0008 is as :

TYPES : BEGIN OF TY_PA0008,

           PERNR TYPE PERNR,

           SUBTY TYPE SUBTY,

           ENDDA TYPE ENDDA,

           BEGDA TYPE BEGDA,

           AEDTM TYPE AEDAT,

           UNMAE TYPE AENAM,

           WAERS TYPE WAERS,

           BET01 TYPE PAD_AMT7S,

           END OF TY_PA0008.

plzz help..

[Former Member]

Hello Keta,

You must change the reference to the element data.

PERNR is a structure.

TYPES : BEGIN OF TY_PA0008,

           PERNR TYPE PERNR,

I hope you help.

[Private_Member_7726]

Hi,

Err... so... what is the actual SQL error message in the dump..?

cheers

Jānis

[pavanm592]

Hi Ketan,

Change the type of PERNR in your types

TYPES : BEGIN OF TY_PA0008,

            PERNR TYPE P0001-pernr,

            SUBTY TYPE SUBTY,

            ENDDA TYPE ENDDA,

            BEGDA TYPE BEGDA,

            AEDTM TYPE AEDAT,

            UNMAE TYPE AENAM,

            WAERS TYPE WAERS,

            BET01 TYPE PAD_AMT7S,

            END OF TY_PA0008.

This will work for you.

Regards,

Pavan

[Mohamed_Mukhtar]

Hello ,

Change pernr declaration in ty_pa0008.

PERNR TYPE PERSNO,

Thanks

[Former Member]

Hi Keta,

Change your types to this:

TYPES : BEGIN OF TY_PA0008,

           PERNR TYPE PA0008-PERNR,

           ....

regards,

Archer

[Former Member]

Thank you everyone...

Solved.. 🙂