2013 Sep 13 5:57 PM
Hello Experts,
Can you write the two queries into one. I want to avoid hitting EANL twice.
I need to pull all the installations from EANL for a given premise. But at this point i dont have premise, but i have installation only.
i have anlage in lv_install.
1)select single vstelle into lv_prem from EANL where anlage = lv_install.
2) select anlage anlart into table it_eanl where vstelle = lv_prem (from 1 above)
pls suggest
2013 Sep 14 7:12 AM
Hello Ricky,
try this code
select b~anlage b~vstelle b~anlart into table it_eanl from ( eanl as a inner join eanl as b on a~vstelle eq b~vstelle )
where a~anlage =lv_install.
Thanks & Regards
Tatha
2013 Sep 14 7:12 AM
Hello Ricky,
try this code
select b~anlage b~vstelle b~anlart into table it_eanl from ( eanl as a inner join eanl as b on a~vstelle eq b~vstelle )
where a~anlage =lv_install.
Thanks & Regards
Tatha