regarding tables call dynamically

[Former Member]

hi to all

I have code:

DATA: w_tab TYPE /TMW/SCNR_ID.

DATA: i_tab TYPE STANDARD TABLE OF /TMW/SCNR_ID.

SELECT * FROM /TMW/SCNR_ID INTO TABLE I_TAB.

now i have 150 table like /tmw/* . i need call all tables like above code. is there any tip to use table with out changing table everytime.

thank you

[Former Member]

Hi,

here a short code:

DATA: DBTAB  TYPE TABNAME.
DATA: MAXSEL TYPE INT4.
* Daten für variable DB-Tabellenausgabe
FIELD-SYMBOLS: <GT_ITAB> TYPE TABLE,
               <GS_ITAB>.
*
DATA:          GT_DATA   TYPE REF TO DATA.
DATA:          GS_DATA   TYPE REF TO DATA.
*
DBTAB = 'LFA1'. MAXSEL = 20.
CREATE DATA GT_DATA TYPE TABLE OF (DBTAB).
ASSIGN GT_DATA->* TO <GT_ITAB>.
CREATE DATA GS_DATA  LIKE LINE OF <GT_ITAB>.
ASSIGN GS_DATA->* TO <GS_ITAB>.
*
SELECT * FROM (DBTAB) INTO TABLE <GT_ITAB>
                      UP TO MAXSEL ROWS.
*
BREAK-POINT.
*
DBTAB = 'MARA'. MAXSEL = 100.
CREATE DATA GT_DATA TYPE TABLE OF (DBTAB).
ASSIGN GT_DATA->* TO <GT_ITAB>.
CREATE DATA GS_DATA  LIKE LINE OF <GT_ITAB>.
ASSIGN GS_DATA->* TO <GS_ITAB>.
*
SELECT * FROM (DBTAB) INTO TABLE <GT_ITAB>
                      UP TO MAXSEL ROWS.
*
BREAK-POINT.
*

Look at break-point into .

Regards, Dieter

[Former Member]

Hi,

problems still not solved?

Regards, Dieter