Short dump SAPSQL_SELECT_TAB_TOO_SMALL when using dynamic table in select

[Fabian_Kegel]

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

[RichHeilman]

Please add INTO CORRESPONDING FIELDS OF.

INTO CORRESPONDING FIELDS OF TABLE et_data

Regards,

Rich HEilman

[Former Member]

s we need to declare like

INTO CORRESPONDING FIELDS OF TABLE et_data

Regards,

ramesh.

[Former Member]

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