Skip to Content
0
Feb 25, 2011 at 09:34 AM

Is it possible to take lifnr(5) in WHERE Clause of SELECT Statement

144 Views

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