https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589051#M864161 <HTML><HEAD></HEAD><BODY><P>you BSEG in cluster table</P><P></P><P>you cant create a index.</P></BODY></HTML> Tue, 18 Mar 2008 12:46:27 GMT Former Member 2008-03-18T12:46:27Z https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589048#M864158 <HTML><HEAD></HEAD><BODY><P>hi frds,</P><P>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.</P><P></P><P>give me any other help.</P><P></P><P> OPEN CURSOR WITH HOLD c for</P><P> SELECT BUKRS BELNR GJAHR BSCHL SHKZG GSBER WRBTR PSWSL VBELN</P><P> HKONT EBELN EBELP PROJK</P><P> FROM BSEG</P><P> WHERE BUKRS = COMPANY AND</P><P> GSBER = BUS_AREA AND</P><P> HKONT = GL.</P><P></P><P> FETCH NEXT CURSOR c INTO CORRESPONDING FIELDS OF TABLE IBSEG.</P><P></P><P> IF SY-SUBRC &lt;&gt; 0.</P><P> message 'No data Found for the selection ' type 'E'.</P><P> EXIT.</P><P> ENDIF.</P><P> CLOSE CURSOR C.</P><P></P><P>by</P><P>karthi.</P></BODY></HTML> Tue, 18 Mar 2008 11:56:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589048#M864158 Former Member 2008-03-18T11:56:43Z https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589049#M864159 <HTML><HEAD></HEAD><BODY><P>create an secondary index on </P><P> BUKRS,GSBER and HKONT.</P><P></P><P>Hope this might help you.</P><P></P><P>Regards,</P><P>Ramesh.</P></BODY></HTML> Tue, 18 Mar 2008 12:00:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589049#M864159 Former Member 2008-03-18T12:00:57Z https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589050#M864160 <HTML><HEAD></HEAD><BODY><P>how to create that.</P><P></P><P>guide me.</P><P>by</P><P>karthi.</P></BODY></HTML> Tue, 18 Mar 2008 12:44:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589050#M864160 Former Member 2008-03-18T12:44:03Z https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589051#M864161 <HTML><HEAD></HEAD><BODY><P>you BSEG in cluster table</P><P></P><P>you cant create a index.</P></BODY></HTML> Tue, 18 Mar 2008 12:46:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-curser/m-p/3589051#M864161 Former Member 2008-03-18T12:46:27Z