How to check if a particular field is changed using Validations?

[Former Member]

Hi All,

I want to check if couple of important fields are changed using validation

Eg: i want to check if description or Division or Material type fields are changed using validation so that i can use a Branch step in Workflow to trigger validation only when those fields are changed.

Thanks in Advance

Sharma.

[Former Member · Accepted solution]

Hi sharma,

when u start workflow checkout the record and through validation u can compare for desired fields if

checkout version is same as original version.

Eg. In expression

Division[checkedout]=Division[original]

this checked out and original field u will get in the list of fields .

Regards,

Neethu Joy

[Former Member · Accepted solution]

Hi Neethu,

are you saying that the expression should be as below?

[Is checkout version] = [original]Division.code

rgds,

Sharma.

[Former Member · Accepted solution]

Hello,

For MDM expression with check-out and check-in functionality

please follow the [Document|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed52509?QuickLink=index&overridelayout=true]

This PDF gives detailed description about Validation and Expression.

Regards,

Abhishek

[Former Member · Accepted solution]

Hi Abhishek,

I have gone through the document but when i run the validation is doesnot through any error.

I have created two workflows one for add and one for update, which are launched immediately.upon saving a new record or updating an existing record

I have created a validation for the Name field as below

IF([ Is New checkout ] ,Name1) to check if the record is a new one or the name has been updated.

but when i run the validation for the newly created record or for the existing record by updating the Name. it say tha the record has faild validation.

Can you please guide me where i am going wrong?

Thanks in Advance.

Sharma

[Former Member · Accepted solution]

Hello,

in your workflow have you mentioned to check in records, in the start step,

and similarly check out records in the stop step.

This is present in the properties when you open a workflow

Regards,

Abhishek

[Former Member · Accepted solution]

Hello Abhishek,

yes i have mentioned Check out records as YES in the start step and Record checkout option as Check in in the stop step

[Former Member · Accepted solution]

Hi Sharma,

In validation expression suppose if you want to checkout for Name Field then you need to write expression:

Name = [Original].Name

In this only Name will hold the checkout values.

Make this change you will get the result.

Regards,

Neethu Joy

[Former Member · Accepted solution]

Hello Neethu Joy

Yes i did get the result as per the below expression.

Name1 = Original. Name1

but if the above expression fulfills our needs then when and where do we use the below options

[is checkout version] , [is normal checkout], [is new checkout] and [ is merged checkout].

As per my understanding these options are used to differentiate between the record's old and new values.

And what is the correct syntax to be used for the same.

Rgds,

Sharma.

[Former Member · Accepted solution]

Hi Sharma,

These expressions is itself a complete function which will return either true or false value and will executed on the entire records:

is checkout version:Checked out version of record?

is normal checkout:Checkout of existing record?

is new checkout:Checkout of new record?

is merged checkout:Checkout of merged records?

Regards,

Neethu Joy

[Former Member · Accepted solution]

Hello Neethu Joy,

Thanks a lot for clarifying my queries.

Regards,

Sharma