topic Re: Select Query Problem in Application Development and Automation Discussions

Select Query Problem

Former Member — Wed, 14 Feb 2007 07:19:52 GMT

Hi All,

I am having the following select query in the report

SELECT *

FROM zexc_rec INTO TABLE lt_docno

WHERE lifnr IN s_lifnr AND

docno IN s_docno AND

doctyp IN ('CT1','CT1C').

when the value of s_docno is blank , the query is not selecting any rows, I want in the case of blank s_docno ,it should select all the rows with that s_lifnr and any document no..

Please suggest what should be changed for that.

Thanks.

Re: Select Query Problem

Former Member — Wed, 14 Feb 2007 07:22:28 GMT

hi,

Your query is correct. Check the DB table if there are entries for your selection criteria.

Regards

Subramanian

Re: Select Query Problem

former_member404244 — Wed, 14 Feb 2007 07:30:27 GMT

Hi,

I don't see anything wrong in ur query.plz check if u have the table entries correctly..ur query is fine...as s_docno is a selectoption so thre shouldn't be

any problem...

Regards,

Nagaraj

Re: Select Query Problem

Former Member — Wed, 14 Feb 2007 07:33:50 GMT

I dont see anything wrong in the query . please check there may be problem with the condition "<b>doctyp IN ('CT1','CT1C')</b> " .

Re: Select Query Problem

Former Member — Wed, 14 Feb 2007 07:37:27 GMT

Hi,

the query is correct but some times we may face some problem like this.

IF s_docno[] IS INITIAL.
SELECT *
FROM zexc_rec 
INTO TABLE lt_docno
WHERE lifnr IN s_lifnr AND
doctyp IN ( 'CT1', 'CT1C' ).
ELSE.
SELECT *
FROM zexc_rec 
INTO TABLE lt_docno
WHERE lifnr IN s_lifnr AND
docno IN s_docno AND
doctyp IN ( 'CT1', 'CT1C' ).

Re: Select Query Problem

Former Member — Wed, 14 Feb 2007 08:03:11 GMT

Rahul,

there might b no records in the table for this selection criteria. check it in se11.

..MB