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

[carlos_pintocamarero]

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.

Create Dialog Transaction:

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.

Global Data:

PBO-Modules:

PAI-Modules:

FORM-Routines:

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

Fill the Text Symbols and Selection Texts:

Step 3. The dynpro looks like this:

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).

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.

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.

Attributes:

Import:

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

Best regards,

Carlos

[aparnami]

Good document

[carlos_pintocamarero]

Thanks Arpan.

[sakthi_ss]

Nice documentation Carlos.

[carlos_pintocamarero]

Thanks Sakthitharan.

[former_member182470]

Great document.. :smile:

[anshu_lilhori]

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

Regards,

AL

[carlos_pintocamarero]

Many thanks suman.kchakravarthy and anshu.lilhori. :smile:

[Former Member]

Great good information

[Former Member]

Very useful Document.

Regards,

Sushant

[Former Member]

Nice Document.

Best Regards,

Chandra Sekhar.

[carlos_pintocamarero]

Thank you vinai.surepelli sushant.tiwarekar and chandra.sekhar89  for your comments!

Best regards,

Carlos

[former_member184884]

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

[former_member182470]

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

[RamanKorrapati]

Good presentation and easy to understand.Useful doc.

Nice work Carlos.Thanks for sharing with us

Raman

[Former Member]

Thanks much for document!!

Its really helpfull ....

[former_member184884]

Thanks a lot suman... :smile:

Cheers,

Harish

[carlos_pintocamarero]

Thanks for your answer suman.kchakravarthy. Indeed harish.a, 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

[carlos_pintocamarero]

Thanks for your valuable feedback kr.ch and kol.bobby!

[former_member184884]

Thanks carlos :smile: now i got full clarity :grin:

Cheers,

Harish

[former_member183012]

Hi Carlos,

Useful information thanks for sharing :smile: .

[carlos_pintocamarero]

Many thanks for your comment ganeshbothe. I really appreciate it!

[Former Member]

Hi Carlos,

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

Regards - Kumar

[carlos_pintocamarero]

Thanks a lot kumar.s19

[former_member207759]

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

[carlos_pintocamarero]

Thanks for your comment haradev.viswanadha :wink:

[Former Member]

Very nice :smile: .