How to trigger the Process Chains in BW from ECC Surendra Reddy

Can we trigger Process Chains/Start a job in BW from ECC?.

We can trigger by using a simple Function Module in ECC.

When we need this Logic:

We need this kind of Programs/Logic, in the following cases….

After performing some job in ECC, and once it is executed successfully (after successful execution, ECC program will trigger the Event) then immediately you want to Load the data in BW system using Process Chains.

E.g.

• You have some dependencies in ECC after completing that tasks then you want to trigger some job in BW.
• You have Y/Z – Tables in ECC and it will update everyday by using one program, after the table is uploaded then immediately that program will trigger event then, Process chain will start in BW and data will load into InfoCube/DSO.

Scenario:

Every week (some times it will vary) Marketing executives will collect the sales information from dealers (the sales details between Dealer and Customers) and then using one ABAP program they will upload the data into Y/Z-Table in ECC. At the end of the upload program this Event program is inserted, so based on the data upload i.e. if it is success then the event will trigger and then Data Loads will starts in BW through Process Chain. So immediately the users will see the related reports in BW.

Zupload_Program.


IF Data upload is Success then
Raise Event through ZEVENT_ECC_BW Program.
Else
Send a mail to User “Error in Data upload ”.
Endif.

Steps:
Create Event in BW System using TCODE : SM62

Create a Program in SE38 in ECC:

Code:

In BW system, Goto RSPC and create Process Chain..and give Event name and Parameter Name...

And save the Process chain, Activate and Execute the Process Chain. If you don’t execute the process chain, it won’t trigger even though you execute the Program in ECC.

Then execute the Program in ECC and check the Log in BW in RSPC, your process chain will trigger.

Surendra Reddy Surendra Kumar Reddy Koduru, is a SAP BI consultant currently working with ITC Infotech India Ltd , Bangalore, India. He has over 4+ years of experience in various BW/BI implementation/support projects.