Skip to Content
0
Former Member
Aug 16, 2017 at 10:46 AM

SBO_SP_Transaction_Notification of SAP B1 Version for Hana

771 Views

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