Can you please guys advice me with the query for this , i have the error aggregate function not allowed when using SUM , the query in SAP HANA SQL
IF :object_type = '13' AND (:transaction_type='A' or :transaction_type='U')
THEN
BEGIN
update OINV set OINV."U_TotalDiscountLines" = SUM(INV1."PriceBefDi" - INV1."Price") from INV1 , OINV where INV1."DocEntry"=:list_of_cols_val_tab_del AND OINV."DocEntry"=:list_of_cols_val_tab_del ;
END;
END IF;