How to map values from EVM Extension Table in BW Profile?

[Former Member]

Hi,

In the BW Profile Configuration, at Events> Event Value Mapping only Source Table listed/allowed is 5, i.e. 'Event Message Header'. At Header value Mapping Source Table listed/allowed includes 9, i.e.'Event Handler Header Extension'. Similarly, is it possible to have 'Event Message Header Extension' available for Value Mapping?

Thanks in advance. Regards,

Prajakta

[former_member190756]

Hello Prajakta,

Event Message Header Extension is currently not possible with customizing.

If you need it in BW you have to create a PlugIn Function and map the fields with coding.

Best regards,

Steffen

[Former Member]

Thanks Steffen. We do not see EVM Extension being passed to plugin function interface. Could you please provide sample code for plugin to capture EVM Extension data? Thanks in advance.

best regards,

Prajakta

[former_member190756]

Hi Prajakta,

yes in the function interface it is not available. Only the Event Message Header table is there.

You can only do it by an own select on your Extension table with the Guids from the Event Message Header table. As this is an index access performance should be ok.

Best regards,

Steffen

[Former Member]

Thanks again Steffen. Select on EVM Extension table would work for INIT load but would delta load based on rule processing of an actual BW relevant event work as record in table is not committed yet?

best regards,

Prajakta

[former_member190756]

Yes,

this could be an issue. Some DB allow dirty reads but a better solution would be to create a function module in the same function group where later the BW plugin module lies and call it at the beginning of the rule set. Then you could store the data in the function group to inlcude that you need for your BW upload. In a normal Rule activity function the EVM Header extension should be available.

Best regards,

Steffen

[Former Member]

Hi Prajakta,

Can you try this below solution option:

1. Use existing fields or append event message extension table/fields in structure /SAPTRX/BWTFSEE.

2. Go to IMG -> Event Management -> SAP Business Information Warehouse Interface

Extraction structure for Event extraction to BIW -> Define Functions for SAP BW Interface -> Create your own data extraction function module -> copy event message extension table fields to your expected event structure /SAPTRX/BWTFSEE.

3. IMG -> Event Management -> SAP Business Information Warehouse Interface -> Define SAP BW Profiles -> SAP BW Profile Definition -> Select your BW profile -> Double click on Function PlugIn -> Assign newly created Activity FM.

Also, you need to consult with BW consultant and change in BW side as well.

We have done this solution for event message field mapping in expected event and no performance issue.

Regards

GGOPII