Skip to Content
Jun 03, 2022 at 09:20 AM

How to write stored procedure which can check value in database table not in SAP form?

165 Views Last edit Jun 13, 2022 at 03:58 AM 3 rev

Hi all,

I want to create stored procedure which will block to update document (UDO) which has value of 'Closed' in field (ComboBox) of U_status. I tried to do that but as it seems it is checking value ('Closed') of the form not value of database table. It is blocking before update value to 'Closed' in the table.

Below is what I tried to do

if @object_type='PWQ' AND @transaction_type in ('U')<br>BEGIN<br>SELECT @error=999, @error_message='Document is closed, you cannot change anything' FROM [@PWQ] WHERE [@PWQ].DocEntry=@list_of_cols_val_tab_del<br>AND( exists (SELECT top 1 T.U_status FROM [@PWQ] as T WHERE T.DocEntry=[@PWQ].DocEntry AND ISNULL(T.U_status,'')='Closed')<br>AND<br>ISNULL([@PWQ].Canceled,'')='N'<br>) <br>SELECT @error, @error_message<br>END 

Please anyone can help me