topic Re: RSQL error 23 in Application Development and Automation Discussions

RSQL error 23

Former Member — Thu, 03 Sep 2009 13:41:20 GMT

Dear Friends,

I am getting this error while i am accessing EKPO table. RSQL error 23 when accessing table EKPO, while I am performing interactive reports. Please help me.

Thank you

Re: RSQL error 23

Former Member — Thu, 03 Sep 2009 13:59:24 GMT

Hi,

Are you getting this dump on a select query? If so check the attributes of the internal table fields are compatible with that of the fields of table EKPO.

Regards,

Vikranth

Re: RSQL error 23

Kanagaraja_L — Thu, 03 Sep 2009 14:00:47 GMT

Check you WHERE condition in SQL statement.

Can you paste the piece fo SQL code ?

Kanagaraja L

Re: RSQL error 23

Former Member — Thu, 03 Sep 2009 16:14:12 GMT

Moderator message - Please respect the 2,500 character maximum when posting. Post only the relevant portions of code

Edited by: Rob Burbank on Sep 3, 2009 1:47 PM

Re: RSQL error 23

Former Member — Fri, 04 Sep 2009 13:04:55 GMT


> Check you WHERE condition in SQL statement.
> 
> Can you paste the piece fo SQL code ?
> 
> Kanagaraja L

CLEAR V_FNAM.
      GET CURSOR FIELD V_FNAM VALUE V_FVAL_EBELN.
      IF V_FNAM = 'WA_EKKO-EBELN'.
*** CONVERTING FROM EXTERNAL TO INTERNAL FORMAT
        CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
          EXPORTING
            INPUT  = V_FVAL_EBELN
          IMPORTING
            OUTPUT = V_FVAL_EBELN.


*** DISPLAY LINE ITEM ***
        SELECT EBELN EBELP MATNR MENGE NETPR FROM EKPO INTO CORRESPONDING FIELDS OF TABLE IT_EKPO
              WHERE EBELN = V_FVAL_EBELN.
        IF NOT IT_EKPO IS INITIAL.
          LOOP AT IT_EKPO INTO WA_EKPO.
            AT FIRST.
              FORMAT COLOR 5.
              WRITE:/3'ITEM NO OF PURCHASE DOCUMENT FROM EKPO TABLE'.
              FORMAT COLOR 5 OFF.
              ULINE.
              WRITE:/3'PURDOC.NO',15 'ITEM.NO',25 'MAT.NO',45 'QUANTITY',65'NETPRICE'.
              ULINE.
            ENDAT.
            WRITE:/3 WA_EKPO-EBELN,15 WA_EKPO-EBELP,25 WA_EKPO-MATNR." 45 WA_EKPO-MENGE,65 WA_EKPO-NETPR .
            CLEAR WA_EKPO.
          ENDLOOP.

        ELSE.
          WRITE:/3'NO RECORDS FOUND FOR THE SELECTED RECORD'.

        ENDIF.
      ENDIF.

Re: RSQL error 23

Former Member — Fri, 04 Sep 2009 13:12:23 GMT

It may be that the fields of table IT_EKPO are not the same as the database fields. How is this table declared?

Rob

Re: RSQL error 23

Former Member — Fri, 04 Sep 2009 13:14:40 GMT

THIS IS DECLARATION PART


TYPES : BEGIN OF TY_EKPO,
          EBELN TYPE EBELN,
          EBELP TYPE EBELP,
          MATNR TYPE MATNR,
          MENGE TYPE MENGE,
          NETPR TYPE NETPR,
        END OF TY_EKPO.
DATA : IT_EKPO TYPE TABLE OF TY_EKPO,
       WA_EKPO LIKE LINE OF IT_EKPO.

Re: RSQL error 23

Former Member — Fri, 04 Sep 2009 13:18:18 GMT

Hi,

Change the types declaration to this and check,


TYPES : BEGIN OF TY_EKPO,
          EBELN TYPE EKPO-EBELN,
          EBELP TYPE EKPO-EBELP,
          MATNR TYPE EKPO-MATNR,
          MENGE TYPE EKPO-MENGE,
          NETPR TYPE EKPO-NETPR,
        END OF TY_EKPO.
DATA : IT_EKPO TYPE TABLE OF TY_EKPO,
       WA_EKPO LIKE LINE OF IT_EKPO.

Regards,

Vikranth

Re: RSQL error 23

Clemenss — Fri, 04 Sep 2009 13:44:17 GMT

Hi jyotnsna,

vrikanth is right about the declaration. MENGE is a structure with the fields

MATNR

MEINH

UMREZ

UMREN

EANNR

EAN11

NUMTP

LAENG

BREIT

HOEHE

MEABM

VOLUM

VOLEH

BRGEW

GEWEI

ATINN

KZWSO

MSEHI

wheras EKPO-MENGE is TYPE BSTMG.

This caused the trouble.

Regards,

Clemens