Selecting batch number based on FEFO in the Alternate stock selection in Picking flow

I am going to show how you can automatically select next batch number from the batch list via customization framework. 

You can find more information about the technology on the url below:

Customize Flows on Mobile Client

Start the Mobile Client in customization mode and navigate to the screen where you can select the batch number in the Alternate stock steps.

Enable the customization mode by clicking on the gear icon, click on the screen and then the customization window will appear. Go to the Events tab and set the name of the query and press Save button.
I am going to use:  PickingAlternateStockNextBatchByFEFO

The query will appear in group PMX_CLIENT_CUSTOMIZATION_USER_QUERIES
Open the query in SAP and define the following query.

I am selecting the sctock from the PMX_FREE_STOCK view.

I joined OITM table to the view based on the ItemCode field, because I am going to use the U_PMX_CUDE field to filter the data. This UDF contains the itemcode itemname and the barcode.

I joined the PMX_ITRI table, because it contains the batch number data.

SELECT
TOP 1
PMX_ITRI.BatchNumber as "txtItem",
'btnForward' as "DefaultButton", 
0 as "DefaultButtonClickTimeout"
FROM
PMX_FREE_STOCK 
left join OITM on PMX_FREE_STOCK.ItemCode = OITM.ItemCode
left join PMX_ITRI on PMX_ITRI.InternalKey = PMX_FREE_STOCK.ItemTransactionalInfoKey
WHERE 
OITM.U_PMX_CUDE = '$[Prev2.lblProductDescription]'
AND PMX_ITRI.BestBeforeDate > CURRENT_TIMESTAMP
ORDER BY
PMX_ITRI.BestBeforeDate

Start the Mobile Client without customization mode to see the result. Customization doesn't work in customization mode.