Selecting data using filed symbol...!

[Former Member]

Hi SDN,

I am using select query in dynamically created table but it's giving me dump AS

You attempted to assign a field to a typed field symbol,

but the field does not have the required type.

DATA : dref TYPE REF TO data.

PARAMETERS : pa_tab TYPE string. "Get Table name from user

CREATE DATA dref TYPE (pa_tab).

FIELD-SYMBOLS : <fs_it_tab> TYPE ANY TABLE.

ASSIGN dref->* TO <fs_it_tab>.

SELECT * FROM (pa_tab) INTO TABLE <fs_it_tab> UP TO 10 ROWS.

[Former Member]

try this way.

ASSIGN dref->* TO <fs_it_tab> CASTING TYPE data.

*reward if solved*

[Former Member]

Hi Sreejith,

It's giving me syntax error Generic type "DATA" not allowed.

Regards,

Rahul

[Former Member]

ASSIGN dref->* TO <fs_it_tab> CASTING like dref.

[Former Member]

It's giving again a syntax error as

"DREF" and "<FS_IT_TAB>" are type-incompatible.

Regards,

Rahul

[Former Member]

try this..

ASSIGN dref TO <fs_it_tab> casting like dref.

[varma_narayana]

Hi Rahul...

This is the code for u. Try it...

DATA : REF_TAB TYPE REF TO DATA.

FIELD-SYMBOLS: <FTAB> TYPE TABLE.

PARAMETERS: P_TABLE TYPE DD02L-TABNAME VALUE 'EKPO'.

CREATE DATA REF_TAB TYPE TABLE OF (L_TABLE).

ASSIGN REF_TAB->* TO <FTAB>.

SELECT * FROM (P_TABLE) INTO TABLE <FTAB>.

DESCRIBE TABLE <FTAB>.

WRITE:/ SY-TFILL.

Note: One more point. We cannot declare PARAMETER with STRING data type.

REWARD IF HELPFU.

[Former Member]

Thanks a lot...!