Runtime error ..

[former_member192432]

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

[nirajgadre]

Hi,

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

[Former Member]

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.

[former_member192432]

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

[Former Member]

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.