Hello,
I have created a Process Chain(BW) which has a ABAP Process.
The BW program calls a FM in R/3 and deletes table data in R/3.
The R/3 FM Module in turns calls the BW FM RSPC_ABAP_FINISH to Mark the ABAP Process as Green (after data is deleted from tables).
Here is the code snippets
<b>BW FM</b>
REPORT ZCMC47_DELETE.
parameter: p_rfc type rfcdes-rfcdest,
p_srfc type rfcdes-rfcdest,
PR_VAR type variant.
CALL FUNCTION 'ZCFM_MC47_DELETE'
destination p_rfc <b>" R/3 Destination</b>
EXPORTING
P_SRFC = p_srfc <b>" BW Destination</b>
pr_var = pr_var.
<b>R/3 FM</b>
FUNCTION ZCFM_MC47_DELETE.
delete from ztab_rqmt1.
commit work.
delete from ZTAB_5MNTH.
commit work.
delete from ZTAB_ODUE1.
commit work.
delete from ZTAB_QTRLY.
commit work.
delete from ZTAB_RQMT2.
commit work.
delete from ZTAB_RQMT3.
commit work.
CALL FUNCTION 'RSPC_ABAP_FINISH'
DESTINATION p_srfc <b>" BW Destination</b>
EXPORTING
I_VARIANT = pr_var <b>"Process Variant</b>
EXCEPTIONS
ALREADY_FINISHED = 1
OTHERS = 2
ENDFUNCTION.
But some how background job BI_ABAP_PROCESS is stuck in the RFC Call, and is not returning back to BW from R/3.
Is there any problem with my coding please guide ?
Please help as I'm Stuck
Thanks,
Dutta