Skip to Content
0
Former Member
May 09, 2008 at 12:59 PM

Doubt on dynamic selection

24 Views

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.