Skip to Content
author's profile photo Former Member
Former Member

Employee data download

Hi all,

We have an existing system and the employees are already in the CRM system from HCM system.

The employees were manually created in the CRM system.

Now I use the HR-ALE download to download new employees, the new employees will get succesfully

downloaded into the CRM system, further changes to the employees at HR will download the delta

change to CRM system

Again I use the same HR-ALE download to download the existing employees into CRM. The reason for this

is whenever changes are done to the existing employees, I would require to get the changes into the

system.

Now the grey area is

1. when the existing employee is downloaded will it delete the existing employee and re-create it?

Also the employee will get a new employee number or retain the old employee number in CRM?

(if this is the case, then the existing orders will have a problem as I assume the employee cannot

be deleted as it linked to an order)

2. For the existing employee it just updates the employee information instead of deletion?

(In this case, the existing orders will not be affected and the employee information will be updated

and whenever the employee is updated in HCM, the employee is updated automatically in CRM.

Hence for existing employee will it function as Option 1 or Option 2.

Any ideas will be highly appreciated.

thanks

Jothi.

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2006 at 04:28 AM

    While writting your ALE you can specify if you want to update the old Employees or want to delete and recreate.

    CRM stores the Employees as Business Partners in role 'Employee'. The employee number of HR is attached to this CRM business partner as "Personnel Number". I dont think this should get changed if you are not explicitly changing it.

    Any creation of Business Partner in CRM by default generated a new number of the BP but will have personnel number passed to it during creation. CRM doesnt generate employee number, so it is what is passed as parameter by your ALE at the time of creation/updation.

    Thanks,

    Vivek

    P.S: Reward points if helpful answer.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vivek,

      Yes as per your reply it will update the old employee pefectly without problems which was downloaded initially by ALE mechanism.

      But my concern was what will happen if the data in the first step downloaded through a customized report and now trying to update through ALE.

      Will it update based on the personnel number if the data created through legacy system has personel number.

      your inputs will be highly helpful.

      Thanks

      Jothi

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2006 at 12:46 PM

    Hey I am not able to really understand your problem. But generally all delta updation in all SAP standard mechanisms should be based on CRM Business Partner Numbers. They are not likely to be based on personnel number. Normally CRM Business Partner number like CUstomer Number in R/3 is the basis of updations.

    Thanks,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2006 at 06:03 PM

    Hi Jothi,

    This is Devi, iam new to meddleware.

    In couple of weeks i have to work on Employee data download, if you don't mind can you help me out how to do the download.

    if you have any doc. can you mail me to this mail id.

    devi.gupta@rediffmail.com

    iam working at client place.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      in a test system try to distribute an employee with transaction PFAL - then you can see if i overwrites the "original" in CRM.

      I don't believe that it will overwrite an original - but whether it creates a new BP or generates an error I don't know.

      In the help to PFAL you will also see that org. relations created in CRM will not be removed by a new distribution.

      Kind regards,

      Michael.