cancel
Showing results for 
Search instead for 
Did you mean: 

Bloque facturas proveedores UUID

former_member817449
Discoverer
0 Kudos
Hello, good afternoon, I request your collaboration to know why my validation of the UUID that is already in sap hana is not working for me, I am doing it in Transaction Notification,
my code is as follows:
IF :object_type = '18' AND (:transaction_type='A' or :transaction_type='U')
 then

select "EDocNum" from OPCH where "EDocNum" = "EDocNum" AND "DocEntry" =:list_of_cols_val_tab_del;
IF :UUID2 = (SELECT COUNT("EDocNum") FROM OPCH WHERE "EDocNum" = :UUID2 HAVING COUNT("EDocNum")> '1')
then
 error := 100;
 error_message := 'Existe UUID de Proveedor duplicado';
 
end if;
end if;
I get an error (-1) Stored procedure SBO_SP_TransactionNotification has to return a value

Accepted Solutions (0)

Answers (0)