Error in the module RSQL accessing the database interface

[Former Member]

HI all ,

i have written query like this,

SELECT single stlnr FROM stpo INTO w_stlnr WHERE idnrk IN r_matnr.

assume that they are 10 part number are there when date retrival from this query upto 9 part number i am not getting run time error

10 part number i am getting runtime error in PRD , ITS working fine in QLT for same variant.

Error analysis

The system attempted to open a cursor for a SELECT or OPEN CURSOR

statement but all 16 cursors were already in use.

The statement that failed accesses table "STPO ".

The erroneous statement accesses table "STPO ".

please guide me how to solve this promblem.

Regards ,

Santosh

Edited by: santosh jajur on Jul 20, 2009 3:50 PM

[former_member194669]

Try to change this way

data : begin of i_stlnr occurs 0.
data : stlnr like stpo-stlnr.
data : end of i_stlnr.

SELECT stlnr FROM stpo INTO table i_stlnr WHERE idnrk IN r_matnr.
if sy-subrc eq 0.
  read table i_stlnr index 1.
  move i_stlnr-stlnr to w_stlnr.
endif.

a®