Doubt on dynamic selection

[Former Member]

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.

[naimesh_patel]

Try like this:

data: P_TABNAME TYPE CHAR30.

P_TABNAME = 'CE1KVOC'.

select PALEDGER vrgar versi werks perio KNDNR artnr vkorg absmg PRODH
from (P_TABNAME)
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 .

Regards,

Naimesh Patel

[Former Member]

Hello,

To learn more about dynamic programming, I suggest you to read the following: [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b332e090-0201-0010-bdbd-b735e96fe0ae].

Regards,