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

Problem in select statement

Former Member — Tue, 05 Feb 2008 05:16:24 GMT

Hi Abap Gurus,

In my select statement iam picking up right data, Here the thing is when i give one single pernr, i need to get 1 single pernr's data.

Here in this select statement iam getting all the data.

SELECT * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR OR

PERSK EQ 'FG' OR

PERSK EQ 'MI' OR

PERSK EQ 'GM' OR

PERSK EQ 'TL' OR

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

Thanks and Regards,

-Anil

Points will be rewarded....

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:17:56 GMT

Hi,

USe SELECT SINGLE..

SELECT SINGLE * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR OR

PERSK EQ 'FG' OR

PERSK EQ 'MI' OR

PERSK EQ 'GM' OR

PERSK EQ 'TL' OR

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

Reward Appropriate points.

Regards,

MAnsi.

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:18:52 GMT

Hi,

If you want to fetch only single record then you need to use the SINGLE keyword in your SELECT query...

SELECT SINGLE * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR OR

PERSK EQ 'FG' OR

PERSK EQ 'MI' OR

PERSK EQ 'GM' OR

PERSK EQ 'TL' OR

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

Reward points if useful.

Thanks.

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:20:00 GMT

try SELECT SINGLE * FROM PA0001

........................................

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:35:10 GMT

try this,

SELECT * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR and

( PERSK EQ 'FG' OR

PERSK EQ 'MI' OR

PERSK EQ 'GM' OR

PERSK EQ 'TL' ) and

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:38:05 GMT

try select single.....from Dbtab

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:44:06 GMT

hiii...use select single statement..and also if ur going to give single pernr u can directly pass like PERNR = SO_PERNR,if SO_PERNR contains single value, change ur code like this..

SELECT single * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR and

( PERSK EQ 'FG' OR

PERSK EQ 'MI' OR

PERSK EQ 'GM' OR

PERSK EQ 'TL' ) and

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA

reward if usefull

Edited by: Sugumar Ganesan on Feb 5, 2008 6:44 AM

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:45:15 GMT

U have to specify all these fields

PERNR

SUBTY

OBJPS

SPRPS

ENDDA

BEGDA

SEQNR

in ur select query. then u will get exactly one row

Narendra

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:48:30 GMT

Select SIngle query will fetch you a single record.. keep in mind in the where clause you have provided all key fields as conditions.

Alternatively you can also use query SELECT UP TO 1 ROWS query. This will also give you only one (the first match) record.

Re: Problem in select statement

muthuraj_kalidoss2 — Tue, 05 Feb 2008 05:49:33 GMT

Try with below code

Replace OR by AND

SELECT * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR AND

PERSK IN ( 'FG' , 'MI', 'GM', 'TL' ) AND

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

If u give OR condition in pernr it will check for the pernr in the select option and if it fails it check for the next condition.

If possible make the PERSK into a range .

Hope this will do.

Re: Problem in select statement

Former Member — Tue, 05 Feb 2008 05:51:05 GMT

Anil,

Try with this.

SELECT * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR OR

PERSK IN ( 'FG' , 'MI' , 'GM' , 'TL' ) OR

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

(OR )

SELECT * FROM PA0001

INTO TABLE IT_PERNR

WHERE PERNR IN SO_PERNR AND

PERSK IN ( 'FG' , 'MI' , 'GM' , 'TL' ) OR

BTRTL IN SO_BTRTL AND

ENDDA GE W_ENDDA AND

BEGDA LE W_BEGDA.

Don't forget to reward if useful...