topic Re: Dynamic Select in Application Development and Automation Discussions

Dynamic Select

Former Member — Mon, 27 Nov 2006 11:45:49 GMT

Hi All

I need to pass internal tables to a select query dynamically. The database table from which i am selecting remains the same but the internal tables are subjected to change. Since I am using for all entries addition, the interpreter refuses to recognize the structure of the internal table on which i am using for all entries.

The code i tried to work with is as follows, but it throws a syntax error, saying "the structure of <fs_tab2> is unknown, there is no component matwa".

form sel_kotd001 using value(fp_tab1)

value(fp_tab2).

field-symbols:<fs_tab1> type standard table,

<fs_tab2> type standard table.

assign fp_tab1 to <fs_tab1>.

assign fp_tab2 to <fs_tab2>.

SELECT knumh

matwa

FROM kotd001

INTO TABLE <fs_tab1>

FOR ALL ENTRIES IN <fs_tab2>

WHERE matwa EQ <fs_tab2>-matwa.

endform.

any help in this regard will be appreciated

thanks

Sudhir

Re: Dynamic Select

Former Member — Mon, 27 Nov 2006 11:51:42 GMT

Modify your statement like this

SELECT knumh

matwa

FROM kotd001

INTO corresponding fields of TABLE <fs_tab1>

FOR ALL ENTRIES IN <fs_tab2>

WHERE matwa EQ <fs_tab2>-matwa.

regards,

Ravi

note - Please mark all the helpful answers

Re: Dynamic Select

Former Member — Mon, 27 Nov 2006 11:56:28 GMT

Hi ravi

It does not work, the problem is with the recognition of structure of field symbol <fs_tab2> . . . . . it says "The specified type has no structure and therefore no component called MATWA" . . . .

Re: Dynamic Select

Former Member — Mon, 27 Nov 2006 11:56:48 GMT

Hi Sudhir,

If iam not wrong , you want to use the same form for multiple purpose.

You can use this code

data: p_table(10),

p_intotable(4),

p_foralltab(4).

p_table = kotd001

p_intotable = itab say for example for into table

p_foralltab = jtab say for example of for all entries

SELECT knumh

matwa

FROM (p_table) into table (p_intotable) for all entries in (p_foralltab).

you can use this way.

Reaward points if it is helpful.

Reagrds,

Kiran I

Re: Dynamic Select

Laxmana_Appana_ — Mon, 27 Nov 2006 12:27:18 GMT

Hi,

Check this :


PARAMETERS    :  p_tab LIKE dd03l-tabname,
                 p_opt LIKE rfc_db_opt-text.

FIELD-SYMBOLS : <lt_data> TYPE table. 

SELECT * FROM (p_tab)
          CLIENT SPECIFIED
   INTO CORRESPONDING FIELDS OF TABLE <lt_data>
          UP TO p_rows ROWS
    WHERE mandt = p_mandt
                 AND (p_opt).

Regards

Appana

Re: Dynamic Select

jayanthi_jayaraman — Mon, 27 Nov 2006 12:36:35 GMT

Hi,

Just try

assign (fp_tab1) to <fs_tab1>.

assign (fp_tab2) to <fs_tab2>.

Re: Dynamic Select

Former Member — Mon, 27 Nov 2006 12:41:11 GMT

When you use CORRESPONDING FIELDS, the system does not check for fields at design time. I guess you have not use CORRESPONDING clause.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: Dynamic Select

Former Member — Mon, 27 Nov 2006 13:28:33 GMT

you can check this code for dynamic internal table create

======

REPORT Z_DOWNLOAD_UPLOAD_ANY_TABLE .

----------------------------------------------------------------------
Program for
----------------------------------------------------------------------
1. Downloading Data of any DB table to a tab delimited ASCII file

----------------------------------------------------------------------
2. Checking if a tab delimited ASCII file has the structure of a
DB table and showing its contents
----------------------------------------------------------------------
3. Uploading a tab delimited ASCII file to a DB table with the same
structure
----------------------------------------------------------------------
4. Showing the data of any DB table

======================================================================

======================================================================
DATA DECLARATIONS
======================================================================

TYPES : DATA_OBJECT TYPE REF TO DATA.

DATA : MITAB TYPE REF TO DATA .

TYPE-POOLS : SLIS .

DATA : IT_FIELDCAT TYPE STANDARD TABLE OF slis_fieldcat_alv

WITH HEADER LINE .

DATA : IT_FIELDCATALOG Type LVC_T_FCAT .

DATA : WA_FIELDCATALOG Type LVC_S_FCAT .

DATA : I_STRUCTURE_NAME LIKE DD02L-TABNAME .

DATA : I_CALLBACK_PROGRAM LIKE SY-REPID .

DATA : DYN_LINE TYPE DATA_OBJECT .

FIELD-SYMBOLS : <fs_ITAB> TYPE STANDARD TABLE .

DATA : TABLE_NAME_IS_VALID TYPE C .

DATA : DYNAMIC_IT_INSTANTIATED TYPE C .

CONSTANTS BUTTONSELECTED TYPE C VALUE 'X' .

======================================================================
SELECTION SCREEN DEFAULT
======================================================================