select statement

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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'.

[Former Member]

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