Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in module RSQL of the database interface

I am trying to input the Latitude and Longitude in a report but I'm not having luck. Can anyone let me know what I'm doing wrong? I found that there are two tables that use the coordinates:

  • IFLOT
  • CI_IFLOT

Thanks.

Category           ABAP Programming Error
Runtime Errors     DBIF_RSQL_INVALID_RSQL
Except.            CX_SY_OPEN_SQL_DB
ABAP Program       Z_CCS_DISCONN_REPORT4

Application Component  PT-RC-AA

=====================================================================================================

data: begin of int_equi occurs 0,
          anlage       like  eastl-anlage,
          sernr          like  equi-sernr,
          matnr         like  equi-matnr, "Material Number SReed 09/08/15
          zzgiscodx  like iflot-zzgiscodx, "Testing Latitude

          zzgiscody  like iflot-zzgiscody, "Testing Longitude
          sparte         like  equi-sparte,
          logiknr        like  eastl-logiknr,
          bis             like  eastl-bis,
       end of int_equi.


=====================================================================================================


select b~anlage e~sernr e~matnr e~sparte c~logiknr c~bis f~zzgiscodx
     into table int_equi
        from            te422 as a
        left outer join eanlh as b   on b~ableinh = a~termschl
        inner      join eastl as c   on c~anlage  = b~anlage
        inner      join egerh as d   on d~logiknr = c~logiknr
        inner      join equi  as e   on e~equnr   = d~equnr
        inner      join iflot as f   on f~SERGE = e~matnr "Testing Coordinates
        where a~portion in s_portn
        and   c~bis ge p_keydt
        and   d~bis ge p_keydt
        and   d~kombinat = 'Z'
        and   e~EQTYP    = 'I'.

     sort int_equi by anlage.



Former Member
replied

Try this:

DATA: BEGIN OF int_equi OCCURS 0,

           anlage     LIKE  eastl-anlage,

           sernr      LIKE  equi-sernr,

           matnr      LIKE  equi-matnr, "Material Number SReed 09/08/15

           sparte     LIKE  equi-sparte,

           logiknr    LIKE  eastl-logiknr,

           bis        LIKE  eastl-bis,

           zzgiscodx  LIKE  iflot-zzgiscodx, "Testing Latitude

           zzgiscody  LIKE  iflot-zzgiscody, "Testing Longitude

        END OF int_equi.

SELECT

   b~anlage

   e~sernr

   e~matnr

   e~sparte

   c~logiknr

   c~bis

   h~zzgiscodx

   h~zzgiscody

INTO TABLE int_equi

FROM            te422 AS a

LEFT OUTER JOIN eanlh AS b   ON b~ableinh EQ a~termschl

INNER JOIN      eastl AS c   ON c~anlage  EQ b~anlage

INNER JOIN      egerh AS d   ON d~logiknr EQ c~logiknr

INNER JOIN      equi  AS e   ON e~equnr   EQ d~equnr

INNER JOIN      equz  AS f   ON f~equnr   EQ e~equnr

INNER JOIN      iloa  AS g   ON g~iloan   EQ f~iloan

INNER JOIN      iflot AS h   ON h~iloan   EQ g~iloan

                            AND h~tplnr   EQ g~tplnr

WHERE a~portion  IN s_portn

  AND c~bis      GE p_keydt

  AND d~bis      GE p_keydt

  AND d~kombinat EQ 'Z'

  AND e~eqtyp    EQ 'I'.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question