You would like to calculate group durations in Event Management for combination of events like Shipment Start and Shipment End. These durations can then be extracted into BW using the data source 0SCEM_3.
Consider the following shipment in ECC. We are interested in capturing the planned and actual transit time for the shipment. Transit time will be defined as time elapsed between the events Shipment Start and Shipment End.
The Step By Step Solution
Execute the transaction SPRO in the Event Management system and then click on the SAP Reference IMG button. In the IMG open the node:
SAP Customization Implementation Guide > Event Management > SAP Business Information Warehouse Interface > Define SAP BW Profiles.
Now select the BW Profile that you are using for extracting Event Management data into BW and then double click on Group Duration Calculation in the left pane.
NOTE: BW Profile is used in customizing for mapping event handler information into extraction structures for the SAP Business Information Warehouse. The SAP BW profile is assigned to an event handler type to allow event handler data to be extracted.
In the pop-up box which appears use the Search Help button to select the group ID for which you would like to setup the duration calculation and hit enter. If no group ID exists then you will need to create one.
On the change screen hit the “New Entries” button for creating new duration calculation. Now make the appropriate selections for the entries in the Group Duration Calculation.
The selections that you make here are very important and requires a bit of an explanation here.
• The data source 0SCEM_3 provides us with fifteen duration fields, “DURATION_01” to “DURATION_15” for each group ID defined in the system.
• You have a free hand here to decide which field will represent which duration. In the screenshot above we have selected DURATION_01 to represent the planned duration between the events “DEPARTURE” and “Proof of Delivery (POD)”. Similarly DURATION_02 in our case represents the actual duration between the events “DEPARTURE” and “Proof of Delivery (POD)”.
• Src. Table will be the table from where these actual and planned values will be fetched. In our example it is the “Expected Events” table and it is numbered 4 in the system.
• TST1 and TST2 are the fields which store the planned and actual time type. In our example for DURATION_01 we have selected TST1 and TST2 both as “EVENT_EXP_DATE” (the planned time) and for DURATION_02 TST1 and TST2 both as “EVENT_DATE_UTC” (the actual time).
When you are done setting up the duration calculations save them and exit out of SPRO. Now we need to re-initialize the data source so that these calculations come into effect for historical records. On the SAP Easy Access screen, under the SAP Menu and drill down to the following node:
SAP Menu > Event Management > Administration > SAP Netweaver BI Upload > Intial Setup Tables
Here you can choose to delete the event handler header table, events table and the expected events group table. This is similar to deletion of the setup tables in ECC.
Now to refill the setup tables go to the following node in the SAP menu:
SAP Menu > Event Management > Administration > SAP Netweaver BI Upload > Initial Data upload to SAP Netweaver BI.
Make the appropriate selections here for the data that you wish to initialize. Make sure that the Event code is set to “0INT”.
With the above settings if you run the extractor 0SCEM_3 it should correctly calculate the group durations in Event Management as shown in the image below.