Skip to Content

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.


Choose button3  Update Behavior of Fields in the End Routine and select the options.









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.
  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 report this post you need to login first.


You must be Logged on to comment or reply to a post.

    1. Maheshsingh Mony Post author
      Hi Purvang,

      Sorry for the delayed response.

      Please note that you can only see the button on the transformation to a DSO or masterdata and not cube’s and this button appears only after you write an END Routine.

      Hope it helps.


  1. Pravin Karkhanis

    Mahesh, very good blog.

    I found this feature present in the BW 7.3 also

    But interestingly this feature does not exists in BW 7.3 powered by HANA

    In BW 7.3 powered by HANA, this simply means “If key fields are filled in the end routine, these fields are also filled in the DataStore object. This occurs regardless of the settings for the field list of the end routine.” Even if you have no assignment for any field in transformation, it will be initialized with the initial value that means it will overwrite the existing value set by some other transformation updating same DSO.

    Do you know any method to restore this feature?

  2. Maheshsingh Mony Post author

    Hello Pravin,

    I dont think we can revert this feature in BW 7.3 powered by HANA.  For some reason i like the new feature rather than the “Update behavour in end routine” button feature. here it allows you to select the fileds that you want to overwrite. where else in BI 7.0 you need to make the fileds as constant that you need to overwrite and write a code in the endroutine to change only those fileds (whcih are marked as constant). or else write the code in the end routine and select All target fileds.




Leave a Reply