topic Select query problem in Application Development and Automation Discussions

Select query problem

Former Member — Wed, 06 Feb 2008 10:44:44 GMT

Dear Friends,

I have problem with select statement:

My query is like this:

REFRESH: r_name_key.

REFRESH: r_PART_NO.

r_name_key-sign = 'I'.

r_name_key-option = 'CP'.

r_name_key-low = '00000000' .

r_name_key-high = '99999999' .

APPEND r_name_key.

r_PART_NO-sign = 'I'.

r_PART_NO-option = 'CP'.

r_PART_NO-low = ' ' .

r_PART_NO-high = ' ' .

APPEND r_PART_NO.

SELECT matnr name_key part_no FROM XXX INTO TABLE

itab_XXX

FOR ALL ENTRIES IN itab_mfg

WHERE NAME_KEY in r_name_key and

PART_NO in r_PART_NO and

matnr = itab_mfg-matnr.

Here itab_mfg is having 305 records and Table XXX is having 2000 records.

The query is failed...its not picked even one records also...Ihave checked the table there are somany matched records need to fetch ( Ihave used the ranges to increse the performence).

whats the problem with query???

Thanks,

Sridhar.

Re: Select query problem

Former Member — Wed, 06 Feb 2008 10:48:28 GMT

Hi,

check ur ranges

r_name_key-sign = 'I'.
r_name_key-option = 'BT'.
r_name_key-low = '00000000' .
r_name_key-high = '99999999' .
APPEND r_name_key.

r_PART_NO-sign = 'I'.
r_PART_NO-option = 'BT'.
r_PART_NO-low = ' ' .
r_PART_NO-high = ' ' .
APPEND r_PART_NO.

Cheers,

jose.

Re: Select query problem

Former Member — Wed, 06 Feb 2008 10:48:43 GMT

Hi,

Change your code as below :



r_name_key-sign = 'I'.
r_name_key-option = 'BT'. "Chnaged from CP to BT
r_name_key-low = '00000000' .
r_name_key-high = '99999999' .
APPEND r_name_key.

r_PART_NO-sign = 'I'.
r_PART_NO-option = 'BT'. "Changed from CP to BT
r_PART_NO-low = ' ' .
r_PART_NO-high = ' ' .
APPEND r_PART_NO.

Thanks,

Sriram Ponna.

Re: Select query problem

Vijay — Wed, 06 Feb 2008 10:49:25 GMT

have u checked that there r records which are satisfying all the three conditions ?

regards

vijay

Re: Select query problem

Former Member — Wed, 06 Feb 2008 10:50:05 GMT

HI shridhar,

Your ranges will be the problem. For option you use 'CP' which means contains pattern, but from the values in low and high this should be BT I guess?

For the second range it is not clear what you want. To select only records with PART_NO = space?

Regards,

John.

Re: Select query problem

Former Member — Wed, 06 Feb 2008 10:54:53 GMT

hi ,

try like dis,

SELECT matnr name_key part_no INTO TABLE

itab_XXX

FROM XXX

FOR ALL ENTRIES IN itab_mfg

WHERE NAME_KEY in r_name_key and

PART_NO in r_PART_NO and

matnr = itab_mfg-matnr.

reward if helpful

Re: Select query problem

Former Member — Wed, 06 Feb 2008 10:57:58 GMT

Hi,

Option u kept as 'CP'. Is it the exact requirement matches or not . once check.

Thanks,

Suma.

Re: Select query problem

Former Member — Wed, 06 Feb 2008 11:09:54 GMT

Sriram Thanks for the replay,

The problem is solved but if I removed r_PART_NO range from select statement. if I pass r_PART_NO in my select stament along with r_name_key the condition is failed.....

anyho thanks for the replay.

Sridhar

Re: Select query problem

Former Member — Wed, 06 Feb 2008 11:18:53 GMT

Your right ..... I need to take BT instead of CP, I removed it.

and for PART_NO its Char field in my table because of that I have taken it like this in my select statement.

but if I used PART_NO in my select statemnt the condition is failed.( I gues it is empty so ..)

Re: Select query problem

Former Member — Wed, 06 Feb 2008 11:27:36 GMT

Hi,

Can you do a small change, anyhow you are not passing any values to r_part_no take out the r_part_no from the select statement. And you can use below statement.


Delete itab where part_no not in r_part_no.

Thanks,

Sriram Ponna.