SPTN in HANA

[former_member202778]

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

[Abdul · Accepted solution]

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

then (Select COUNT(*)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)

IF :cnt > 0

THEN error := 2301;

error_message := 'Choose correct whse';

END IF;

END IF;

[Abdul]

Hi Please close the thread if you issue is resolved.