What is Update Behavior of End Routine?
The original blog 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 blog is for developers who are still using SAP BW and have now migrated to BW on HANA or BW4HANA.
Original blog / Reference: Update Behavior of End Routine in Transformations | SAP Blogs
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:
- 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.
- 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: Update Behavior of Fields in the End Routine (SAP Library - Business Intelligence)
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 SAP blogs to not miss more content: Maheshsingh Mony
Best regards, Mahesh
Okumaya devam et...