on 10-19-2009 8:05 PM
Hi all,
I am using a workflow notification in MDM to send an email to a user. The email arrives as intended - but the problem is display field "REGION" shows wrong value...in my record region is "NC,North Carolina" and in email it shows 1531. I dont know from where does it getting the number from..
Can anyone explain why this might be? Has anyone experienced this problem before?
Thanks in Advance.
Rohit
Hi Rohit,
Use variable %Records% and set the display field of the main table to REGION. For this, Unload MDM repository, select MDM Repository in Console Hierarchy pane, navigate to Main table name in Tables pane and set the Display Fields property to REGION.
Regards,
Jitesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your reply Shailesh and Jitesh.
I am using %Records% variable and REGION is set as a display field as Jitesh said, still facing the issue. All other fields show correct values except REGIONu2026
Some more detailsu2026 REGION is lookup hierarchy table and we are on UNIX box not on windows. Does SAP support hierarchy table in email notification on UNIX boxu2026??
*Appreciate your reply guysu2026
Hello Rohit
Display fileds property used in MDM only for visualization fields(not lookup only) in Data manager or Import manager and ets.
if you set that property to "Yes" - field values will view
if you set that property to "No" - field values will not view
DF number - set order fileds in case which you set Display fileds property to "yes" for more then one fields in lookup tables
For example:
Name= DF[1] = "USA"
Code= DF[2] = "US"
View in Data manager drop down
USA,US
Name= DF[2] = "USA"
Code= DF[1] = "US"
View in Data manager drop down
US,USA
Name= DF[1] = "USA"
Code= = "US"
View in Data manager drop down
USA
Name= = "USA"
Code= DF[1] = "US"
View in Data manager drop down
US
in any case
one of lookup fiilds should have Display fileds property = "Yes"
We usually discuss that with customer.
Regards
Kanstantsin
Edited by: Kanstantsin Chernichenka on Oct 21, 2009 1:00 PM
Edited by: Kanstantsin Chernichenka on Oct 21, 2009 1:01 PM
Hi Guys,
Got the answer!!!
As my REGION field is a hierarchy table and current MDM 7.1 SP 3 version does not support that. SAP has told me that this will be possible in SP 4 so lets wait till SP 4 gets released somewhere beginning of next year (Q1 of 2010)
Thanks,
Rohit
Edited by: Rohit Komawar on Nov 2, 2009 8:45 PM
Hi Rohit,
Which is the notification variable you have used for getting REGION?
- Shailesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.