I want to put restriction in Delivery Document using SBO_SP_TransactionNotification, for that I am using the following query
if @transaction_type='A' and @object_type='15'
IF EXISTS (select * from ODLN T1 INNER JOIN DLN1 T0 ON T1.DocEntry=T0.DocEntry where (T0.[U_LOTNO] > T0.Quantity) and T1.[DocNum]=@list_of_cols_val_tab_del)
SET @error_message='Quantity should not exceed Available Quantity'
Please correct me, where Iam doing wrong
Thanks & Regards