u should not use join on more than 3 tables, performance will go down.
do join operation on first three table, LFA1, LFB1 & ADR2 into another IT gt_lf_add.
next
check gt_lf_add is not initial.
select req. fields
from ADR3
into table gt_addr3
for all entries in gt_lf_add
where ADDRNUMBER = gt_lf_add-addrnumber
and PERSNUMBER = gt_lf_add-PERSNUMBER
and DATE_FROM = gt_lf_add-PERSNUMBER
and CONSNUMBER = gt_lf_add-PERSNUMBER.
check gt_addr3 is not initial.
do selection on ADR6, based on gt_addr3.
select req. fields
from ADR6
into table gt_addr6
for all entries in gt_addr3
where ADDRNUMBER = gt_addr3-addrnumber
and PERSNUMBER = gt_addr3-PERSNUMBER
and DATE_FROM = gt_addr3-PERSNUMBER
and CONSNUMBER = gt_addr3-PERSNUMBER.
based on these 3 tables , prepare final internal table.
Bluesky
