need to create a process chain which triggers R/3 events

[Former Member]

Hi all,

I need to create a process chain which has all the R/3 events in it. I need to run the user exit first to populate my data into a custom created DB Table.then i need to extract that data into BW using generic extraction.Then i need to load it into my ODS.After sucessful loading of my ODS i need to delete my custom created table...... I have no clue how to proceed... plz help me on this issue....

regards

sairam phani

[Former Member]

Hi sairam,

Plz look at the following sap note 135637.

Symptom

The data transfer into the Business Information Warehouse (BW) is generally started from BW and not from the connected R/3 System.

Additional key words

Pull, Push, Business Information Warehouse, Event, BW, data transfer, background processing, scheduler

Cause and prerequisites

BW works according to what is known as the pull principle that is the data transfer into BW is started from within BW with the help of the background processing scheduler.

Solution

With a small trick, you can also start the data transfer from within OLTP (push principle). The following three steps are required to do this:

(1) Create an event in the BW system

(2) Create a function module in the BW system

(3) Create an ABAP/4 report in the R/3 System

(1) Create an event in the BW system

-

---

Define a system event (for example SAP_BW_TRIGGER) with Transaction SM62.

(2) Create a function module in the BW system

-

---

Create a function module (for example Z_BW_EVENT_RAISE) with the help of Transaction SE37. For the source code refer to the attachment of this note.

(3) Create an ABAP/4 report in the R/3 System

-

---

Create an ABAP/4 report in the OLTP system (for example Z_BW_EVENT_RAISE) with Transaction SE38.

Then schedule the data transfer in the scheduler of BW. To do this select the function background processing and as start time value, the function after event. Enter the newly defined event; field Parameter stays empty. If the job is to be scheduled periodically, activate the function execute job periodically.

Thanks,

Sekhar Reddy.