/scripts/ahub.form.attachments.js
0

variable in formatted search for sap b1 for hana

Jun 13, 2017 at 08:12 PM

32

avatar image
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"]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content