Second standard item as UDF in SAP FSM cloud - Material screen

[Dhanush-d]

Hello Folks!

Hope you all are doing good.

I wanted to know if there is a possibility in FSM where we could display standard field which is available in the query DTPO as a UDF in Material screen.

As we know we already have an item as standard in material screenconfig, I am trying to add another item_2 as a UDF and trying to display a value which is already available in cloud as standard, but the value can only be fetched by Joining multiple tables.\

The scenario in short - We are selecting a material to return back to warehouse from an installed location. Suppose A is the material which we are going to install with serial number 1 and then if we choose defect serial number which we are going to take back - we will only see the defct serial number / the equipment as standard, but this serial / equipment has an item number which we are trying to display as a UDF.

Please let me know if this is possible or any alternate thoughts in mind to do the same.

Attaching images and query which I am trying to do for your reference:

SELECT e.serialNumber, i.code FROM Equipment e JOIN Item i on i.id = e.item

e.serial number is the one which I will choose in the FSM app material screen as defect serial number / equipment in standard.

I want to display the i.code field with the help of UDF if it is possible.

ScreenConfig which I tried creating an UDF with visible expression as the above query. Please help me / correct me as I see the expression is not valid for the config.

Any pointers and help are much appreciated, Thanks in Advance!

Best Regards

Dhanush