on 09-23-2022 1:36 PM
Hello
With SBO_SP_TRANSACTION_NOTIFICATION
I want to sum the quantity all items (INV1) and put them in an UDF (header level OINV) directly with HANA
Im Using this query
IF :object_type = '13' AND (:transaction_type='A' or :transaction_type='U')
THEN
BEGIN
update OINV set OINV."U_TotalQuantities" = sum(INV1."Quantity") from INV1 , OINV where INV1."DocEntry"=:list_of_cols_val_tab_del AND OINV."DocEntry"=:list_of_cols_val_tab_del ;
END;
END IF;
But i have this error , aggregate function not allowed , can you please help ?
I changed the clause where by having , still have the error , can you please give me the correct code ? thanks
Hi Samba,
Please check this modification on your update statement:
UPDATE OINV
Set OINV."U_TotalQuantities" = (Select (sum(INV1."Quantity"))
From INV1 inner join OINV on INV1."DocEntry"=:OINV."DocEntry"
Where OINV."DocEntry"=:list_of_cols_val_tab_del)
Thank you,Aziz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
9 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.