topic Re: Error in select - dynamic table in Application Development and Automation Discussions

Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 13:30:04 GMT

Im creating a dynamic internal table and fetching values and displaying.

select * from (p_table) into corresponding fields of table <dyn_table>.

This statement works well for small tables as PRHI , PRPS , PROJ etc

when i trying exceuting the same for EKKO,BSEG and other bigger tables it gives short dump whereas small tables it works fine.

Why is this happening

can you suggest some way to rectify it ?

Thanks in advance

Swarna

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 13:35:34 GMT

Can you tell what is the dump saying?

Regards,

Atish

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 14:05:23 GMT

The dump says

DBIF_RSQL_INVALID_RSQL - >Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a form that the target field can accept .

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 14:08:40 GMT

HI,

I think there is something wrong in your code for dynamic table creation. just see in the debugging if dynamic internal table is of same type of DB table.

Regards,

Atish

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 14:12:20 GMT

well since you dont get a overflow of your tablespaces, the problem got to be at the declaration of your table <dyn_table>. seems like he wants to move a value into a field which is not big enough to take the value.

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 14:12:25 GMT

When i debug im getting the fields in my dynamic internal table for all tables.

Also only for tables with lots of columns asLIPS, EKKO ,EKPO it is throwing error.

The same code works fine for tables like t001,t005,prhi,prps,proj tables which have a fewer columns compared to the previous mentioned tables.

Is there any fix on the max number of columns ?

Re: Error in select - dynamic table

Former Member — Tue, 04 Mar 2008 17:11:34 GMT

Why are you using INTO CORRESPONDING FIELDS??? If your dynamic table holds the structure of the table, you should do it like this...


  SELECT *
  INTO TABLE <ROW>
  FROM (MY_TAB).

Also, refer to my weblog...It might help you out...

[Taking good care of Z Data|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3340] [original link is broken] [original link is broken] [original link is broken];

Greetings,

Blag.

Re: Error in select - dynamic table

Former Member — Fri, 07 Mar 2008 09:28:00 GMT

Thank you so much. I took a bit of help from your blog ..Taking good care of the Z data and found out i missed out in the declaration part (I committed a stupid Careless mistake).

Thanks

Swarna