Hi all, I have been trying to do a query to bring the First Bin field but i have had mixed results, the query below for some of the Items in the Production Order brings the default Bin Location instead of the First One, any advice on the query to a...

Hi all, Is it possible to do a sql report with price increases and quantities of stock? If so what tables whould i look into? Or in alternative is there a SAP report that already provides that information? Best Regards, Daniel

Hi all, Can someone tell me the syntax to add an input paramter in a stored proc I have in HANA SQL and how to handle in the last query of it in a where clause? Best Regards, Daniel

Hi guys i built a query to mimic the fifo report in SAP b1, but i have wrong results for some items, can someone say what is wrong with the query below: select distinct t0."ItemCode" ,t0."itemName" ,t0."InDate" as "Admission Date" ,t0."MnfDate" ...

Hi all, I believe the sql code below is Hana sql can anyone help me convert it to sql standard? SELECT DISTINCT ((SELECT FLOOR(MIN((SELECT (SUM(SS2."OnHand")/S0."Quantity") FROM OITW SS2 WHERE SS2."ItemCode" = S0."Code" AND SS2."WhsCode" =...