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.