How to design a UBE based on a SQL query?

Hi Team,

Recently we got a requirement from client, where they want to create a UBE which is based on View of (F4211 / F42119 / F4101 tables). The requirement is to create a UBE which selects the records / or implements the same functionality of the SQL query which is mentioned below. The records which are fetched finally needs to be output to a flat file. How to approach the solution for this? Where can we write the logic for this SQL statement?(under which section/event of UBE? Any assistance would be of great help.

SQL Query:

select rtrim(sdlitm) as sdlitm,cal_yyyy, cal_mth_nbr ,cal_dd,sum(sdsoqs/10000) as sdsoqs