Skip to Content
0

Itemcode cannot be deleted from production order except authorize users

Mar 07, 2017 at 11:55 AM

15

avatar image

i was added one udf in ousr if U_prd_a is 'y' than the user is authorized to deleted the same from production order as well as in BOM .need the SP_transaction code for the same .

https://archive.sap.com/discussions/thread/3491550  tried to use code from this post
IF @transaction_type IN ('A', 'U')AND @object_type in ('202')

BEGIN

If exists (SELECT T0.DocEntry FROM owor T0

inner join itt1 t2 on t2.father = T0.Itemcode

where t0.DocEntry =@list_of_cols_val_tab_del AND t2.code not in (SELECT T1.itemcode FROM wor1 t1 where t0.docentry = t1.docentry))

Begin

SET @error = '202'

SET @error_message = N'order can not be added if not match with BOM.'

End

END
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers