Wednesday, March 08, 2006

SAP R/3 : ZHRI0008 & SM69 - Part 1

ZHRI0008 was quite a lengthy issue with a lot of in and out of emails between consultants. However, the issue was solve at end. It had cost me a lot of time and many misunderstanding in the emails.

ZHRI0008 is an ABAP program to interface with a third party software known as KRONOS. During the process, ZHRI08 or ZHRI0008 will determine whether files that is being used comes from the frontend or from the UNIX. Either two of this media storage type, the program will process the data by updating the latest leave (sick and vacation) by obtaining relevant row of records from infotype 2001 and 2006.

After all this process finish, the result is save to a file known as EMPBAL.TXT

This file is then use to interface with KRONOS. ZHRI08 will execute SXPG_COMMAND_EXECUTE to run a UNIX command so KRONOS will be able to use the EMPBAL file. This UNIX command being executed can be found in SM69 and SM49. SM69 is where ABAPer can create and make modifications to OS commands. While the latter displays job logs pertaining to OS Commands.

SM69 - External OS Command
SM49 - Job Logs External OS Command

Problem:
1. Balance were incorrect calculated and sent to EMPBAL.
2. KRONOS were not correctly interface in QAS system.

Solution:
1. I corrected the SELECT statement that finds records in IT2001 and IT2006
2. Reconfigure ZQUOTAS in SM69 ensuring that its OS command only runs back in its own system.

Edited - 31-03-2006
This program was later found not so accurate and the logic was changed. Please click here for more of it.



is sky the limit... SAP R/3

No comments: