Skip to Content

I am not here to tell you the basic functionality of Functions and Operations as this thing you can read and understand easily from MDM Data Manager Reference Guide. I have a keen interest in writing expressions and I have already answered a lot of threads in SAP Master Data Management. So I have consolidated some of these good threads for your references. I think this blog would be really helpful for the SDN MDM Community in order to understand and get familiar with the use of Operations, Functions and more under Expressions.

 

What is MDM Expression: MDM expressions are Excel-like formulas that are evaluated by MDM and return a distinct value for each record.

 

Let’s start with the use of some Functions with suitable examples:

 

      1. SYSTIME( ) : If you give in Expression as SYSTIME(0), it will give you the Current Date and Time. So accordingly you can make use of this expression.
         e.g. SYSTIME(1) : It will add 1 day to the current date. i.e. Tomorrow
         SYSTIME(NEGATE(1)): It will subtract 1 day to the current date. i.e. Yesterday

   Business Requirement where you can use this Function:

           Comparin System Date with a Date field

   Assign constant time to field in DM    

 

2. TRIM ALL, TRIM LEFT and TRIM RIGHT : These are the functions which use to TRIM extreme SPACES only not Special characters. I think in future if SAP can provide such a function for removing special characters that would be really great in writing Expression for Assignments.

Special Characters Removal Using MDM Import Manager

 

      3. Callable Function : You can write an Expression in Validation Tab and if you         have set Property Callable = Yes then you can use this expression in any other Validation/Assignment Expression. For this you will see this Validation name in Functions tab of Expression.Please refer this Re: User defined Function in Expression. for more details

     4. Concatenate : Concatenate function will give you always delimiter comma (,) between two field values. For the same you can also use & operator which will give you values without any delimiter. Calculate an incremental field with a prefix

 

     5. Concatenation of Attribute Values : This is possible using Add Branch Asignment. Please refer this Re: Concatenation of attribute values for more details.

 

6. Language Field Validation : In fact, Multi lingual validations cannot validate the inherited if the data manager is opened in the primary and vice-versa. For more details Please refer this Language field Validation.

 

MDM Expressions: Part 2

 

References:

MDM Data Manager Reference Guide

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply