01-20-2011 9:12 AM
Hi all,
I am new to SLCM(Student lify cycle management). i have to upload appraisal data from excel to SAP. My excel contains
1.Module id
2.Academic Year
3.Academic session
4.Event package
5.Booking Status
6.Student ID
7.Start Date
8.End Date
9.Marks/ Grade
10.Appraisal Status
11.Remarks
For this requirement i tried the below function moduels:
HRIQ_AGR_RFC_APPR_CREATE,HRIQ_AGR_APPMOD_CREATEFROMDATA,HRIQ_APPRAISAL_CREATEFROMDATA.
Nothing works. please let me know the function module which will fit for the above mentioned requirement.
Regards
Bhaskar
01-20-2011 10:27 AM
Bhaskar, try this FM: HRIQ_AGR_RFC_APPRMODUL_CREATE
We are using it. We also use HRIQ_ENQUEUE_OBJECT and HRIQ_DEQUEUE_OBJECT before and after calling it, to block object.
Diego
01-20-2011 10:27 AM
Bhaskar, try this FM: HRIQ_AGR_RFC_APPRMODUL_CREATE
We are using it. We also use HRIQ_ENQUEUE_OBJECT and HRIQ_DEQUEUE_OBJECT before and after calling it, to block object.
Diego
01-20-2011 10:41 AM
Diego, will the function module suggested you will change the status of student from booked to completed successfully?
Regards
Vinod Kumar
01-20-2011 12:10 PM
Vinod, you can change the status using this FM, or using the BADI at SPRO --> SLCM --> SLCM Processes --> Appraisal --> Business Add-Ins (BAdIs) --> BAdI: Appraisal and Module Booking Data
Diego
01-20-2011 12:17 PM
Dear Diego,
Thanks for your immediate reply. i tried this, but couldnt see the appraisal overview for the same in PIQSMFU tcode. may i know how to input the appraisal ID?
Regards
Bhaskar
01-20-2011 1:01 PM
Bhaskar, you can find the AGRID at the table PIQDBAGR_ASSIGNM.
You can get it by filtering on that table by the MODREG_ID field, with the ID value that is stored at HRPAD506 table (additional booking data).
Diego
01-20-2011 2:11 PM
Dear Diego,
Thanks for your reply.
i am aware of that table PIQBAGR_ASSIGNM, my concern is, when am trying to execute the mentioned function module, what are the fields i have to input, i guess am missing something. please suggest
I_APPRAISAL:::
Appraisal ID
Repetition Attempt Number
Appraisal Type
Appraisal Status
Appraisal Archiving Status
Appraisal Remark
Academic Year
Academic Session
Appraisal Validity
Start of Appraisal Validity
End of Appraisal Validity
Earliest Appraisal Date
Latest Appraisal Date
Appraisal Relationship Information
Last Day of Attendance
Grade Symbol
Std Value for Scale Value
Academic Scale Identification (ID)
Appraisal Grade Not Relevant
Appraisal Date
Appraisal Completed
GUID - Unique Note Identifier
I_APPEE::
Object Type
Extended Object ID
Plan Version
I_ASSIGNM:::
Plan Version
Object Type
Extended Object ID
Infotype
Relationship Specification
Relationship Between Objects
Planning Status
Priority
Start Date
End Date
Variation Field for File PLOG
Number of Infotype Record with Same Key
Type of Related Object
ID of Related Object
Module Booking Identification
I_APPSER:::
Sequence Number of Function
Object Type of the Appraiser
Identification (ID) of the Appraiser
Plan Version
Function Exercised (Abbreviation
I_TEXT:::
Appraisal ID
Language Key
Appraisal (Description)
I_PAD506:::
Module Booking Status
Cancellation Reason
Cancellation Date
Attempted Credits
Earned Credits
Unit of Measurement for Credits
Std Value for Scale Value
Booking Date
Booking Time
Alternative Assessment Method for Module
Free of Charge
External Academic Work or Qualification Transferred
Event Package
Session Variant
Academic Session
Academic Year
Academic Scale Identification (ID)
Module Booking Identification
Module Booking Reason
Exclusion Indicator for Module Bookings
Change Lock
Conditional Booking
Regards
Bhaskar
01-20-2011 3:31 PM
Please check the following documentation:
FU HRIQ_AGR_RFC_APPRMODUL_CREATE
____________________________________________________
Short text
Create Appraisal for Module Booking
Functionality
Create/Update Module Final Appraisal
Before the system creates a final appraisal for a module booking, it processes the customer enhancement HRPIQ00GRADING. Your implementation of this enhancement determines the administrative data the final appraisal contains. When you save the final appraisal, the system saves the booking and updates any data that was changed.
This function module has the following parameters:
I_LOCK (optional)
This parameter indicates if the object (module) should be locked after the appraisal run.
I_APPRAISAL (mandatory)
In this parameter, you enter appraisal data like appraisal type, appraisal status, and the academic year and session to which the appraisal relates.
The AGRBEGDA, AGRENDDA, AGRDATEE, AGRDATEL, and AGRWEIGHT fields are currently not taken into account in appraisal processing. However, their use in future enhancements is already defined.
When you create an appraisal which is dependent on a higher-level appraisal, the higher-level appraisal is referenced in the UPAGRID field.
You also specify the assigned grade symbol, grade value, grading scale, Grade Not Relevant (AGRNOTRATED) and Appraisal Complete (AGRCOMPLETED) indicator values, and the appraisal date in the structure I_APPRAISAL.
I_FOLLUP (optional)
If you want to create credits for an appraisal, you must enter a value in this parameter. You can only create credits for a final appraisal.
I_APPEE
You enter the appraisee data in the structure I_APPEE. You can only specify an appraisee for the final appraisal.
I_APPSER
You enter the appraiser data in the structure I_APPSER.
I_ASSIGNM
You enter the appraised object and the module booking in the structure I_ASSIGNM. As each module booking has its own GUID, you only need to enter the booking GUID in the MODREG_ID field. You can only enter an appraised object for the final appraisal.
I_TEXT
You enter the appraisal description in the parameter I_TEXT.
IT_ELEMENT (optional)
The system transfers the elements of an appraisal and their grades to table IT_ELEMENT. The appraisal dialog currently allows you to enter only one element per appraisal type.
I_PAD506
You enter the module booking data in the parameter I_PAD506.
I_INPUT_CHECK
If you set the I_INPUT_CHECK indicator, the system checks the semantics and permissibility of the transferred values based on Customizing settings and the ABAP Dictionary.
It lists conflicts in the export table ET_RETURN.
E_AGRID
When the system has successfully created an appraisal, it returns the appraisal GUID in the parameter E_AGRID.
CT_ELEMENT
The system also assigns a GUID to each appraisal element.
Diego
01-21-2011 2:37 AM
Arani,
Why you want to load appraisal data? Is it a conversion program or an Interface? If it is an Interface, I will suggest to explore the function group of RFC suggested by Diego. You will find a get RFC which gets these informations you mentioned here.
Prabhat Singh
01-21-2011 3:03 AM
Dear Diego,
Thanks for the documentation, i have seen that in Function module documentation. i was little confused with the input values. i think i have to explore.
Regards
Bhaskar
01-21-2011 5:10 AM
Dear Diego,
I tried this way, please correct me where am wrong,
I_APPRAISAL:::
Appraisal ID
Appraisal Type - 002
Appraisal Status - 001
Appraisal Archiving Status
Appraisal Remark - 10
Academic Year - 2011
Academic Session - 051
Start of Appraisal Validity - 20.01.2011
End of Appraisal Validity - 20.01.2011
Earliest Appraisal Date
Latest Appraisal Date
Appraisal Relationship Information
Last Day of Attendance
Grade Symbol - B
Std Value for Scale Value
Academic Scale Identification (ID) - 0001
Appraisal Grade Not Relevant
Appraisal Date
Appraisal Completed - X
GUID - Unique Note Identifier
I_APPEE::
Object Type - ST
Extended Object ID - 50025405
Plan Version - 01
I_ASSIGNM:::
Plan Version - 01
Object Type - SM
Extended Object ID - 50025698(module ID)
Infotype - 1001
Relationship Specification - B
Relationship Between Objects - 506
Planning Status - 1
Priority - 50
Start Date - 01.01.2011
End Date - 31.03.2011
Variation Field for File PLOG
Number of Infotype Record with Same Key
Type of Related Object - ST
ID of Related Object - 50025405
Module Booking Identification
I_APPSER:::
Sequence Number of Function
Object Type of the Appraiser
Identification (ID) of the Appraiser
Plan Version
Function Exercised (Abbreviation
I_TEXT:::
Appraisal ID
Language Key
Appraisal (Description)
I_PAD506:::
Module Booking Status - 01(booked)
Cancellation Reason
Cancellation Date
Attempted Credits
Earned Credits
Unit of Measurement for Credits
Std Value for Scale Value
Booking Date
Booking Time
Alternative Assessment Method for Module
Free of Charge
External Academic Work or Qualification Transferred
Event Package
Session Variant
Academic Session - 051
Academic Year - 2011
Academic Scale Identification (ID) - 0001
Module Booking Identification
Module Booking Reason
Exclusion Indicator for Module Bookings
Change Lock
Conditional Booking
I hope i missed some field values, please let me know what are missed fields and let me know how to get appraisal ID ?
Thanks in advance
Bhaskar
02-03-2011 8:19 AM
Hi,
Using FM:HRIQ_AGR_RFC_APPRMODUL_CREATE, am able to create module assesment data. not able to create sublevel(individual course assessment).
pls suggest on this.
Regards
Bhaskar
02-03-2011 3:17 PM
Hi
do you mean that you want to create an appraisal type that is below the upper level appraissal?
Please check that in I_APPRAISAL structure you are filling the UPAGRID field with the AGRID of the upper appraisal.
Diego
02-28-2011 1:13 PM
Hi Diego,
Thanks for your reply, yes your answer works. Now am facing issue with updating appraisals.
With the above mentioned FM am able to upload both top and sub appraisal data successfully. when i am trying to update existing appraisal data, sub appraisal updation is happening properly, but not top appraisal.
Please suggest on this.
Thanks and Regards
Bhaskar
02-28-2011 7:58 PM
Hello Bhaskar,
Diego asked me to give a look at your post. As you might have clear by now, the FM is usefull both to create as well as to modify an appraisal. The difference lays in indicating the AGRID corresponding to the apparaisal (+ UPAGRID if it's not the top appraisal) you're working with. Sending the corresponding AGRID will indicate that this new apparail must be written "over" the old one. If you forget to send the AGRID, a new appraisal will be inserted generating inconsistencies in the database.
If you're working on a Excel spreadsheet, you should be careful to either have the existing AGRID on your spreadsheet, or before inserting, check if the appraisal exists already, get the AGRID and add it to your IMPORT structures.
In our scenario (web application), when we want to modify an existing appraisal, the structures we include the AGRID in are:
I_APPRAISAL-AGRID
I_TEXT-AGRID
CT_ELEMENT-AGRID (only for top appraisal -maybe you're missing this considering your last comment about top level appr update failing-)
Cheers,
Michael
03-18-2011 10:49 AM
Dear Michael and Diego,
Sorry for delayed reply.
it works. Thanks a ton for your wonderful assistance.
01-30-2015 10:06 AM
Hi,
I have a similar requirement.
I have to update values of some custom fields in HRPAD506 table based on ADATANR.
Can you please help me with this.
Thanks DUTTAD.
01-30-2015 10:17 AM
Hello DUTTAD:
If you need masive changes, and considering they are custom fields I'd go for a ABAP report. You will input your ADATANRs and define the criteria to change your values.
Cheers,
Michael
01-30-2015 10:32 AM
Yes I am developing a report...where I will upload a file and capture the data to an internal table.
But my doubt is how do I update HRPAD506 values based on ADATANR. IS there any FM available
Thanks for your reply Michael
01-30-2015 10:59 AM
Can't say DEFINETELY NO, but I would bet there isn't a FM for this.
Bear in mind that for each ADATANR number you process, you'll have 2 records to consider. Every pair of objects related in HRP1001 have technically the A and B relationship. I imagine you should update both.
Michael