Getting dump while displaying invoice.

[Former Member]

Hi Friends,

I have created a credit memo and went to create a invoice and saved the invoice. But when I went to display that invoice I am getting a dump saying that

"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 "VBFA ".

The erroneous statement accesses table "VBFA ".

Dump Analysis:

012420 FORM vorgaenger_sonstiges TABLES i_vorgaenger STRUCTURE x_vorgaenger

012430 USING i_beleg i_position i_typ

012440 i_ebene i_mandant.

012450 * VBFA lesen

012460 IF i_position IS INITIAL.

-

---

> SELECT *

012480 FROM vbfa

012490 WHERE vbeln = i_beleg

012500 AND vbtyp_n = i_typ

012510 AND stufe = 0

012520 ORDER BY PRIMARY KEY.

012530 vbfa-stufe = i_ebene.

012540 vbfa-matnr+17 = 'X'.

012550 PERFORM vorgaenger_aufnehmen.

012560 PERFORM vorgaenger_ermitteln USING i_mandant

012570 vbfa_tab-vbelv

012580 vbfa_tab-posnv

012590 vbfa_tab-vbtyp_v

012600 vbfa_tab-logsys

012610 i_ebene.

012620 ENDSELECT.

Can any one guide me what is the error.

Please it s urgent.

Regards,

Niki.

[naveen_inuganti2]

Hi...,

You attempting OPEN CURSOR..,

So while using OPEN CURSOR syntax remember one thing....,only a limited number of database cursors can be open at the same time.

So to solve your problem you hav to close other OPEN CURSORS... with CLOSE CURSOR...statement,

> CLOSE CURSOR <cursor variable>.

Since only a limited number of database cursors can be open simultaneously, you should close all database cursors no longer required.

Try this..,

And Plz get back here with the way, you solved the problem.

Thanks,

Naveen.I

[Former Member]

Hi naveen,

Thanks for ur replay.

But naveen i dont know where i want to close this cursor.

Can u please eloberate.

Regards.

niki.

[Former Member]

Can any one help me.