Skip to Content
0
Former Member
Jul 17, 2008 at 11:42 AM

select query not working

1780 Views

hi,

can anyone tell me whats wrong in this code:

SELECT bukrs

lifnr

augdt

augbl

gjahr

belnr

budat

bldat

blart

wrbtr

zterm

zbd1t

zbd2t

zbd1p

zbd2p

INTO TABLE i_bsak

FROM bsak

WHERE lifnr EQ p_lifnr

AND augdt IN s_date

AND augbl EQ 'RE'

AND gjahr EQ p_gjahr.

it is not fetching any data. sy-subrc is 4. Though

there is one record meeting the selection criteria enterd in the selection screen.