topic Re: Dynamic data select from table is giving dump in Application Development and Automation Discussions

Dynamic data select from table is giving dump

Former Member — Fri, 23 Mar 2007 21:57:36 GMT

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

Re: Dynamic data select from table is giving dump

former_member194669 — Fri, 23 Mar 2007 22:17:32 GMT

Hi,

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

aRs

Re: Dynamic data select from table is giving dump

Former Member — Fri, 23 Mar 2007 22:36:13 GMT

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

Re: Dynamic data select from table is giving dump

rajasekhar_matukumalli3 — Sat, 24 Mar 2007 01:16:27 GMT

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