B1 UP Validation Configuration Answered

Jakob Adema

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

Comments

2 comments

Date Votes
  • Comment author
    Thomas
    • Official comment

    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

  • Comment author
    Jakob Adema

    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

    0

Please sign in to leave a comment.