Skip to Content
-1
Jun 12, 2018 at 07:40 AM

SPTN in HANA

114 Views Last edit Jun 12, 2018 at 02:57 PM 2 rev

Hi Everyone,

Please help me to convert below procedure to HANA

if @object_type = '67' and @transaction_type in ('A')

begin

if exists(Select distinct 'Error' from WTR1 W0 inner join OWTR W1 on W0.DocEntry = W1.DocEntry where W0.WhsCode<>'01' and W1.UserSign = 1 and W1.DocEntry = @list_of_cols_val_tab_del)

begin

SET @error = 1001

SET @error_message = 'Choose correct whse'

end

end

Regards