topic Re: Selecting data using filed symbol...! in Application Development and Automation Discussions

Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 10:38:38 GMT

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.

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 10:41:00 GMT

try this way.

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

*reward if solved*

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 10:58:02 GMT

Hi Sreejith,

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

Regards,

Rahul

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 11:02:04 GMT

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

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 11:05:44 GMT

It's giving again a syntax error as

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

Regards,

Rahul

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 11:11:52 GMT

try this..

ASSIGN dref TO <fs_it_tab> casting like dref.

Re: Selecting data using filed symbol...!

varma_narayana — Thu, 25 Oct 2007 11:17:52 GMT

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.

Re: Selecting data using filed symbol...!

Former Member — Thu, 25 Oct 2007 12:01:28 GMT

Thanks a lot...!