Skip to Content

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

MDM Validation on the whole table data - Please help

Hello Experts,

I am a new to MDM validations. So I want to know approach for validations like below. Say I have a Employee Table with fields

RecordID | Emp. Number | Name | Unit | Date Join | Date Resign

Validation requirements are

1. Say in case employee resigns and joins again there is going to be new entry added. In this case 'Date Join' should be greater than 'Date Resign' of previous record of his.

2. Employee should be assigned to only one 'Unit'

3. Employee number can not be duplicate. etc

Is this possible with validation within Data Manager? Your help/links/pointers are very much appreciated.

Thanks.

Edited by: Sagar Lipare on Apr 14, 2010 1:51 AM

Tags:
Former Member
replied

Hi Sagar,

As I said, i doubt if your first two requirements can not be fulfilled using standard MDM data manager validations.

In case you are using portal, for creating a new record you can fetch and compare new record data with other records in MDM for same employee and can throw error as per your validations.

Please check [MDM JAVA API guide |http://help.sap.com/saphelp_nwmdm71/helpdata/en/72/d36e1ed3ce43028adc851b8fed5668/MDM_Java_Net_API_Guide.pdf]from page no 30 to 33 for explanation and code sample for creating a new record and retrieving existing records from MDM using Java API.

Hope this helps. Kindly revert if you have any query..

Regards,

Shiv

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question