How to load historic Training records

[Former Member]

we have a scenario where we went live in 2012 and only loaded employees that were active in 2012 so that they would be included in payroll year end returns. The earliest start date for any employees in infotype 0 is 01.01.2012.

Our old HR system has approx 5000 employees (about half were loaded into SAP), and is still used for updating the training module.

This old HR system holds all training records and qualifications for all employees that were ever created on that system.

We want to now use the standard Training and Event management module in SAP and load all training history including qualifications details into SAP for all employees that exist in the old HR system.

I have 2 issues:

Approx 2500 employees from the old HR system don't exist in SAP. Do i create them in SAP with actual start date that will allow me to record necessary training records for them in PSV1/PSV2. If so, is there a mass way of mass loading this data?

The earliest start date for existing employees in SAP is 01.01.2012, therefore any training history for employees can't be created for them in Training module, and therefore reported on.

I know we can't create training records for employees in psv2/psv1 prior to their actual start date so therefore for those employees that already exist in SAP, no historically data can be created. How can i record these training details?

Previously I loaded all previous qualifications into infotype 24 but unfortunatley this won't work in this scenario as not all the training courses would have had a qualification attached to it.

Has anyone come across above scenario?

If so, how did you resolve the issue?

any suggestions would be greatly appreciated.

thanks

clive

[Former Member · Accepted solution]

Hi Clive,

actually you can create training records before the actual start date. You need to configure the relationship rypes involved in table T777D accordingly to allow them to be captured before hiring date as far back as the date of birth. (In the same table you can also allow them to be captured after leaving date up to system highdate - something some organisations use to capture events in outplacement programs, where people get help to find a new job after they've bee laid off or to have retirees signing up for alumni events)

hope this helps

Sven

[Former Member · Accepted solution]

Sven

Thanks for coming back to me on this.

I have looked in table T777D and this is for Infotypes.

If i have to change infotype, which ones and how?

If the wrong table above, what is the right one?

When you say relationships, i imagine you are referring to changing the likes of A 025 Is participated in by to allow the requirement.

Thanks

clive

[Former Member · Accepted solution]

Sorry. My stupid mistake thinking 2 different probs at the same time.

The table you need is T777birth.

[Former Member · Accepted solution]

Sven

Sorry again but i have checked table T777B Appraisal Typesand this is to do with appraisals.

I have checked the the other T777* type tables and im thinking it could be T777E Allowed Relationships. if so, how do you change it allow entries prior to employee's start date?

thanks

clive

[Former Member · Accepted solution]

Sven

Sorry about that, i thought u were mentioning table T777B and not table T777BIRTH.

Didnt realise there was a table name like that.

thanks

clive

[Former Member · Accepted solution]

Sven

Quick q for you on how to load historically data for training records.

Is there any standard programmes that can be used to load this data or will i just have to write lsmw to achieve this requirement?

thanks

clive

[Former Member · Accepted solution]

Hi Clive,

I definitely wouldn't go for an LSMW as the required screens for a reasonable Training Catalogie structures are complex and not LSMW-friendly.

You could use the second half (i.e. HRALTD00) of the PD-Data Transfer Workbench. See IMG "TEM > Basic Settings > Tools > Data Transfer Workbench.

Personally, I've always used a custom ABAP, because I wanted to be in control of the complexities within SAP rather than having them dealt with in an Excel.environment outside and because the conversion logic usually was quire complex. You just need a tech person, who really knows the data structure very well.

But RHALTD0 might just work for what you need. I've only used it for Orgmanagemengt myself, but it could deal with TEM data as well.

kind regards

Sven

[former_member193652 · Accepted solution]

Hi Clive,

Did you use T777BIRTH and which kind of records you have added into this table?

Regards,

Omid