This video tutorial is about the end routine using HANA script in BW4HANA. The presenter explains the scenario where they have a source structure with certain fields and a target structure with additional fields. The goal is to derive the values for the unmapped fields in the target structure using an end routine.

Key topics covered in the video session:

1. Recap of Previous Session: The presenter recaps a scenario where they have a source structure with certain fields and a target structure with additional fields. The goal is to derive the values for the unmapped fields in the target structure using an end routine.
2. Understanding the Scenario: The presenter explains the scenario in detail, including the source structure, the target structure, and the fields that need to be derived.
3. Writing the End Routine: The presenter begins writing the end routine using HANA scripting. They explain that the end routine is used to derive new columns and to derive unmapped columns using business logic.
4. Using the ‘Using’ Statement: The presenter explains how to use the ‘using’ statement to add lookup tables that will be used in the logic.
5. Writing the Logic: The presenter writes the logic to derive the values for the unmapped fields in the target structure. They explain how to use various functions, such as ‘left’ and ‘substring’, to derive the values.
6. Activating the End Routine: After writing the logic, the presenter activates the end routine and then activates the transformation. They then execute the DTP (Data Transfer Process).
7. Checking the Results: The presenter checks the results in the SAP GUI and confirms that the unmapped fields in the target structure have been successfully derived.
8. Debugging the End Routine: The presenter explains how to debug the end routine. They show how to set a breakpoint and how to execute the DTP to stop at the breakpoint.