07-26-2007 10:12 PM
Hi ,
I am getting dump "DBIF_RSQL_INVALID_CURSOR " when i am trying to update bapi inside select endselect.
can any one tell me alternate logic. i am dealing with 100,00,000 data.
I cant do commit bapi after loop as all data in bapi will not get commited.
My logic is some what like
select * from but000
INTO TABLE it_gpart PACKAGE SIZE 10000.
CALL FUNCTION 'BAPI_CTRACCONTRACTACCOUNT_CLR'.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
wait = 'X'.
endselect.
07-26-2007 10:18 PM
You cannot issue a commit in between a SELECT and ENDSELECT loop. That is why you are getting this error.
07-26-2007 10:18 PM
You cannot issue a commit in between a SELECT and ENDSELECT loop. That is why you are getting this error.
07-26-2007 10:30 PM
I know why this error is coming ,but i have such requirement. i am looking for altenate solution
07-26-2007 10:32 PM
Can you not do a commit after the ENDSELECT? That way you will either commit all or rollback all.
07-26-2007 10:41 PM
no i cant do so each time i will call bapi i will get differenct data .
07-26-2007 11:06 PM
Can you bring all the contents of the table into an internal table and then do BAPI call and commit?