SAP HANA Error: not a GROUP BY expression: must be in group by clause.

[former_member587347]

Hello;

I have written this code :

CREATE COLUMN TABLE "temp0" AS(SELECT IGN1."ItemCode", IGN1."WhsCode", MAX("EvalSystem") AS "evalsystem", coalesce(CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OBTN."AbsEntry" END, CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OSRN."AbsEntry" END, 0) AS "SysNumber", MAX(ign1."Dscription") AS "dsc", SUM(coalesce(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN itl1."Quantity" ELSE 0 END, CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ign1."Quantity" ELSE 0 END)) AS "sumquantity", SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ign1."Quantity" ELSE 0 END) AS "sumall", SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ign1."Quantity" ELSE 0 END * OITM."BWeight1") AS "bweightsum", SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ign1."Quantity" ELSE 0 END * OITM."IWeight1") AS "iweightsum", SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ign1."Quantity" ELSE 0 END * OITM."SWeight1") AS "sweightsum" FROM OIGN INNER JOIN IGN1 ON OIGN."DocEntry" = IGN1."DocEntry" INNER JOIN OITM ON OITM."ItemCode" = IGN1."ItemCode" INNER JOIN OWHS ON OWHS."WhsCode" = IGN1."WhsCode" LEFT OUTER JOIN OITL ON OITL."DocType" = OIGN."ObjType" AND OITL."DocEntry" = OIGN."DocEntry" AND IGN1."LineNum" = OITL."DocLine" LEFT OUTER JOIN ITL1 ON OITL."LogEntry" = ITL1."LogEntry" LEFT OUTER JOIN OSRN ON ITL1."ItemCode" = OSRN."ItemCode" AND ITL1."SysNumber" = OSRN."SysNumber" AND OSRN."CostTotal" > 0 LEFT OUTER JOIN OBTN ON OBTN."ItemCode" = ITL1."ItemCode" AND OBTN."SysNumber" = ITL1."SysNumber" AND OBTN."Quantity" > 0 INNER JOIN oitb ON oitb."ItmsGrpCod" = oitm."ItmsGrpCod" WHERE OIGN."DocDate" >= begindate AND OIGN."DocDate" <= enddate AND IFNULL(IGN1."BaseLine", -1) = -1 AND IGN1."BaseType" = 202 AND IFNULL(oitb."U_isProdCost", 'N') <> 'Y' GROUP BY IGN1."ItemCode", IGN1."WhsCode", coalesce(CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OBTN."AbsEntry" END, CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OSRN."AbsEntry" END, '') UNION ALL SELECT IGE1."ItemCode", IGE1."WhsCode", MAX("EvalSystem") AS "evalsystem", coalesce(CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OBTN."AbsEntry" END, CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OSRN."AbsEntry" END, ''), MAX(IGE1."Dscription") AS "dsc", -SUM(coalesce(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN itl1."Quantity" ELSE 0 END, CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ige1."Quantity" ELSE 0 END)) AS "sumquantity", SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ige1."Quantity" ELSE 0 END) AS "sumall", -SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ige1."Quantity" ELSE 0 END * OITM."BWeight1") AS "bweightsum", -SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ige1."Quantity" ELSE 0 END * OITM."IWeight1") AS "iweightsum", -SUM(CASE WHEN IFNULL(OWHS."U_isProdCostQty", 'N') = 'N' THEN ige1."Quantity" ELSE 0 END * OITM."SWeight1") AS "sweightsum" FROM OIGE INNER JOIN IGE1 ON OIGE."DocEntry" = IGE1."DocEntry" INNER JOIN OITM ON OITM."ItemCode" = IGE1."ItemCode" INNER JOIN OWHS ON OWHS."WhsCode" = IGE1."WhsCode" LEFT OUTER JOIN OITL ON OITL."DocType" = OIGE."ObjType" AND OITL."DocEntry" = OIGE."DocEntry" AND IGE1."LineNum" = OITL."DocLine" LEFT OUTER JOIN ITL1 ON OITL."LogEntry" = ITL1."LogEntry" LEFT OUTER JOIN OSRN ON ITL1."ItemCode" = OSRN."ItemCode" AND ITL1."SysNumber" = OSRN."SysNumber" AND OSRN."CostTotal" > 0 LEFT OUTER JOIN OBTN ON OBTN."ItemCode" = ITL1."ItemCode" AND OBTN."SysNumber" = ITL1."SysNumber" AND OBTN."Quantity" > 0 WHERE IFNULL(IGE1."BaseLine", -1) = -1 AND IGE1."BaseType" = 202 AND OIGE."DocDate" >= begindate AND OIGE."DocDate" <= enddate GROUP BY IGE1."ItemCode", IGE1."WhsCode", coalesce(CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OBTN."AbsEntry" END, CASE WHEN "EvalSystem" = 'A' THEN '' ELSE OSRN."AbsEntry" END, ''));

But I have this error:

SSAP DBTech JDBC: [277]: not a GROUP BY expression: 'OBTN.AbsEntry' must be in group by clause.: line 16 col 158 (at pos 602)

How can I solve this error

Thanks