Validation of 2 fields in the same table line

[Former Member]

Dear all,

I'm trying to create a simple validation.

Check

ANLC-AFABE = '05' AND ANLC-ANSWL = '0.00'

The check should be:

if the valuation area is = 05 and IT'S asset value transaction is different than ZERO, then an error should occur.

however the error message is raised either if there is zero or other values in the ANLC-ANSWL (asset value transaction) field.

Maybe the program is not considering that in ANLC table, the check should occur for both fields in same line (val. area 05 & ANSWL = 0,00)

can you please guide on the validation?

thank you

[Former Member]

I think If you want value otherthan zero you need to use ANLC-ANSWL <> '0.00 ( instead of equal to).

[Former Member]

hello,

thank you for the reply. I did try that, with no positive result.

I think the problem is that the program does not consider the valuation area & the asset value transaction as the same line in ANLC table