RE:[sap-hr] Emergency Contact Report For Managers (MSS)
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Saskatoon_Heather (HR Functional Specialist) on May 6 at 2:58 PM |  Mark as helpful |
Hi,
Did you find a solution. We are having the exact same problem?
Heather
---------------Original Message---------------
From: KiranSAPHR
Sent: Wednesday, March 18, 2009 2:40 AM
Subject: Emergency Contact Report For Managers (MSS)
> Hi,
> I have copied and modified the SAP query Family members. I have added the infotype 106 to get telephone number of all emergency contacts of given personnel number.
> The problem is the query returns duplicate records if given personnel number has more than one emergency contact as if it is returning the cross product of infotype 0021 and infotype 106.
> Is here is way to fix this by picking only the corresponding telephone number from infotype 106 for the emergency contact in 0021.
__.____._ Did you find a solution. We are having the exact same problem?
Heather
---------------Original Message---------------
From: KiranSAPHR
Sent: Wednesday, March 18, 2009 2:40 AM
Subject: Emergency Contact Report For Managers (MSS)
> Hi,
> I have copied and modified the SAP query Family members. I have added the infotype 106 to get telephone number of all emergency contacts of given personnel number.
> The problem is the query returns duplicate records if given personnel number has more than one emergency contact as if it is returning the cross product of infotype 0021 and infotype 106.
> Is here is way to fix this by picking only the corresponding telephone number from infotype 106 for the emergency contact in 0021.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
