07-18-2011 2:20 PM
Hi,
Just wanted to know the table which stores Audit results after audit runs. I checked in table type HRP1179 and found that it stores an audit ID. The requirement is to find out why a student fulfilled/not fulfilled the (sub)requirement. I can see that using BSP application but not sure where it stores these results.
Regards
Vinod
07-20-2011 7:14 AM
07-27-2011 7:53 AM
Hi, Any suggestions....my question might be stupid, but if there is any table which stores program audit results, will help me immensly.
Regards
Vinod Kumar
08-15-2011 10:25 AM
Dear Vinod,
Already found? If not please check the following tables for all sorts of audit results (degree audit, admission, etc):
- PIQDBAPPR_AUD2
- PIQDBAPPR_AUD3
- PIQDBAPPR_AUD4
In these tables you can use the audit ID to check on fullfillment of requirements (P Pass, N No Pass).
Hope this helps.
Rob
09-08-2011 8:33 AM
Hi Rob,
Thanks for your reply. Could you let me know the table name which connects apprisal and audit. For example table HRP1779 stores audit ID. Now to get the audit results i have to pass appraisal id to table PIQDBAPPR_AUD2. How this apprisal ID and evalution ID are connected?
Regards
Vinod Kumar
09-08-2011 9:39 AM
Hi Rob,
It is linked through table PIQDBAUDR1 and PIQDBAUDR2.
What i am doing is getting evaluation ID filtered by academic yr and session from table PIQDBA_APPR and passing the same to table PIQDBAUDR1/2 for getting audit ID but failed.
1. I need the source table which stores audit ID/results (which is created while we run the audit)
2. What is the relationship between ST and audit?
warm regards
vinod
09-09-2011 3:29 PM
Vinod,
If you are looking for functionmodules to do your job, you could combine HRIQ_AUDITRUN_FOR_STUDY_GET & HRIQ_RFC_AUDITRUN_GET.
If you pass the student objid to HRIQ_AUDITRUN_FOR_STUDY_GET you could get the audit runid and when this information is passed to HRIQ_RFC_AUDITRUN_GET you could get the audit result at all requirement/subrequirement level.
Let me know if this helps you or if you have any specific requirement, do let me know. I shall try to help you.
Best Regards,
Kasi Raaman.R
09-10-2011 7:03 PM
Vinod,
I will suggest you to use function modules suggested by Kasi to read the audit results. I don't think reading from table will help you in anyway(even performance wise). It is little complex to understand audit requirements table and their results table.
SAP stores audit relationship in table assessment table 'PIQDBCMPRRECORDS". You can use this table to exclude successfully completed audits using status.
Thanks,
Prabhat Singh
09-12-2011 8:38 AM
Thanks Prabhat and Kasi. The FM and table really helped me a lot.
Regards
Vinod