topic Re: Exception using dynamic tables in Application Development and Automation Discussions

Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 13:47:43 GMT

I'm using a dynamic table, but when i try to load data of pa0006 i got the following exception

In an SQL array select, the internal table used to hold the

selected records must be at least as wide as the database table

from which the records are being read.

In this particular case, the database table is 733 bytes wide,

but the internal table is only 727 bytes wide.

Any ideas?

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 13:54:24 GMT

Can you show your code?

Regards,

Ravi

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 14:12:14 GMT

data: gt_fieldcat type LVC_T_FCAT,

gt_table type ref to data.

data: ls_fieldcat type lvc_s_fcat.

DATA: MODIFICAR VALUE ''.

field-symbols: <gt_table> type table,

<wa_table> type any,

<dyn_PERNR>,

<DYN_SUBTY>,

<Dyn_objps>,

<dyn_sprps>,

<dyn_endda>,

<dyn_begda>,

<dyn_itxex>,

<dyn_seqnr>.

data: it_dfies type standard table of dfies,

wa_dfies type dfies,

lv_table type ddobjname value 'PA0016'.

*select single kotab from t681 into lv_table

where kvewe = 'A' and kotabnr = '005' and kappl = 'V'.

CALL FUNCTION 'DDIF_NAMETAB_GET'

EXPORTING

TABNAME = lv_table

TABLES

DFIES_TAB = it_dfies

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

ENDIF.

loop at it_dfies into wa_dfies.

ls_fieldcat-fieldname = wa_dfies-fieldname.

ls_fieldcat-inttype = wa_dfies-inttype.

ls_fieldcat-outputlen = wa_dfies-outputlen.

append ls_fieldcat to gt_fieldcat.

clear: wa_dfies.

endloop.

CALL METHOD cl_alv_table_create=>create_dynamic_table

EXPORTING

it_fieldcatalog = gt_fieldcat

IMPORTING

ep_table = gt_table.

ASSIGN gt_table->* TO <gt_table>.

SELECT *

FROM (lv_table)

into table <gt_table>.

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 14:14:15 GMT

Try the first example in this link:

http://www.saptechnical.com/Tutorials/ABAP/DynamicInternaltable/DynamicInternalTable.htm

Regards,

Ravi

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 16:26:46 GMT

I couldn't make it work. Has anyone checked the code???

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 16:29:52 GMT

the dynamic internal table created has x no of fields length.

when ur selecting data from table, the no of fields are exceeding than the x no of fields due to which it is unable to hold data.

Re: Exception using dynamic tables

Former Member — Tue, 17 Apr 2007 16:52:26 GMT

Did u check the code? Have you got any idea about how to solve this problem?

I would be very greatfull.