Open curser

[Former Member]

hi frds,

this is my statement, i have more than 5 lks record in BSEG table so i used open curser statement. but it still taking time to run.

give me any other help.

OPEN CURSOR WITH HOLD c for

SELECT BUKRS BELNR GJAHR BSCHL SHKZG GSBER WRBTR PSWSL VBELN

HKONT EBELN EBELP PROJK

FROM BSEG

WHERE BUKRS = COMPANY AND

GSBER = BUS_AREA AND

HKONT = GL.

FETCH NEXT CURSOR c INTO CORRESPONDING FIELDS OF TABLE IBSEG.

IF SY-SUBRC <> 0.

message 'No data Found for the selection ' type 'E'.

EXIT.

ENDIF.

CLOSE CURSOR C.

by

karthi.

[Former Member]

create an secondary index on

BUKRS,GSBER and HKONT.

Hope this might help you.

Regards,

Ramesh.

[former_member282823]

create an secondary index on

BUKRS,GSBER and HKONT.

Hope this might help you.

Regards,

Ramesh.

[Former Member]

how to create that.

guide me.

by

karthi.

[Former Member]

you BSEG in cluster table

you cant create a index.