Please help me on that For few tax code when select into document then all type of document series not allowed to punch. Few document series only allow to make transaction.
Need to develop Transaction notification. Please help me on this. SBO HANA Version.
I have developed this transaction notification but it's not working.
IF :object_type = n'19' AND (:transaction_type = n'A' OR :transaction_type = n'U')
SELECT (SELECT T0."DocEntry" FROM ORPC T0 INNER JOIN RPC1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN RPC12 T2 T0."DocEntry" = T2."DocEntry"
Where T1."DocEntry" = T2."DocEntry"
And (T1."TaxCode",'IGST@5') = (T0."Series",'601')
AND T0."DocEntry" = @list_of_cols_val_tab_del)
INTO temp_var_0 FROM DUMMY; IF IFNULL(:temp_var_0,'') !=''
SELECT 2 INTO Error FROM DUMMY;
SELECT 'Please select tax code as !!! ' INTO error_message FROM DUMMY;