Dynamic data select from table is giving dump

[Former Member]

Hello Experts,

Below statement is giving Dump after it move all the data in my dynamic table.

When i see in debug. All my recored are avilable in <T_TAB> Table.

SELECT * FROM (pa_tab) INTO CORRESPONDING FIELDS OF TABLE <T_TAB>.

-

---

> IF SY-SUBRC = 0.

Information on where terminated

The termination occurred in the ABAP program "ZFIR_ZTABLE_UPLOAD" in

"F_DOWNLOAD".

The main program was "ZFIR_ZTABLE_UPLOAD ".

The termination occurred in line 403 of the source code of the (Include)

program "ZFIR_ZTABLE_UPLOAD"

of the source code of program "ZFIR_ZTABLE_UPLOAD" (when calling the editor

4030).

Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in

the

procedure "F_DOWNLOAD" "(FORM)" but was not handled locally, not declared in

the

RAISING clause of the procedure.

The procedure is in the program "ZFIR_ZTABLE_UPLOAD ". Its source code starts

in line 399

of the (Include) program "ZFIR_ZTABLE_UPLOAD ".

please help me.

Regards,

Amit

Message was edited by:

Amit Gupta

[former_member194669]

Hi,

Whether (pa_tab) and <t_tab> structure are same ?.

aRs

[Former Member]

Hi,

<T_TAB> shouldn't be type any.

You have to do it that way:

DATA: dref TYPE REF TO data.

CREATE DATA dref TYPE (pa_tab).

ASSIGN dref->* TO <T_TAB>.

Regards,

Wojciech

[rajasekhar_matukumalli3]

Hi Amit,

Check if you are doing the following in your program

FIELD-SYMBOLS <T_TAB> TYPE STANDARD TABLE.

DATA: g_tabref type ref to data. "Reference to your table structure

CREATE DATA g_tabref type standard table of (pa_tab).

ASSIGN g_tabref->* to <T_TAB>.

SELECT * FROM (PA_TAB) INTO TABLE <T_TAB>.

Hope this solves your problem.

Let me know if you require any further info.

Enjoy SAP. Reward points of useful

Rajasekhar