HANA sql condition conversion

Answered

lorenzo pelati

• August 27, 2019 14:38

Hi expert

i want to use sql condition on sap hana. i want to add an UF that it block add journal entry if Actype on OACT is equal to 'E'

 

DECLARE Tipo_conto as varchar(20)

SELECT T0."ActType" into Tipo_conto
FROM OACT T0 WHERE T0."AcctCode" = $[$76.1.0]

SELECT CASE
WHEN :Tipo_conto = 'E'
THEN
(SELECT 'Blocco_per_conto_tipo_economico' from DUMMY )
END

which is my error in sql condition?

thank you

 

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • February 17, 2020 20:16

  Hello Lorenzo,

  I'm no HANA expert but I seem to me that the problem is the variable. I created a query in my system and here is the result in SQL and after converting it using the SQL HANA conversion tool by Boyum IT. It should work.

   

  

   

  

   

   

  SELECT CASE
  WHEN ((SELECT T0."ActType" FROM "OACT" T0 WHERE T0."AcctCode" = $[$76.1.0]) = 'E')
  THEN
  (
  SELECT 'BOYUM' FROM DUMMY
  )
  END FROM Dummy

Please sign in to leave a comment.