topic Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select in Application Development and Automation Discussions

Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select

Fabian_Kegel — Thu, 29 Jun 2006 14:38:29 GMT

Hi,

I am working on a 4.6C system, where it is not possible to create dynamic tables with CREATE DATA lrt_table TYPE TABLE OF (strucname).

Instead of this, I am using the ALV function LVC_TABLE_CREATE, which creates table definitions in a subroutine pool.

Unfortunately, I get the short dump SAPSQL_SELECT_TAB_TOO_SMALL, when I create the table using the mentioned function module and selecting the data after that from the database.

SELECT * FROM (iv_table)

CLIENT SPECIFIED

INTO TABLE et_data UP TO iv_rows ROWS

WHERE (lt_where_condition).

The short dump says, that the internal table is only 208 bytes wide instead of 224.

This happens only for the table AUSP. Does anyone have a suggestion, why this happens? Maybe the floating point numbers in the transparent table AUSP?

Best regards,

Fabian

Re: Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select

RichHeilman — Thu, 29 Jun 2006 14:41:44 GMT

Please add INTO CORRESPONDING FIELDS OF.

INTO CORRESPONDING FIELDS OF TABLE et_data

Regards,

Rich HEilman

Re: Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select

Former Member — Thu, 29 Jun 2006 14:44:19 GMT

s we need to declare like

INTO CORRESPONDING FIELDS OF TABLE et_data

Regards,

ramesh.

Re: Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select

Former Member — Thu, 29 Jun 2006 14:46:16 GMT

SELECT * FROM (iv_table)
CLIENT SPECIFIED
INTO <b>corresponding fields of</b> TABLE et_data UP TO iv_rows ROWS WHERE (lt_where_condition).

Regards

vijay