SAP BW "Update Behavior of End Routine" in Transformations

What Is "Update Behavior of End Routine"?

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 not Infocube’s.

This button appears only after you write an END Routine in a BW Transformation. Also, this feature does not exist 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 will 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) that were loaded exclusively from the initial source.
2. 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 the 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.

Please note: This blog is for developers who are still using SAP BW and have not migrated to BW on HANA or BW4HANA.

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

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