Skip to Content
author's profile photo Former Member
Former Member

Select Query

Hi,

please tell me the error in select query below, it results in a DUMP

with message "Error in the module RSQL accessing the database interface"

SELECT IDOCNUM

ORDNUM

SENDER

ZDATE

TIME

ZUSER

STATUS

STATUSDATE

STATUSTIME

STATUSUSER

REJECTREASON

PONUMBER

FROM zv7_custord INTO TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE ).

Note i cannot use ENDSELECT .

Thanks in Advance

Bijal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:26 AM

    SELECT IDOCNUM

    ORDNUM

    SENDER

    ZDATE

    TIME

    ZUSER

    STATUS

    STATUSDATE

    STATUSTIME

    STATUSUSER

    REJECTREASON

    PONUMBER

    FROM zv7_custord INTO corresponding fields of TABLE G_T_ZV7_CUSTORD

    WHERE ( SENDER in S_SENDER and

    ORDNUM in S_ORDER and

    ZDATE in S_DATE ) OR

    ( SENDER in S_SENDER AND

    STATUS = SPACE ).

    trry corresponding fields

    regards

    shiba dutta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:27 AM

    This is a generic error which occurs due to non availability of database table.

    This situation can arise due to high load on server or due to large number of application accessing the table.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:28 AM

    Hi,

    in select align the fields as they are in the ITAB.

    or use into corresponding fields

    regards

    Shiva

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:29 AM

    can you show the structure of G_T_ZV7_CUSTORD , does it contain all the fields mentioned int the select statement, if not

    use INTO CORRESPONDING FIELDS OF

    SELECT IDOCNUM

    ORDNUM

    SENDER

    ZDATE

    TIME

    ZUSER

    STATUS

    STATUSDATE

    STATUSTIME

    STATUSUSER

    REJECTREASON

    PONUMBER

    FROM zv7_custord <b>INTO CORRESPONDING FIELDS OF</b> TABLE G_T_ZV7_CUSTORD

    WHERE ( SENDER in S_SENDER and

    ORDNUM in S_ORDER and

    ZDATE in S_DATE ) OR

    ( SENDER in S_SENDER AND

    STATUS = SPACE ).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:31 AM

    Bijal,

    Check if you can see data using transaction SE16. It will make clear if your application server can communicate to the Database server.

    Your code is perfectly fine.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:32 AM

    this is a generic error. try using <b>INTO corresponding fields of TABLE</b>...also, this error comes sometimes only due to high process and lack of system resources. try to execute a couple of times and this error goes off when the system resources are available.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:35 AM

    hi

    i am sorry i did not provide complete details,

    my problem is i cannot use INTO CORRESPONDING , due to coding stds,

    But i can veiw table data thru SE16,

    so is this still Server problem

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:42 AM

    hi,

    Note its a DB table that only i am using it,

    and also its the first Query in the report,

    structure of both are same.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Shiva,

      The order of the fields is the problem in you case.

      Please check with this code.

      REPORT yalv_demop2 .

      DATA : BEGIN OF it_mara1 OCCURS 0,

      matnr LIKE mara-matnr,

      meins LIKE mara-meins,

      blanz LIKE mara-blanz,

      END OF it_mara1.

      SELECT

      matnr

      meins

      blanz

      FROM mara

      INTO TABLE it_mara1

      UP TO 100 ROWS.

      Bijal : Please try with a similar select statement as shown below.

      select single zzrshc zzrsdc into (i_results-zzrshc,

      i_results-zzrsdc)

      from vbak

      where vbeln eq vbfa-vbelv.

      regards,

      Priya.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.