Skip to Content
0
Former Member
May 22, 2009 at 08:40 AM

FOR ALL ENTRIES IS possible in OPEN CURSOR and FETCH CURSOR?

981 Views

Hi Experts

below is my code statements is it possible to add FOR ALL ENTRIES statement?if yes plz help me how to add?

OPEN CURSOR WITH HOLD i_cursor_bsik FOR

SELECT mandt bukrs lifnr umsks umskz augdt augbl zuonr gjahr

belnr buzei monat shkzg gsber dmbtr wrbtr sgtxt hkont

vbund kostl xnegp prctr fkber bschl

FROM zbw_bkpf_bsik

CLIENT SPECIFIED

WHERE mandt = sy-mandt

AND lifnr IN r_lifnr

AND blart IN r_blart

AND ( ( zzcpudt = max_cpudt AND

zzcputm > max_cputm ) OR

( zzcpudt > max_cpudt ) ).

OPEN CURSOR WITH HOLD i_cursor_bsak FOR

SELECT mandt bukrs lifnr umsks umskz augdt augbl zuonr gjahr

belnr buzei monat shkzg gsber dmbtr wrbtr sgtxt hkont

vbund kostl xnegp prctr fkber zzcpudt zzcputm bschl

FROM zbw_bkpf_bsak

CLIENT SPECIFIED

WHERE mandt = sy-mandt

AND lifnr IN r_lifnr

AND blart IN r_blart

AND ( ( zzcpudt = max_cpudt AND

zzcputm > max_cputm ) OR

( zzcpudt > max_cpudt ) ) .

2ND STATEMENT(this point iam getting dump at production) but not in development

FETCH NEXT CURSOR i_cursor_bsik

APPENDING CORRESPONDING FIELDS OF TABLE lt_buffer_bsik

PACKAGE SIZE i_max_lines.

Thanks.