Skip to Content
0
Dec 16, 2022 at 09:17 AM

Transection notification help SAP HANA 10.0

78 Views Last edit Dec 16, 2022 at 12:16 PM 5 rev

Hi folks,

need help to put validation .

when udf field is yes then related proerty should check.and tick while add /update bp master vendor.

IF :object_type = '2'  AND (:transaction_type='A' or :transaction_type='U') THEN	
select 
(
    SELECT 1
        FROM OCRD T0 
        
        WHERE T0."CardCode"=:list_of_cols_val_tab_del
        AND IFNULL(T0."U_MSME",'')='YES') AND T0."QryGroup64"='N'  INTO cnt FROM DUMMY;
IF :cnt > 0 THEN 
 		error := -4002;
        error_message := 'Please Select Property';
END IF;
END IF;

image.png

Attachments

image.png (54.8 kB)