topic Re: select query in Application Development and Automation Discussions

select query

anupam_srivastava2 — Thu, 04 Oct 2007 08:34:17 GMT

Hi all

I am using 4.6c version, i have written a query, which needs to select data which has been selected from selection screen eg sal_org which is sales org, divi which is division and sal_off which is sales office and quot_date which is quotaion date.

but the select query selects all the records even i have used the where clause.......any suggestions

select * from vbak into TABLE sal_doc_H where

VKORG = sal_org AND

SPART = divi AND

VKBUR = sal_off AND

ERDAT GE QUT_DATE-LOW AND ERDAT LE qut_date-high OR

auart = 'ZIQT' OR

AUART = 'ZUQT' OR

AUART = 'ZUQW'.

Re: select query

Former Member — Thu, 04 Oct 2007 08:35:49 GMT

select * from vbak into TABLE sal_doc_H where

VKORG IN sal_org AND

SPART IN divi AND

VKBUR IN sal_off AND

ERDAT GE QUT_DATE-LOW AND ERDAT LE qut_date-high OR

auart = 'ZIQT' OR

AUART = 'ZUQT' OR

AUART = 'ZUQW'.

For select option you should use IN instead of =.

Re: select query

former_member188827 — Thu, 04 Oct 2007 08:38:04 GMT

da prob lies in OR

auart = 'ZIQT' OR

AUART = 'ZUQT' OR

AUART = 'ZUQW'.

wat is ur selection criteria...expalin in words

Re: select query

Former Member — Thu, 04 Oct 2007 08:42:00 GMT

select * from vbak into TABLE sal_doc_H where

VKORG IN sal_org AND

SPART IN divi AND

VKBUR IN sal_off AND

ERDAT GE QUT_DATE-LOW AND ERDAT LE qut_date-high

AND (

auart = 'ZIQT' OR

AUART = 'ZUQT' OR

AUART = 'ZUQW' ).

As far as i can understand i think this is what you want.

Khusro habib