SQL error in the database when accessing a table

[Former Member]

Hi All,

I have seen that there are threads already for this error. But my case seems different . So I am posting again. Please do provide your valuable inputs.

In my object, I have written a Modify statement on a <custom table> FROM TABLE <ITAB>.

But this results in a dump saying 'SQL error in the database when accessing a table'.

If I remove a value 11700500000.00 from a field of type CURR(Length 13 - Decimals 2) in the internal table used in the MODIFY Statement, we dont have the dump.

Why is this happening ? Please help!!

Thanks a lot!

Edited by: Dagny on Mar 18, 2011 11:39 AM

[Former Member]

Check the data type of Quantity field in db table and internal table

[Former Member]

HI Dagny,

This may be because you would have missed out the currency key field for the currency field. Try to modify the table along with the currency key.

Thanks and regards,

Sri Hari Anand Kumar

[Former Member]

Hi Dagny,

The value is over flowing into the filed of data base, the length 13 includes the 2 decimal values aswell, if you need a bigger length for field u need to declare a 15, 2 decimals data type.

R,

Srini

[Former Member]

Hi Dagny,

Please change your data type as BKK_BAL. This data element is of type CURR 23. THis will not dump now.

Thanks,

Guru

[Former Member]

Hi Folks,

I have already tried changing the data type to a bigger length. But still the DUMP continues to occur.

Also, please note that the question of the data-types not matching between the internal table and Database table does not occur as the internal table is declared as TYPE STANDARD TABLE OF <Database table>.

Please help!

[Former Member]

closed

[Former Member]

Per forum rules, would you please share the solution?

Rob