Hi,
I have to take Invoice only for 1 & 2 Series Vendors. i.e. Lifnr = 01********** & 02**********.
I try it with diff codes - As -->
SELECT belnr gjahr budat lifnr lifnr(2) FROM rbkp
INTO (it_final-belnr, it_final-gjahr, it_final-budat, it_final-lifnr, v_lifnr)
WHERE budat IN so_budat
AND tcode = 'MIRO'
AND stblg = ''
AND lifnr(2) IN ('01','02').
" Syntax error
But not getting the correct Syntax. Is it possible to work like it?
Itwill give major diff on Performance if I can filter it in SELECT Statement.
Edited by: Priya.ABAP on Feb 25, 2011 10:34 AM