In this document I will comment how to trigger BW process chain from ECC, for example to update a particular report. I hope it can help to someone who has to perform this process in the future.

According to the requirements, the user – after executing certain transactions in ECC – should be able to trigger a load in BW and see the reports updated with this new information.

To do this, we will create an ad-hoc transaction in ECC (ZBW_UPDATE_REPORTS) with an associated program (ZBW_TRIGGER_EVENT). A dynpro where the user will be able to select the business area he wants to update will be displayed in this transaction. After selecting this area, “Execute” button is pressed and the program is launched. This program calls a BW function (ZFM_TRIGGER_EVENT) passing as parameter the event associated with the selected area. Finally, this function will be responsible for triggering the event (ZECC_EVE01) and starting to run the appropriate load chain (TR_DT).

ECC SIDE

Step 1. Create the transaction in SE93. This transaction will have associated the program that we will create in the next step.

/wp-content/uploads/2014/02/1_377790.png

/wp-content/uploads/2014/02/2_377791.png

Create Dialog Transaction:

/wp-content/uploads/2014/02/3_377861.png

Step 2. Create an executable program in t-code SE38. In this transaction the user will select the Area of reports that he wants to update.

/wp-content/uploads/2014/02/4_377862.png

Global Data:

/wp-content/uploads/2014/02/5_377863.png

PBO-Modules:

/wp-content/uploads/2014/02/6_377864.png

PAI-Modules:

/wp-content/uploads/2014/02/7_377865.png

FORM-Routines:

/wp-content/uploads/2014/02/8_377866.png

Note: SLBWD200 is the name of our SAP BW system.

Fill the Text Symbols and Selection Texts:

/wp-content/uploads/2014/02/9_377867.png

/wp-content/uploads/2014/02/10_377868.png

Step 3. The dynpro looks like this:

/wp-content/uploads/2014/02/11_377869.png

BW SIDE

Step 4. Create an event in tcode SM64 for each of the different loads we want throw. In our case: ZECC_EVE01 (for Treasury area) and ZECC_EVE02 (for Consolidation area).

/wp-content/uploads/2014/02/12_377870.png

Step 5. We associate to each chain the corresponding event. In our example we plan the  load chain of Treasury (TR_DT) to run after event: ZECC_EVE01.

/wp-content/uploads/2014/02/13_377871.png

Note: it is important to plan and activate the chain and check “Periodic job”.

Step 6. Create the function module (in our case ZFM_TRIGGER_EVENT). This FM must be enabled as Remote-Enabled and it will call the standard function  BP_EVENT_RAISE which will raise the event received as parameter.

/wp-content/uploads/2014/02/14_377872.png

Attributes:

/wp-content/uploads/2014/02/attributes_378729.jpg

Import:

/wp-content/uploads/2014/02/15_377873.png

Step 7. Finally, just after executing the transaction from ECC side, the BW Process Chain is thrown:

/wp-content/uploads/2014/02/16_377874.png

/wp-content/uploads/2014/02/17_377875.png

Best regards,

Carlos

To report this post you need to login first.

26 Comments

You must be Logged on to comment or reply to a post.

  1. Harish Allachervu

    Hi Carlos,

    very exceptional blog but i’ve few concerns here it will be great if you can address those.

    actually you told by placing the events in the BW PC we can trigger the chain from ECC is it really works 😕 because as per my knowledge BW & ECC are entirely different systems though even there is RFC connection in between 2 systems.

    i am not able to understand one thing here is ℹ event the one which plays pivotal in triggering BW process chain!!! if yes can you please give me bit info on that.

    Thanks & Regards,

    Harish

    (0) 
    1. Suman Chakravarthy K

      Hi Harish,

      Off the record, but I just want to clarify your doubt. An ABAP program has to be created in ECC system which can take RFC destination and Event name as input parameters. It should internally call another Function Module and pass the event name. This Fm must be enabled as remote enabled and it will call standard BP_EVENT_RAISE. This will finally raise an Event in BW system(has to be created in BW in SM64). This is how both systems interact with each other.

      Regards,

      Suman

      (0) 

Leave a Reply