Triggering Process chain after completion of ECC Delta Extraction Job

Scenario:

This scenario of triggering process chains after completion source system (ECC) delta Extraction job would be very useful when we are using FI-CA, Logistics (MCEX) related extractions. These extractions require updating delta queue first before the BW delta job run and we cannot also predict when would be the Delta queue update job finishes.

In this regards, please follow the guide below for detail steps of triggering of process chain after source system delta queue job completion.

Detailed Steps

STEP 1>

Create an event in BW in SM64, t-code.

STEP 2>

Create a remote function module (FM), SE37 in BW and provide the event name created in STEP 1.

I use method “RAISE” in class “CL_BATCH_EVENT”.

For Ex: Remote FM for Invoice.

ABAP Code for the Remote Function Module:

DATA: eventid TYPE TBTCJOB–eventid.

eventid = ‘ZFICA_INVOICE_PC_TRIGGER’.

CALL METHOD cl_batch_event=>raise
EXPORTING
i_eventid                      = eventid
*    i_eventparm                    =
*    i_server                       =
*    i_ignore_incorrect_server      = ‘X’
* EXCEPTIONS
*    excpt_raise_failed             = 1
*    excpt_server_accepts_no_events = 2
*    excpt_raise_forbidden          = 3
*    excpt_unknown_event            = 4
*    excpt_no_authority             = 5
*    others                         = 6
.
IF sy–subrc <> 0.
* Implement suitable error handling here
ENDIF.
WRITE: sy–subrc.

STEP 3>

Create a program (SE38) in source system (ECC) to call the function module created in STEP 2.

ABAP Code for the program to trigger FM:

REPORT ZCC_BI_TRIGGER_PROCESS_CHAIN.

PARAMETERS: FM(40) TYPE C,
TARGET(10) TYPE C.

CALL FUNCTION FM DESTINATION TARGET.

Above program is a general program to call any of the remote FM in target system (BW) from source system (ECC). As this is a program used to call FMs in remote system, we must mention target system. So, there is a parameter for Target has to be placed in program.

STEP 4>

Create a variant (SE38) for the program created in STEP 3.

For Ex: Based on the example above, let’s take invoice extraction. So, using FM created for invoice in STEP 2, created a variant.

STEP 5>

After creation of Event, remote FM to trigger the event and the program to call FM. Now, it’s time to create a variant for respective Extraction program.

Find the respective program to schedule the ECC Delta Extraction job and create a variant as per your requirement.

For Ex:

Kindly go through my document for Scheduling FI-CA related Delta Extraction for FI-CA related extraction.

In case of FI-CA Invoice Extraction, we use the program “RFKK_MA_SCHEDULER” and I created a variant name as “BW_INV_EXTR”.

Save the variant values and attributes.

STEP 6>

Now, every require object created main event start which is crucial.

In this step, go to SM36, create a batch job as below.

Create a job, name as per your project naming convention.

b. Press Enter, then select “ABAP Program” and provide the Name of your extraction program and Variant which you have created in STEP 5.

For ex: “RFKK_MA_SCHEDULER”, for FI-CA related extraction and variant created earlier.

User name as “ALEREMOTE” or “BWREMOTE” or any other background user.

Then click SAVE. It looks as below.

STEP 7>

Now, step for triggering remote FM inturn triggering respective procress chain program has to be added.

Go to STEP menu, then click on create.

b. Now, after selecting the ABAP program in the next screen, provide the Name as the program name which is created to trigger the remote FM and variant for your specfic FM triggering as per STEP 3 & 4.