Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted Search in SAP B1 Hana

Dear Expert,

                      I had applied the following formatted search in the UDO form.Its working fine if I give the constant date parameter.The Moment I applied the Date parameter to be selected from the UDF(U_Date the result is coming Out zero.

SELECT sum (T0."InQty")- sum(T0."OutQty") FROM OINM T0 WHERE T0."ItemCode" = $[@STATIONROW.U_Product] and T0."Warehouse" = $[@STATIONROW.U_STATION]

and TO_DATE(T0."DocDate") < (select TO_DATE($[@STATIONROW.U_DATE]) from dummy)

Please suggest the solution.

regards,

PankajK

Former Member
Former Member replied

Hi Sir,

try below query

SELECT sum (T0."InQty")- sum(T0."OutQty") FROM OINM T0 WHERE T0."ItemCode" = $[@STATIONROW.U_Product] and T0."Warehouse" = $[@STATIONROW.U_STATION]

and TO_DATE(T0."DocDate") < (select TO_DATE($[@STATIONROW.U_DATE.DATE]) from dummy)

regards,

Raviraj

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question