Skip to Content
0
Sep 11, 2023 at 07:43 AM

How to replace in HANA query SAP Business One

80 Views Last edit Sep 11, 2023 at 08:00 AM 3 rev

Dear all,

How to use Replace into HANA query.

I want to remove special character and want to include [space] on that.

OR

I need to remove ['s] from below query.

SELECT 	A."DocEntry",
"ItemCode",
"Dscription",
"Quantity",
"Price",
"LineTotal",
"U_UNE_MRP",
"U_UNE_SLIFE",
"U_UNE_AGEN",
-- replace("unitMsr", "'"," ") ,
REPLACE("'" in "unitMsr" with ' ' OCCURRENCE ALL ) as "test",
"U_DLDT",
"LineNum",
"ShipDate",
"OpenCreQty",
B."DocNum",
A."WhsCode"
FROM POR1 A
iNNER JOIN OPOR B
ON A."DocEntry"=B."DocEntry"
WHERE B."DocDate"='20230830'
--WHERE B."CardCode"='VP00174'

Regards,

Nikunj