buenas tardes solicito su ayuda por favor para pasar esta consulta que la tengo en el QUERY MANAGER de SAP a CE_FUCNTIONS en la opciones de CALCULATION_VIEW / SQL SCRIPT / GRAPHICAL debido a que por la cantidad de join que maneja cuando la realizo me genra errores y no se como cuadrarla para que me funcione.
SELECT T2."ItemCode" AS "NOMBRE REF", T2."ItemName" AS "DESCRIPCION REF",
sum(T1."Quantity") as "CANTIDAD DE EMPAQUE", T2."U_UNID_PRESENT" AS "UNIDAD PRESENTACION",
SUM(T1."Quantity"*T2."U_UNID_PRESENT") AS "TOTAL UNIDADES", T3."ItmsGrpNam" as "GRUPO"
FROM OINV T0 INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode"
INNER JOIN OITB T3 ON T2."ItmsGrpCod" = T3."ItmsGrpCod"
WHERE T0."CANCELED" = 'N' AND T0."DocDate" >=[%0] and T0."DocDate" <=[%1]
GROUP BY T2."ItemName", T2."ItemCode", T2."U_UNID_PRESENT",T3."ItmsGrpNam"
UNION
SELECT T2."ItemCode" AS "NOMBRE REF", T2."ItemName" AS "DESCRIPCION REF",
sum(-T1."Quantity") as "CANTIDAD DE EMPAQUE", T2."U_UNID_PRESENT" AS "UNIDAD PRESENTACION",
SUM(-T1."Quantity"*(-T2."U_UNID_PRESENT")) AS "TOTAL UNIDADES", T3."ItmsGrpNam" as "GRUPO"
FROM ORIN T0 INNER JOIN RIN1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode"
INNER JOIN OITB T3 ON T2."ItmsGrpCod" = T3."ItmsGrpCod"
WHERE T0."CANCELED" = 'N' AND T0."DocDate" >=[%0] and T0."DocDate" <=[%1]
GROUP BY T2."ItemName", T2."ItemCode", T2."U_UNID_PRESENT",T3."ItmsGrpNam"
muchas gracias amigos