B1 UP Validation Configuration

Answered

Jakob Adema

• October 13, 2015 14:14

Dear all,

I'm trying to make SAP validate if the (bank)account of the BP is filled when adding or updating a AP invoice. This will make our payment process more efficient.

I'm having difficulties with the SQL which I have to add as SQL Condition in the B1 UP Validation Configuration (the action which start the UF). I have till now:

IF (SELECT T0."DflAccount" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]) = ''
BEGIN
SELECT 'SHOW_ERROR' FOR BROWSE
END

When I test the validation, SAP gives me a syntax error of the SQL. I'm doing something wrong, but I don't know what.

Could you help me?

Thanks in advance!

Greets,
Jakob

Vote

0

• Official comment

  

  Thomas

  • October 20, 2015 11:30

  Hi Jakob,

  Loose the quotes " and it will work. You should always check in the management studio what's wrong if you're having problems with the SQL syntax.

  Best regards,

  Thomas
• 

  Jakob Adema

  • October 22, 2015 13:23

  Hi THomas,

  Thanks for your reply. It had to be:

  SELECT 'SHOW_ERROR' FROM DUMMY WHERE $[OCRD.DflAccount] = '' AND $[OCRD.CardCode] = $[$4.0.0]

  SAP HANA doesn't handle the IF-statement well, so we had to solve this with the statement above.

  Greeds,
  Jakob

Please sign in to leave a comment.