topic Re: Problem with select statement using Ranges in Application Development and Automation Discussions

Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 11:38:41 GMT

Hi Guys,

I have used Ranges and used a select statement for selecting those ranges but I am facing a problem.


RANGES: r_doctyp for EDIDC-DOCTYP.
r_doctyp-sign = 'I'.
r_doctyp-option = 'EQ'.
r_doctyp-low  = 'DEBMAS'.
append r_doctyp.


r_doctyp-sign = 'I'.
r_doctyp-option = 'EQ'.
r_doctyp-low  = 'MATMAS'.
append r_doctyp.

r_doctyp-sign = 'I'.
r_doctyp-option = 'EQ'.
r_doctyp-low  = 'PRICAT'.
append r_doctyp.

r_doctyp-sign = 'I'.
r_doctyp-option = 'EQ'.
r_doctyp-low  = 'ORDERS'.
append r_doctyp.

r_doctyp-sign = 'I'.
r_doctyp-option = 'EQ'.
r_doctyp-low  = 'INVOIC'.
append r_doctyp.

Select DOCNUM                                " IDoc number
       DOCTYP                                " IDoc Type
             from  EDIDC into table IT_ZEDIDC
             where CREDAT EQ s_credat-low
             and   DOCTYP EQ r_doctyp        " IDOC Types
             and   DIRECT EQ '1'.

Here my select statement is only taking INVOIC.

But my statement should take any document type.

Thanks,

Prasad.

Re: Problem with select statement using Ranges

matt — Tue, 05 May 2009 11:39:23 GMT

DOCTYP IN r_doctyp

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 11:39:46 GMT

Select DOCNUM " IDoc number

DOCTYP " IDoc Type

from EDIDC into table IT_ZEDIDC

where CREDAT EQ s_credat-low

and DOCTYP IN r_doctyp " IDOC Types

and DIRECT EQ '1'.

Kiran

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 11:40:47 GMT

Hi,

change the select statement as given below...

Select DOCNUM                                " IDoc number
       DOCTYP                                " IDoc Type
             from  EDIDC into table IT_ZEDIDC
             where CREDAT IN s_credat
             and   DOCTYP IN r_doctyp        " IDOC Types
             and   DIRECT EQ '1'.

Regards,

Siddarth

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 11:42:16 GMT

Hi There,

Your "WHERE" clause is saying "EQ" to r_doctype so is matching to the last value you appended to your range table.

Range tables work like select-options

- you need the syntax to be "WHERE doctype IN r-doctype"

Hope that helps!

Robin

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 12:11:47 GMT

Hi all,

Even I have used IN but its not coming up.

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 12:15:32 GMT

Hi,

Firstly check if the entries does exist in the database table for the conditions you have given....

if so,,

did you try with the select query I had written because even for select-options you have to use IN like I had given you in my post....

if that also does not work,

then provide us the select query you have changed and also try to debug what exactly the values are retrieved from the table...

Regards

Siddarth

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 12:16:45 GMT

HI Try this:

Select DOCNUM " IDoc number

DOCTYP " IDoc Type

from EDIDC into table IT_ZEDIDC

where CREDAT IN s_credat

and DOCTYP IN r_doctyp " IDOC Types

and DIRECT EQ '1'.

Kiran

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 12:18:18 GMT

Hi Siddarth,

Entries are there in Database.

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 12:20:39 GMT

did you try with the select query I had given earlier...

I had given the same one as Kiran has given in his recent post....

Regards,

Siddarth

Edited by: Siddharth Chordia on May 5, 2009 2:21 PM

Re: Problem with select statement using Ranges

naveen_inuganti2 — Tue, 05 May 2009 12:24:44 GMT

Hi...,

Your following select statement is correct.

Select DOCNUM                                " IDoc number
            DOCTYP                                " IDoc Type
            from  EDIDC into table IT_ZEDIDC
            where CREDAT IN s_credat
            and   DOCTYP IN r_doctyp        " IDOC Types
            and   DIRECT EQ '1'.

Why you are not getting result..

1. structure of the IT_ZEDIDC is having two fields DOCNUM , DOCTYP with same data lengths. If not it should be...

2. Order in the database table is must be similer to the order you maintained in the select statement.

3. As you are hard coding the input ranges make sure about every letter.

4. take a look at other where condition fields too.

5. check the table of the ranges in debugging mode.

6. why can't you declare separate work area and table for ranges...?

like .... data: r_tab type range of <field>

data: wa_tab like line of r_tab.

7. Use clear work area statement after the append statment.

--Naveen Inuganti.

Re: Problem with select statement using Ranges

SuhaSaha — Tue, 05 May 2009 12:28:05 GMT

Hello Dheeru,

Can you just change your SELECT stmt to

Select            DOCNUM                                " IDoc number
                     DOCTYP                                " IDoc Type
             from  EDIDC into table IT_ZEDIDC
             where CREDAT EQ s_credat-low
             " and   DOCTYP EQ r_doctyp
             AND IDOCTP IN r_doctyp "--> use this clause
             and   DIRECT EQ '1'.

You can give this a try. I can see in my system DOCTYP is not populated. You can check EDIDC in your system for an existing Idoc & validate:-))

BR,

Suhas

Edited by: Suhas Saha on May 5, 2009 2:28 PM

Re: Problem with select statement using Ranges

Former Member — Tue, 05 May 2009 13:12:21 GMT

Instead of EQ you must use IN in your select statement.

remember this when we are using select-options ,in select statement use "IN" only.

for parameters , you have to use "EQ".

Hope it will help you