MDM Data Manager Validation Examples

[Former Member]

Hello.

I am brand new to MDM and currently need to create many different validations with dependant data in Data Manager (such as: IWhen creating a new customer, if the Company Code is xxxx than the user must choose US for the country).

I have lots of different kinds of validations to do and since I've never done them before I'm a bit lost. I've read lots of blogs and I understand the concept, but does anyone know of any good reference guides or websites with examples of different validation formulas so I can get some kind of a direction? The only one's I've found are for things such as ISBN numbers on books, which doesn't help me any.

I will definatley award points to anyone that can help me!

Thanks,

Nichole

[Former Member · Accepted solution]

Richa,

Thanks for those links but they look like Validations for ECC/R3. I am looking for Validation Formula examples specifically for Data Manager in MDM

[Former Member · Accepted solution]

Hi,

Firstly you need to know about basics for the same, you first check Reference Guide for MDM Data Manager.

MDM Expressions

Expression Dialog

Expressions, Expression Operators and

Expression Functions between pages 220 to 240 it will give you more clear idea about writing Validations and Assignments.

You can see one of my examples in following thread:

it will give you more clear information.

Even if you still have doubts and problem in building Validation Expressions just post a new thread your problem is welcome.

Rewards If Found Useful......

Thanks,

Mandeep Saini

[Former Member]

Hi Nichole,

I have opened link just now and yes, it is not working fine.

I downloaded the webex player and then tried to run it. But still no use.

All you can do is to drop an email to sdn team to sdn@sap.com as it is mentioned in the page.

They will help you.

Regards

Richa

[Former Member]

Richa,

I'm not working so much with dates.

Here is an example of a validation I need to create:

If when a user is creating a new customer, and choses US as the country, than:

Currency=USD

Credit Control Area=US01

etc.

So how would I construct this?

Something like this?

IF("country"="US"),then("currency"=USD") AND ("credit control area"=US01)

Please pardon my ignorance, I'm very new to this!

[Former Member]

Hi Nichole,

Check this link.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b025fab3-b3e9-2910-d999-a27b7a07...

It is for calculating Dates in SAP NetWeaver MDM.

Regards

Richa

[Former Member]

Richa,

The link: which has the Webinar about Validations works, but when I go to download the download the session, it says the page is unavailable.

I was wondering if you knew where I could find that Webinar session other than the link you have provided me because i'm sure it would be very helpful to me.

Thanks

[Former Member]

Hi Nichole,

Tell me the links which are not working.

I'll send you again.

Regards

Richa

[Former Member]

Hi Nichole,

Please check these links also

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/34ae996e-0901-0010-4691-99a50a67...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0bc693c-76d8-2910-fd81-e891248a...

http://help.sap.com/saphelp_nw04s/helpdata/en/23/10193ca1f5e713e10000000a114084/frameset.htm

/thread/755613 [original link is broken]

Hope it will help you.

Regards

Richa

[Former Member]

Hello Nichole,

You can refer the MDM Data manager referance guide for the Standard Function Syntaxes. All the functions are describe there that how to use those.

Or you can go through the below mentioned link:

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

MDM Validation Blogs:

you can refer some more links more on MDM validations

Validation Expressions:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

Calculating Dates:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b025fab3-b3e9-2910-d999-a27b7a07...

Some Assignment Expressions:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60b2e926-700b-2a10-08b4-dd0d7e09...

More Validations:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/34ae996e-0901-0010-4691-99a...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

I hope this will help you a lot.

TNR,

Saurabh...

Reward if found helpful.

[Former Member]

Hi Nichole,

Validations is an important feature of MDM.

It is very important to validate master data by using validations.

Creating of validations for fields depends on Business Process.

It highly depends upon how the business is running and this decision has to be taken by Various Teams involved in the Business process

Some of the validations that can be run on the master data are:

1. To check for mandatory fields

2. To check for NULL or Non-Null Fields

3. To find a particular record using FIND options

4. To put some IF THEN contitions to make possible differnt checks on the master data.

For eg: One validation can be run to check wether the Part number is null or not. It is

IS_NOT_NULL(Part number).

Syntax of validation is :

if <condition> then <what to do if pass> else <wt to do if fail>

Validations can be executed on the following:

1. Account Group

2. City

3. Country

4. region

5. reconcilation Account

6. Transportation Zone

For more details on validations please refer these links:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

Hope it will help you.

Regards

Richa

[Former Member]

Hi Richa,

The examples you gave in your thread were very helpful.

I have seen all of the links you've provided, as as they do shed some light, as I told Nisha, i'm looking for a particular .pdf that has many different kinds of validation expressions in it. I've heard it's out there, I just haven't been able to find it yet!

Also, the link to the session on Validations is not working, any idea where else I can look to find it?

Thanks for all of your help.

Nichole

[Former Member]

Hi,

You can refer this PDF

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

Apart from this u hav help.sap.com

Regards

Nisha

[Former Member]

Hi Nisha,

Thanks for the link. I have actually seen that page before and it is helpful, however, someone from my team told me there was a .pdf somewere on sdn.sap.com that is filled with examples of all different kinds of validations that I am looking for.

If you know what I may be referring to, please let me know! Thanks for the help.