2019 Jan 08 9:20 AM
Hi, i need to learn how to do this.
Set($[$38.U_DRUMMATERIAL.0]|SQL:SELECT T0.U_DRUMMATERIAL AS U_DRUMMATERIAL FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0])
I am trying to set udf field a select query result but i can not do it.
If i try to set sap fields like ($[$38.163.0]) it is ok, it works.
Set($[$38.163.0]|SQL:SELECT T0.U_DRUMMATERIAL AS U_DRUMMATERIAL FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0])
what is wrong ?
thank you...
edit 1: I found somethings about what is wrong. when the number of the UDF name characters exeeds 10, the app gives an error.
I change the question. How could we increase the length of udf name characters for accepting the query ? Or must I decrease the length of udf field name ?