Skip to Content
avatar image
Former Member

SBO_SP_Transaction_Notification of SAP B1 Version for Hana

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers