on 08-16-2017 11:46 AM
Hello Experts
I need to convert this transaction notification from SQL to Hana the aim of this transaction notification to block the user from delivering any items from any warehouse do not belong to him
If @object_type=15 and @transaction_type IN ('U' , 'A')
Begin
IF Exists (SELECT WhsCode FROM DLN1
INNER JOIN ODLN ON DLN1.DocEntry=ODLN.DocEntry
WHERE WhsCode IN (02,01) AND ODLN.UserSign=42 and ODLN.DocEntry=@list_of_cols_val_tab_del)
Begin
set @error = -500
set @error_message ='Choose from your WHS'
end
end
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.