Skip to Content
Author's profile photo Ajay Maheshwari

Alternate solution to track employee costs

This document intends to explain an alternate approach to track employee costs. If SAP HR is implemented, it provides a standard way to do that. However, where SAP HR is not in scope, I have used the below approach, which I would like to share with the group.

Though this approach is very common, I have tweaked it a bit, to give a different touch.

Business Scenario: ABC Inc wants to track the employee expenses like Vehicle expenses, Telephone expenses, Travel expenses at each employee level. SAP HR is not in scope

Workaround approach:

1. Create one statistical Internal order per employee.

2. Using user exit COOPA003, add the following custom fields to the Internal order master data

  – ZPERNR – Personnel No

  – ZMOBILE – Telephone No

  – ZVEHCL – Vehicle No.

3. Maintain the Personnel no., Telephone no and Vehicle no. while creating the IO master data

4. Maintain the “actual posted cost center” in the IO Master, incase the employee is attached to one cost center only

5. Create a Search (F4) Help using T code OKO1, to search the IO Number using ZPERNR, ZMOBILE, ZVEHCL. This is important because the accountant booking the expenses may not know the relevant IO number for a given Telephone no, when the employee is submitting his monthly Telephone bill to the accounting team. Though the employee no. can be written on the expense voucher, the idea is to avoid manual intervention.

Screenshots

1. User exit COOPA003

/wp-content/uploads/2013/12/1_339977.jpg

2. Add the custom fields to the include CI_AUFK. The below image shows the field ZPERNR. Similarly, add other fields

/wp-content/uploads/2013/12/2_339978.jpg

3. Write your custom code in the include ZXAUFU04 (part of EXIT_SAPMKAUF_002)

.4. Search Help

/wp-content/uploads/2013/12/3_339991.png

Once the search help is created, press F4 in the field “Internal Order” while doing the posting. One can see the custom fields there to search based on the Mobile No., Vehicle No. etc

Happy reading!!

Br, Ajay Maheshwari

PS: You can also read my blogs in Career Center wherein I have shared some tips for a good consulting career.

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks Ajay for sharing, another one of your SAP processes.

      Ram Vusirikala

      Author's profile photo Sumit Koshal
      Sumit Koshal

      Thanks ajay for this...also we can give external number range to internal order.. and maintain the internal order number to be same as employee code of the organisation...

      Author's profile photo Ajay Maheshwari
      Ajay Maheshwari
      Blog Post Author

      Hi Sumit

      Thats right. But then you cant search IO based on vehicle No or Mobile No.. So, the whole idea of adding the custom field is to make this solution more appealing to the user community

      Br, Ajay M

      Author's profile photo Ajay Maheshwari
      Ajay Maheshwari
      Blog Post Author

      Thanq Ram 🙂

      Author's profile photo nikki saju
      nikki saju

      Dear Ajay

      Please inform whether the vice-versa is possible.

      Is it possible to assign an intenal order to an employee master record.  We need to track each employee salary paid to internal orders. i.e. When the Payroll is run, each employee salary to be posted to an internal order also along with the employee cost centre.

      Author's profile photo Surya Varma
      Surya Varma

      Hi Ajay,

      Thanks for the solution. Now we know what to do when we get a similar requirement.

      Thanks & Regards

      Surya

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hello Ajay,

      Good document to trace employee cost and thanks for sharing.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi

      Thanks Ajay.  Very Glad to read such a nice document, which explains mapping for employee costs.

      Satya