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
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>
P_SRFC = p_srfc <b>" BW Destination</b>
pr_var = pr_var.
delete from ztab_rqmt1.
delete from ZTAB_5MNTH.
delete from ZTAB_ODUE1.
delete from ZTAB_QTRLY.
delete from ZTAB_RQMT2.
delete from ZTAB_RQMT3.
CALL FUNCTION 'RSPC_ABAP_FINISH'
DESTINATION p_srfc <b>" BW Destination</b>
I_VARIANT = pr_var <b>"Process Variant</b>
ALREADY_FINISHED = 1
OTHERS = 2
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