How to block BOM Updation by SP_TN

[MD1]

Dear All,

please help on this

SQL/HANA

--------Updation Block BOM

IF :object_Type = '66' AND :Transaction_Type ='U' THEN 

   Declare BOMM_0 integer;   

SELECT

(SELECT "Code"

FROM OITT B

WHERE (B."Qauntity" <>

    (SELECT B."Qauntity"

    FROM AITT C

    WHERE (B."LogInstac" =

        (SELECT COUNT(C."LogInstac") AS "Expr1"

        FROM AITM A

        WHERE (B."Code" = C."Code"))) AND (C."Code" = B."Code"))) and B."UserSign2">0 AND

     (B."Code" = :list_of_cols_val_tab_del)) INTO BOMM_0 FROM DUMMY;

IF :BOMM_0 > 0 THEN

error := 466;

           error_message := 'Mandatory Field Not Update (Statandard Batch Size (XQauntity)*)';

       END IF;

       END IF;

[frank_wang6]

The history table for BOM is AITT, not AITM.

Frank

[MD1]

okay ,

[MD1]

---------Updation Block BOM

IF :object_Type = '66' AND :Transaction_Type ='U' THEN 

   Declare BOMM_0 integer;   

SELECT

(SELECT B."Code"

FROM OITT B

WHERE (B."Qauntity" <>

    (SELECT B."Qauntity"

    FROM AITT C

    WHERE (B."LogInstac" =

        (SELECT COUNT(C."LogInstac") AS "Expr1"

        FROM AITT A

        WHERE (B."Code" = C."Code"))) AND (C."Code" = B."Code"))) and B."UserSign2">0 AND

     (B."Code" = :list_of_cols_val_tab_del)) INTO BOMM_0 FROM DUMMY;

IF :BOMM_0 > 0 THEN

error := 466;

           error_message := 'Mandatory Field Not Update (Statandard Batch Size (XQauntity)*)';

       END IF;

       END IF;

[MD1]