Error Incorrect Syntax near :=

If you are using an older version of SAP HANA that does not support STRING_AGG, you can use a recursive query to concatenate strings.

WITH BinConcat AS (
    SELECT
        A1."WhsCode",
        A1."ItemCode",
        A2."DistNumber" AS "BatchNum",
        CAST(A3."BinCode" AS VARCHAR(1000)) AS "BinCodes",
        ROW_NUMBER() OVER (PARTITION BY A1."WhsCode", A1."ItemCode", A2."DistNumber" ORDER BY A3."BinCode") AS RowNum
    FROM OBBQ A1
    INNER JOIN OBTN A2 ON A1."SnBMDAbs" = A2."AbsEntry"
    INNER JOIN OBIN A3 ON A3."WhsCode" = A1."WhsCode" AND A3."AbsEntry" = A1."BinAbs"
    WHERE A1."OnHandQty" > 0
),
RecursiveBin AS (
    SELECT
        "WhsCode",
        "ItemCode",
        "BatchNum",
        "BinCodes",
        RowNum
    FROM BinConcat
    WHERE RowNum = 1

    UNION ALL

    SELECT
        b."WhsCode",
        b."ItemCode",
        b."BatchNum",
        r."BinCodes" || ',' || b."BinCodes",
        b.RowNum
    FROM BinConcat b
    INNER JOIN RecursiveBin r
        ON b."WhsCode" = r."WhsCode"
       AND b."ItemCode" = r."ItemCode"
       AND b."BatchNum" = r."BatchNum"
       AND b.RowNum = r.RowNum + 1
)
SELECT
    A."WhsCode",
    A."ItemCode",
    A."Description",
    A."Uom",
    A."Batch No.",
    r."BinCodes" AS "Bin No"
FROM (
    SELECT
        T1."WhsCode",
        T1."ItemCode",
        MAX(T2."ItemName") AS "Description",
        MAX(T2."InvntryUom") AS "Uom",
        T1."BatchNum" AS "Batch No."
    FROM IBT1 T1
    LEFT JOIN OITM T2 ON T2."ItemCode" = T1."ItemCode"
    GROUP BY T1."WhsCode", T1."ItemCode", T1."BatchNum"
    HAVING SUM(CASE WHEN T1."Direction" = 0 THEN T1."Quantity" ELSE 0 END) -
           SUM(CASE WHEN T1."Direction" = 1 THEN T1."Quantity" ELSE 0 END) > 0
) A
LEFT JOIN RecursiveBin r
    ON A."WhsCode" = r."WhsCode"
   AND A."ItemCode" = r."ItemCode"
   AND A."Batch No." = r."BatchNum";

The syntax you are using for STUFF and string concatenation (FOR XML PATH('')) is specific to SQL Server and is not supported in SAP HANA.

SAP HANA does not have a direct equivalent to SQL Server's STUFF or FOR XML PATH(''). Instead, you need to use SAP HANA's string aggregation functions like STRING_AGG (introduced in HANA 2 SP04) or other workarounds.

SELECT
    A."WhsCode",
    A."ItemCode",
    A."Description",
    A."Uom",
    A."Batch No.",
    A."Bin No"
FROM (
    SELECT
        T1."WhsCode",
        T1."ItemCode",
        MAX(T2."ItemName") AS "Description",
        MAX(T2."InvntryUom") AS "Uom",
        T1."BatchNum" AS "Batch No.",
        STRING_AGG(A3."BinCode", ',') AS "Bin No"
    FROM IBT1 T1
    LEFT JOIN OITM T2 ON T2."ItemCode" = T1."ItemCode"
    LEFT JOIN OBBQ A1 ON A1."ItemCode" = T1."ItemCode" AND A1."WhsCode" = T1."WhsCode"
    LEFT JOIN OBTN A2 ON A1."SnBMDAbs" = A2."AbsEntry" AND A2."DistNumber" = T1."BatchNum"
    LEFT JOIN OBIN A3 ON A3."WhsCode" = A1."WhsCode" AND A3."AbsEntry" = A1."BinAbs"
    WHERE A1."OnHandQty" > 0
    GROUP BY T1."WhsCode", T1."ItemCode", T1."BatchNum"
    HAVING SUM(CASE WHEN T1."Direction" = 0 THEN T1."Quantity" ELSE 0 END) -
           SUM(CASE WHEN T1."Direction" = 1 THEN T1."Quantity" ELSE 0 END) > 0
) A;

• The STRING_AGG function is available starting from SAP HANA 2 SP04 . If you are using an older version of HANA, you will need to use a workaround with recursive queries or user-defined functions (UDFs) to achieve string aggregation.

Check this line:

(Select 'BinNo' := STUFF(( Select ','

replace with

(Select 'BinNo' = STUFF(( Select ','

The error you are encountering, "Incorrect Syntax near :=", is due to the fact that in SAP HANA SQL, the assignment operator is not ":=", but rather just "=".

Instead of:

(Select 'BinNo' := STUFF(( Select ',' + (A3."BinCode")...

It should be:

(Select 'BinNo' = STUFF(( Select ',' + (A3."BinCode")...

By making this adjustment and using the correct assignment operator "=", you should be able to resolve the syntax error in your query. Let me know if you need further assistance or clarification!