In my selection screen I have controlling area. Depending on controlling are I need to select data from different tables. For now I have hard coded it.
But how can i make it dynamic? is there any way?
Thanks in advance.
My code:
loop at s_kokrs.
*if s_kokrs-low eq 'KVCO'.*
select PALEDGER vrgar versi werks perio KNDNR artnr vkorg absmg PRODH
from CE1KVOC
appending table wt_CE1KVOC
where PALEDGER = s_PALE
and vrgar = s_vrgar
and versi = s_versi
and werks in s_werks
and perio in r_period
and artnr in s_artnr
and prodh in s_prodh .
elseif s_kokrs-low eq 'KGCO'.
select PALEDGER vrgar versi werks perio KNDNR artnr vkorg absmg PRODH
from CE1Kgoc
appending table wt_CE1KVOC
where PALEDGER = s_PALE
and vrgar = s_vrgar
and versi = s_versi
and werks in s_werks
and perio in r_period
and artnr in s_artnr
and prodh in s_prodh . .
endif.
endloop.