topic Re: Runtime error .. in Application Development and Automation Discussions

Runtime error ..

former_member192432 — Thu, 10 Dec 2009 06:45:00 GMT

Hi,

I am getting error message as "Error in module RSQL of the database interface. The SQL statement generated from the SAP Open SQL statement violates a restriction imposed by the underlying database system of the ABAP system." for below select query..

SELECT PSPNR entryno from zps_plan into TABLE gt_entryno1

WHERE pspnr IN r_pspnr

and rundate = sy-datum

and Vbukrs = p_vbukr

and stufe IN r_stufe .

sort gt_entryno1 by pspnr .

please tell me how to solve the problem .

Regards

chetan

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Dec 10, 2009 9:34 AM

Re: Runtime error ..

nirajgadre — Thu, 10 Dec 2009 06:51:02 GMT

Hi,

check the field sequence and data type of the selection and the internal table is same or not

Re: Runtime error ..

Former Member — Thu, 10 Dec 2009 11:32:58 GMT

Please check if the internal table has the same field sequence and same number of fields as you use in select query.

Or use

into corresponding fields of.

Regard,

Lalit Mohan Gupta.

Re: Runtime error ..

former_member192432 — Thu, 10 Dec 2009 12:00:26 GMT

hi i used for all entries instead of RANGES , the problem is solved

Re: Runtime error ..

Former Member — Thu, 10 Dec 2009 12:01:30 GMT

Hi Chetan,

This error occurs due to inconsistency in the physical definition at the DB level - usual reason being a problem with the table extents for the DB Table in consideration.

Please approach the concerned Basis team with the Table name and the Dump - the issue should be resolved.

Following this, the select will work fine.