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

Runtime error - DBIF_RSQL_INVALID_RSQL

Hello,

When i am executing my program one system, it working fine for the below select statement. But while testing the same in another system we are having a runtime error 'DBIF_RSQL_INVALID_RSQL' 'RSQL error 13 when accessing table "EBAN ".

the select statement is as follows:

SELECT

menge

lfdat

matnr

FROM eban

INTO CORRESPONDING FIELDS OF TABLE i_pr_items

WHERE bsart EQ c_bsart1

AND bstyp EQ c_bstyp1

AND loekz EQ space

AND werks IN s_plant

AND matnr IN s_matnr

AND ebakz NE c_check.

can anyone help me in this please.

thanks a lot

regards

Nitin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 02:21 PM

    Hi

    <b>I guess the Internal table - i_pr_items[] is not compatible here.</b>

    <u>Please paste the declaration of i_pr_items internal table as well.

    Also, paste the detailed Shortdump from ST22 transaction.</u>

    Hope this will help.

    Please reward suitable points.

    Regards

    - Atul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 02:24 PM

    One of these 3 fields menge lfdat matnr declaration is not compatible in the internal table with the database fields, pls show declaration

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 02:34 PM

    can you check how many entries are populated in ur select options s_matnr and s_plant , it should not exceed more than 1630

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 02:43 PM

    hi,

    i think the varaiables, select-options, parameters used in the where condition is not of the type of the field they are compared with. just declare those variables of type of the field to whihc it is compared

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 06:18 PM

    I think you are passing too many entries in either S_MATNR or S_PLANT.

    there is a limit to overall length of where clause passed to DB.

    workaround would be

    - either split your s_matnr into smaller chunks (define ranges, pass <=300...400 entries from s_matnr to the range, then select appending internal table, do it until you process all entries in s_matnr.).

    - or, if you do not use intervals in your s_matnr (just single values) - use select for all entries in s_matnr where matnr = s_matnr-low.

    Add a comment
    10|10000 characters needed characters exceeded

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.