topic Re: Passing a variable to select statement in Application Development and Automation Discussions

Passing a variable to select statement

Former Member — Fri, 17 Aug 2007 14:57:58 GMT

Hi there,

I have a selection screen on which you can choose which table do you want to display.

I store the name of the selected table in a variable tab_name.

I want to use something like that:

data: tab_name(40).

select * from tab_name

into gt_master.

endselect.

But it did not allowed because tab_name is not a database table.

Is it possible to pass the table name in a select statement using a variable?

Re: Passing a variable to select statement

Former Member — Fri, 17 Aug 2007 15:01:44 GMT

Hello

Yes it is posible you can use a dynamic select...

Try this:

DATA tabname(10).

DATA: BEGIN OF wa,

id TYPE scustom-id,

name TYPE scustom-name,

END OF wa.

tabname = 'SCUSTOM'.

SELECT id name INTO CORRESPONDING FIELDS OF wa FROM (tabname).

WRITE: / wa-id, wa-name.

ENDSELECT.

CONSTANTS: flight_tab_name(30) VALUE 'SPFLI'.

DATA: from_clause TYPE STRING.

DATA: BEGIN OF wa,

name(20) TYPE C,

connid TYPE spfli-connid,

END OF wa.

CONCATENATE flight_tab_name ' AS t1'

' JOIN scarr AS t2 ON t1_{carrid = t2}carrid'

INTO from_clause.

SELECT t1_{connid t2}carrname AS name

FROM (from_clause)

INTO CORRESPONDING FIELDS OF wa.

WRITE: / wa-name, wa-connid.

ENDSELECT

Hope this helps

Gabriel

Re: Passing a variable to select statement

Former Member — Fri, 17 Aug 2007 15:05:09 GMT

this is not possilbe.

alternative :

put selects on different tables inside IF conditions.

Based on the value of your selection screen field tab_name,

fetch the data from the appropriate table

Re: Passing a variable to select statement

Pawan_Kesari — Fri, 17 Aug 2007 15:06:19 GMT


CREATE DATA itab TYPE STANDARD TABLE OF (tab_name). 

SELECT * 
INTO TABLE itab
FROM (tab_name) .

Message was edited by:

Pawan Kesari

Re: Passing a variable to select statement

Former Member — Fri, 17 Aug 2007 15:06:35 GMT

SELECT * FROM (p_table)

into <internal table>.

Re: Passing a variable to select statement

Former Member — Fri, 17 Aug 2007 15:12:46 GMT

Flawless Code

PARAMETERS: p_tab(40) TYPE c.

DATA         : lt_data   TYPE REF TO data.
FIELD-SYMBOLS: <table>  TYPE STANDARD TABLE.

CREATE DATA lt_data TYPE STANDARD TABLE OF (p_tab).

ASSIGN lt_data->* TO <table>.

SELECT * INTO TABLE <table> FROM (p_tab) .

Re: Passing a variable to select statement

former_member194669 — Fri, 17 Aug 2007 15:15:36 GMT

Hi,

Use fm RFC_GET_TABLE_ENTRIES or RFC_READ_TABLE.

aRs