topic Re: CURSOR - FETCH Error in Application Development and Automation Discussions

CURSOR - FETCH Error

Former Member — Tue, 27 May 2008 21:37:27 GMT

Hi All,

I am new to ABAP and I have a situation and don't know why it is erroring out. Could anyone point it out for me.

DATA: BEGIN OF allper,

mbegda TYPE hrp1001-begda,

mendda TYPE hrp1001-endda,

mpos TYPE hrp1001-objid,

morg TYPE hrp1001-sobid,

mper TYPE hrp1001-sobid,

mmgr_id TYPE hrp1008-btrtl,

END OF allper.

DATA: itab_allper1 LIKE TABLE OF allper.

OPEN CURSOR WITH HOLD S_CURSOR FOR

SELECT DISTINCT a_{begda a}endda a_{objid a}sobid b_{sobid c}btrtl

FROM HRP1001 AS a

LEFT OUTER JOIN HRP1001 AS b ON a_{objid = b}objid AND

b~subty = 'A008' AND

b~sclas = 'P'

LEFT OUTER JOIN HRP1008 AS c ON a_{objid = c}objid

WHERE a~subty = 'A003' AND

a~sclas = 'O'.

FETCH NEXT CURSOR S_CURSOR

APPENDING CORRESPONDING FIELDS

OF TABLE itab_allper

PACKAGE SIZE 1000.

I get a shohrt dump in the FETCH statment. Looks to me some fields don't match? any clues?

Thx,

Alex.

Re: CURSOR - FETCH Error

Former Member — Tue, 27 May 2008 21:42:42 GMT

What does the short dumpo says.

The table is declared as itab_allper1 but your sentence says

FETCH NEXT CURSOR S_CURSOR

APPENDING CORRESPONDING FIELDS

OF TABLE itab_allper

PACKAGE SIZE 1000.

maybe that's the problem

Re: CURSOR - FETCH Error

Former Member — Tue, 27 May 2008 21:55:12 GMT

Ramiro,

Thank you for looking at this. I do have an internal table as itab_allper as well as itab_allper1 both are of the type allper structure.

Do you think the syntax and the way the variable declarations are correct? I am not sure of those..

Thankx again.

Alex.

Re: CURSOR - FETCH Error

Former Member — Tue, 27 May 2008 22:00:23 GMT

I don't see nothing wrong.

What does the dump says? Can you post it?

What I do find weird is the join on the same table

Re: CURSOR - FETCH Error

Former Member — Wed, 28 May 2008 12:45:11 GMT

Ramiro,

I found the cause for the ABEND because it was not on a development client, after copying to the correct client it does not abend but the cursor fetches only 0's. Is my declaration of structure, table, cursor and FETCH are all correct? Can I Fetch into an internal table?. I am concerned about the declaration part. The SQL is correct and it works right now when I have it with out cursor when I load it in to an internal table. Please let me know my validations are correct?

Thanks,

Alex.

Re: CURSOR - FETCH Error

Former Member — Mon, 02 Jun 2008 16:01:41 GMT

I solved the issue.

Re: CURSOR - FETCH Error

former_member206396 — Fri, 27 Jun 2008 15:21:00 GMT

HI Alex,

Can u tel me, how you have solved the issue? Even i facing the same problem...

Thanks

Ram