Home > Default > Objective Setting & Appraisal: Importing Goals from Excel

Objective Setting & Appraisal: Importing Goals from Excel

November 30Hits:0
We are implementing OSA in SAP HCM. We have to import the Goals from Legacy application (available in excel)
Is there any provision to import in HRHAP* tables.  There are around 2000 employees, whose goals need to be imported into HCM.
If you have any other solutions, please let me know,
Vijay Badgeri


Dear Shubham,
Please correct me if my understanding is wrong.
1. Create an Object Tasks for Goals (PP01)
2. Create Relationships (A007) between Task and Employee Number (We are not using Position as tasks are specific to persons, and few employees have multiple positions assigned.)
How do I define Objectives ? Since I cannot load them as individual tasks, Do I need to create a custom infotype to load the Goals and load them thru LSMW?
For your understanding the flow is as under:
The Goal template has following field (Available in one Excel for all employees)
1. Perspective (Financial / Customer / Process / Learning)
2. Objective
3. Weightage
4. Unit
5. Unit of Measurement
Following fields get added to Appraisal document...
6. Achievment
8. Appraiser Rating
9. Raviewer1 Rating
10. Reviewer2 Rating
The document flow is as follows:
The Appraisal Hierarchy is as follows
1. Appraisee -> Appraiser
2. Appraisee -> Appraiser -> Reviewer 1
3. Appraisee -> Appraiser -> Reviewer 1 -> Reviewer 2
Employee based on the inputs received from his superior defines the Goals for the FY
It is validated by his appraiser (and reviewers as applicable)
On approval by all relevant Appraiser/Reviewers, goals are visible to Appraisee
There are no standard template available, the number of unique objectives will be very high. Each employee is having minimum of 8 objectives, maximum can be 25.
How do I go about ?
Thanks in Advance,

Read other 5 answers


Related Articles

  • Objective Setting & Appraisal: Importing Goals from ExcelNovember 30

    Hi, We are implementing OSA in SAP HCM. We have to import the Goals from Legacy application (available in excel) Is there any provision to import in HRHAP* tables.  There are around 2000 employees, whose goals need to be imported into HCM. If you hav

  • Import data from excel/csv file in web dynproOctober 11

    Hi All, I need to populate a WD table by first importing a excel/CSV file thru web dynpro screen and then reading thru the file.Am using FileUpload element from NW04s. How can I read/import data from excel / csv file in web dynpro table context? Any

  • Convert/Import TDMS to ExcelOctober 11

    So I have some LabVIEW code which logs to TDMS just fine.  I installed the TDMS Excel Add on to Excell 2007 and it imports the TDMS just fine and it looks good. What I would like do do now is instead of just having that TDMS file, I would also like t

  • Import data from excelOctober 11

    Hi, I am using Jdeveloper 11g and I want to import data from excel in my table through the jsf page and commit it to database. How can I implement it. Its urgent please help me!!!!!!!!!!!!!!!!!!!!!Unless you are importing Excel data to sav

  • How to import Word or Excel files in Project 2013.November 30

    I am facing a problem in Microsoft Project 2013. I am trying to insert a word or an excel file into Project 2013. But for each file, an import wizard appears and after trying all the possibilities, I am unable to finish it. Please help me out and tel

  • Importing data from Excel using SDK!November 30

    Hi All, Can we do a Goods Receipt and Goods Issue via SDK. IF so any code available for the same!Secondly can we Import data from Excel using SDK! Thnx in advanceHi Vinayak 4 your 2nd issue: you can easily use Excel.Application COM-object. In C# expo

  • Is it possibke to extract import data from excel file not csv typeNovember 30

    I am getting training from somebody, who is telling me the excel file has to be type csv only to extract and import the excel data for creating infoobjects, is that true. Please kindly provide steps, if any one has steps to extract the excel data whi

  • Import and edit Excel 2004 graphs?November 30

    There are specific features of Office 2004 that cannot be reproduced anywhere else it seems  – specifically Excel 2004's ability to print a graph to a specific size. So I have to keep separate Snow Leopard (the last OS with Rosetta) machines because

  • How Can I Import Contacts from Excel (XLSX/XLS) and CSV file to VCF File?October 11

    Hi Friends, I have stored my all official and personal contacts list in the Excel (XLSX/XLS) spreadsheet and CSV file from long time. But now, I want to move my all contacts in an MS outlook 2013 and also Samsung S4 Contacts directory. But for this p

  • IDoc not found in Objects list while Import from SAPOctober 11

    Hi All,    We could not find the custom IDoc in the Objects list, to import to Integration Repository.    Please let me know is there any setup required on R/3 side. Thank you very much in advance. RamaHi, Are you able to see, standard/any idocs whil

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.723 s.