Lookup Concept

*load only those transaction data in target whose master data exists
*need to lookup master data table and if record is not there, delete it 

* source fields are cno, salesid, matid, amount
* master data attribute table name - /bic/pcustnum- /bic/custname, age, city

*--Logic in start routine

data ITAB table of /bic/pcustnum.
data wa type /bic/pcustnum.

select * from /bic/pcustnum into table ITAB.

LOOP AT SOURCE_PACKAGE ASSIGNING <SOURCE_FIELDS>.
  READ TABLE ITAB INTO WA WITH KEY /BIC/CUSTNUM = <SOURCE_FIELDS>-CNO.

IF SY-SUBRC <> 0.
 DELETE SOURCE_PACKAGE WHERE CNO = <SOURCE_FIELDS>-CNO.
ENDIF.

ENDLOOP.