topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 22 May 2008 13:01:44 GMT

Hi ABAP folks,

How to acheive this

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where

bukrs = ('Z01' or 'z18' or 'z32') and

blart = ('KA' or 'KG' or 'KR') and

bldat = '04242000'.

I need to fetch data where bukrs can be either Z01 or Z18 or Z32 ..and similarly for BLART and BLART.

Please correct this select statement

Re: select statement

Former Member — Thu, 22 May 2008 13:04:17 GMT

hai ,

try this

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where

bukrs = 'Z01' or bukrs = 'z18' or bukrs = 'z32' and

blart = 'KA' or blart = 'KG' or blart = 'KR' and

bldat = '04242000'.

Regards,

Vikram

Re: select statement

Former Member — Thu, 22 May 2008 13:05:24 GMT

hi,

try,

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where

bukrs in ('Z01','Z18', 'Z32') and

blart in ('KA', 'KG', 'KR') and

bldat = '20000424'.

rgrds,

burak

Re: select statement

Former Member — Thu, 22 May 2008 13:05:42 GMT

Hi Jagadish,

see the following code.

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where

bukrs in ('Z01', 'z18','z32') and

blart in ('KA' , 'KG', 'KR') and

bldat = '04242000'.

reward points if helpful.

Re: select statement

Former Member — Thu, 22 May 2008 13:06:09 GMT

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where (

bukrs = 'Z01'

or bukrs = 'z18'

or bukrs = 'z32' ) and

( blart = 'KA'

or blart = 'KG'

or blart = 'KR' ) and

bldat = '04242000'.

Re: select statement

Former Member — Thu, 22 May 2008 13:11:38 GMT

Hi,

select belnr bukrs gjahr blart xblnr bldat budat bktxt usnam from bkpf

into table i_bkpf

where

( bukrs = 'Z01' or bukrs = 'z18' or bukrs = 'z32' ) and

( blart = 'KA' or blart = 'KG' or blart = 'KR' ) and

bldat = '04242000'.

Chack Once.

Regards,

Narasimha