SAP BW Update Behavior of End Routine in Transformations

[maheshsinghmony]

What is Update Behavior of End Routine?

The original article was posted by me back in 2010 which can no longer be edited and its missing all the screenshots. I am re-posting it here with some minor updates.

This article is for developers who are still using SAP BW and have now migrated to BW on HANA or BW4HANA.

Original blog / Reference: https://blogs.sap.com/2010/09/24/update-behavior-of-end-routine-in-transformations/

Using this function, you can change the update behavior of fields in the end routine (of a BW Transformation) of a standard DataStore object or master data attribute and and not Infocube's.

This button appears only after you write an END Routine in a BW Transformation. Also this feature does not exists in BW 7.3 powered by HANA.

Where exactly is the “Update Behavior of End Routine” Button

As displayed in the below image you can find the Update Behavior of Fields in the End Routine button next to the End Routine button in your Transformation.

When you click on the button you would get the below two options as displayed in the image below.

Click on Update Behavior of Fields in the End Routine and select the options.

Prerequisites

You can only set this indicator for standard DataStore objects and master data attributes.

Significance of the “Update Behavior of End Routine” Button

Using this function, you can change the update behavior of fields in the end routine of a standard Data Store object or master data attribute.

Depending on the scenario in question, it may be useful to update all target fields or only target fields with an active rule:

1. Only Target Fields with Active Rule (Default)This setting is especially useful if various fields of a data record have to be filled from different sources. In this case, updating all the fields would overwrite the fields (with the initial value of each data field) which were loaded exclusively from the initial source.

1. All Target Fields (independent of Active Rules)
   This setting is always useful for filling fields in the end routine. If this setting is chosen, the filled fields in the end routine are retained and are not lost.

Caution: If only the key fields are updated for master data attributes,

all the attributes are initialized anyway, whatever the settings described here. For more information, see SAP Note 1096307.

Example for better Understanding

The following two charts show, using a simple scenario, how the two setting variants for the update behavior affect the way a data record in a standard DataStore object is refreshed. Here a target field is filled using an end routine.

Only Target Fields with Active Rule (Default)

All Target Fields (independent of Active Rules)

To Summarize the use of Update behavior of fields in end routine completely depends on your requirements as to how you would like to see the data populated in the DSO after the end-routine in Transformation is executed.`

I hope I was able to  give you a little insight into how the Update Behavior of fields in End Routine in Transformations works.

References & Related Links: https://help.sap.com/doc/saphelp_scm700_ehp01/7.0.1/en-US/48/6e375c0b104e6de10000000a421937/content....

I would love to hear back suggestions, feedback and questions that you might have. Please do share the article with your Team members, Colleagues and Friends working in SAP and don’t forget to like and share the article and follow me on SAP to not miss more content: maheshsinghmony

Best regards,

Mahesh.