variable in formatted search for sap b1 for hana

[Former Member]

Hello,

I'm trying to create FMS on SAP B1 4 hana and It does not seem to work. Im confident the problem is after the WHERE clause because when I fill a value instead of $[OITM."U_level1"], it works.

any advice.

select T0."Name" || ( select T0."Name" FROM "@ITEM_CODES" T0 where T0."U_Level"='L2' AND T0."Code"=$[OITM."U_level2"] ) || ( select T0."Name" FROM "@ITEM_CODES" T0 where T0."U_Level"='L3' AND T0."Code"=$[OITM."U_Level3"] ) || ( select T0."Name" FROM "@ITEM_CODES" T0 where T0."U_Level"='L4' AND T0."Code"=$[OITM."U_Level4"] ) from "@ITEM_CODES" T0 where T0."U_Level"='L1' AND T0."Code"=$[OITM."U_level1"]