Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Validations test

Hello Folks,

i just started working with Validations..

when i have gone through the syntax of IF then stattement,

But i am struggling to implement it after i see some examples in Complete reference 7.1 like IF(F1, F2)

F1 is true ->f2

f1 is false ->NULL

Can anyone explain with a practical real time condition

Thanks in Advance.

KR

John

Tags:
Former Member
Former Member replied

Hi John,

IF(IS_NULL(NAME),TRUE)

According to this Expression it tells when there is null value for field NAME then returns TRUE which mean Success but you didn't tell what should be done if this field NAME has value, that's why you are getting Success for Every record.

In other words, if you give expression as IF(IS_NULL(NAME),FALSE), it will gives always FALSE as you havent tell what should be happen if it has value.

So you need to tell bth TRUE and FALSE in your Expression to accurately make use of Validations.

IF(IS_NULL(NAME),TRUE, FALSE)

Here, it gives TRUE (Success) for 3 rd record only,

And other 3 records which have values in them should be FALSE as you given in Exprssion if it has no value return TRUE(Success) and if it has Value Return FALSE

Hope you got my point !!

Regards,

Mandeep Saini

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question