Skip to Content
0

SBO_SP_Transaction_Notification of SAP B1 Version for Hana

Aug 16, 2017 at 10:46 AM

74

avatar image
Former Member

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers