Transaction Notification

[former_member693344]

Hi All,

We have a UDF on Production Order, We want only specific user can change it. I have applied control using OWOR and AWOR. But it fails in case of Receipt from Production. How can I know whether Production Order is updated directly by Production order or Receipt from production. My code is as below.

IF :object_type= '202' and (:transaction_type = 'U') AND :error = 0 THEN

SELECT COUNT(*),MAX(IFNULL(m."U_DF",0)) INTO cnt,deci1 FROM OWOR m

WHERE m."DocEntry" = :list_of_cols_val_tab_del AND m."UserSign2" NOT IN (111,354,362);

IF cnt > 0 then

SELECT IFNULL(m."U_DF",0) INTO deci2 FROM AWOR m

WHERE m."DocEntry" = :list_of_cols_val_tab_del AND m."LogInstanc" = (SELECT MAX(d."LogInstanc") FROM AWOR d

WHERE d."DocEntry" = :list_of_cols_val_tab_del);

IF(:deci1 <> :deci2) THEN

error := 202;

error_message := 'You are not allowed to change Delivered To Folding field';

End IF;

End IF;

END IF;