Skip to Content

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

Assignments in data manager

Hello,

Your inputs on writing this assignment will be appreciated.

SQL:

update sds_mdm_business_partner

set first_name = trim(middle_name),

title = trim(translate(first_name,',.',' ')),

middle_name = trim(translate(

decode(personal_sfx,null,null,last_name),'.',' ')),

last_name = trim(decode(personal_sfx,null,last_name,personal_sfx)),

personal_sfx = null

where trim(translate(upper(first_name),',.',' ')) = 'MR'

Assignment Logic:

when the First Name is 'Mr, 'Mr.', 'MR', 'MR.' and so on, move it to the title field, move the middle name field to the first name field, move either the last name or the personal suffix field into middle name and last name, depending on if there is a value in the personal suffix field or not, and remove the personal suffix field.

Can we write this SQL in MDM .

Thanks

Bindi

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