Skip to Content
Author's profile photo Estrella Santacruz

SAP BW 7.3: How to trigger BW process chains from ECC

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

Assigned Tags

      26 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ARPAN PARNAMI
      ARPAN PARNAMI

      Good document

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks Arpan.

      Author's profile photo Sakthi S
      Sakthi S

      Nice documentation Carlos.

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks Sakthitharan.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Great document.. 🙂

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Nice document..With step by step walk through,Thanks for sharing it.

      Regards,

      AL

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Many thanks Suman Chakravarthy K and Anshu Lilhori. 🙂

      Author's profile photo Former Member
      Former Member

      Great good information

      Author's profile photo Former Member
      Former Member

      Very useful Document.

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member

      Nice Document.

      Best Regards,

      Chandra Sekhar.

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thank you vinai surepelli Sushant Tiwarekar and Chandra Sekhar  for your comments!

      Best regards,

      Carlos

      Author's profile photo Harish Allachervu
      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

      Author's profile photo Suman Chakravarthy K
      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

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Thanks a lot suman... 🙂

      Cheers,

      Harish

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks for your answer Suman Chakravarthy K. Indeed Harish Allachervu, I forgot to mention that the BW FM must be enabled as Remote-Enabled (I just added this to the document). And the ECC program will call this function passing as parameter the BW event has to throw. Thank you both Suman and Harish!

      Best regards,

      Carlos

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Thanks carlos 🙂 now i got full clarity 😀

      Cheers,

      Harish

      Author's profile photo CH Raman
      CH Raman

      Good presentation and easy to understand.Useful doc.

      Nice work Carlos.Thanks for sharing with us

      Raman

      Author's profile photo Former Member
      Former Member

      Thanks much for document!!

      Its really helpfull ....

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks for your valuable feedback CH Raman and Rohith D!

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Carlos,

      Useful information thanks for sharing 🙂 .

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Many thanks for your comment Ganesh Bothe. I really appreciate it!

      Author's profile photo Former Member
      Former Member

      Hi Carlos,

      Nice document with detailed steps ➕ screens as well. Well arranged ℹ for BW.

      Regards - Kumar

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks a lot Kumar S

      Author's profile photo Haradev Viswanadha
      Haradev Viswanadha

      Very useful document. I had the same requirement and it is working superbly.. 🙂 Thanks a lot

      Author's profile photo Carlos Pinto Camarero
      Carlos Pinto Camarero
      Blog Post Author

      Thanks for your comment Haradev Viswanadha 😉

      Author's profile photo Former Member
      Former Member

      Very nice 🙂 .