topic Re: GET & Open Cursor in Application Development and Automation Discussions

GET & Open Cursor

Former Member — Mon, 30 May 2005 09:41:20 GMT

Hello All,

Currently i am using LDBs KDF and following is the code :

OPEN CURSOR WITH HOLD DB_CURSOR FOR <----

GET BKPF FIELDS

BUKRS "Company code

BELNR "Document No.

GJAHR "FY

BLDAT "DocumentDate

BUDAT "PostingDate

MONAT "FiscalPeriod

XBLNR. "Reference Document No.

CHECK ( BKPF-MONAT IN S_MONAT AND BKPF-BLDAT IN S_BLDAT ).

DO.

FETCH NEXT CURSOR DB_CURSOR

APPENDING TABLE T_BKPF PACKAGE SIZE 10000.

IF SY-SUBRC NE 0.

CLOSE CURSOR DB_CURSOR.

EXIT.

ENDIF.

ENDDO.

COMMIT WORK.

I receive the message that SELECT is required for OPEN CURSOR.

I cannot use the SELECT as for Accessing the Archived data LDB had to be used and GET statements are used.

Can you please correct/propose new code for the above.

Thankyou,

- PSK

Re: GET & Open Cursor

jayanthi_jayaraman — Mon, 30 May 2005 09:58:53 GMT

Hi,

Check this link.

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm

Re: GET & Open Cursor

Former Member — Mon, 30 May 2005 10:13:39 GMT

Hi,

GET

Event keyword that defines event blocks for reporting events.

Syntax

GET <node> [FIELDS <f1> <f 2>...].

Only occurs in executable programs. When the logical database has passed a line of the node <node> to the program, the runtime environment triggers the GET event, and the corresponding event block is executed. The FIELDS addition allows you to specify explicitly the columns of the node that the logical database should retrieve.

CLOSE CURSOR

Closes a database cursor.

Syntax

CLOSE CURSOR <c>.

Closes a cursor opened using the OPEN CURSOR statement.

OPEN CURSOR

Opens a database cursor.

Syntax

OPEN CURSOR [WITH HOLD] <c> FOR SELECT <result>

FROM <source>

[WHERE <condition>]

[GROUP BY <fields>]

[HAVING <cond>]

[ORDER BY <fields>].

Opens a cursor <c> with type CURSOR for a SELECT statement. All of the clauses of the SELECT statement apart from the INTO clause can be used. The INTO clause is set in the FETCH statement. If you use the WITH HOLD addition, the cursor is not closed when a database commit occurs.

Thanks & Regards,

Judith.