Skip to Content
0
Former Member
Jan 03, 2008 at 02:08 PM

select statement

21 Views

hi

i need to fetch lifnr bukrs and erdat from LFB1 table

following is the select query

select lifnr

bukrs

erdat

from lfb1

into table gt_lfb1

where lifnr in s_lifnr

and bukrs in s_bukrs.

whereas lfb1-lifnr fetched should not be in BSIK and BSAK table.

selection screen fields are

LFB1-LIFNR

LFB1-BUKRS

how can i fetch those lifnrs

please its urgent.