topic Re: SELECT statement ? in Application Development and Automation Discussions

SELECT statement ?

Former Member — Tue, 22 Apr 2008 13:44:37 GMT

hi all.`

if i want to use a SELECT statement to read Database table as i input the name of the database table , what should i do ?

for example:

parameter: p_dbname(20) type c.

start-of-selection.

select * from 'p_dbname' into ..........

can i do it ?

thx and best regards

Re: SELECT statement ?

Former Member — Tue, 22 Apr 2008 13:49:46 GMT

hi check this..

REPORT YTABFLDS .

TABLES: DD02L, DD03L, DD04T.

PARAMETERS THETABLE LIKE DD02L-TABNAME OBLIGATORY.

DATA: BEGIN OF MYTABLE,

TABNAME LIKE DD02L-TABNAME,

AS4LOCAL LIKE DD02L-AS4LOCAL,

AS4VERS LIKE DD02L-AS4VERS,

END OF MYTABLE.

SELECT SINGLE TABNAME AS4LOCAL AS4VERS INTO MYTABLE FROM DD03L

WHERE TABNAME = THETABLE.

WRITE: / MYTABLE-TABNAME, 11 MYTABLE-AS4LOCAL, 13 MYTABLE-AS4VERS.

SELECT * FROM DD03L

WHERE TABNAME = MYTABLE-TABNAME AND

AS4LOCAL = MYTABLE-AS4LOCAL AND AS4VERS = MYTABLE-AS4VERS.

WRITE: / DD03L-FIELDNAME, 11 DD03L-KEYFLAG, 13 DD03L-ROLLNAME,

24 DD03L-CHECKTABLE, 35 DD03L-INTTYPE, 37 DD03L-REFTABLE,

48 DD03L-DATATYPE.

SELECT SINGLE * FROM DD04T

WHERE ROLLNAME = DD03L-ROLLNAME AND

AS4LOCAL = MYTABLE-AS4LOCAL AND AS4VERS = MYTABLE-AS4VERS AND

DDLANGUAGE = 'E'.

WRITE: 53 DD04T-DDTEXT.

ENDSELECT.

regards,

venkat

Re: SELECT statement ?

Former Member — Tue, 22 Apr 2008 13:50:33 GMT

U can do ..

refer to ..

https://forums.sdn.sap.com/click.jspa?searchID=11023866&messageID=4817405

Re: SELECT statement ?

Former Member — Tue, 22 Apr 2008 13:55:33 GMT

see this Sample Coding

DATA wa TYPE spfli.

SELECT * FROM spfli INTO wa

WHERE cityfrom = 'FRANKFURT' AND

cityto = 'NEW YORK'.

WRITE: / wa-carrid, wa-connid.

ENDSELECT.

Here spfli - std sap table.

WA - Work area.

<REMOVED BY MODERATOR>

Pari

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 1:14 PM

Re: SELECT statement ?

Former Member — Tue, 22 Apr 2008 13:57:22 GMT

U can try this.

data:

P_name(20) type c.

select *

from (p_name)

into itab.

endselect.