Thursday, December 1, 2011

SAP CATS for Contractor Labor Payments

Payment of contract labor services is often a cumbersome process in many organizations. The reason being, there are various stakeholders involved such as the managers / supervisors that need to approve timesheets, the purchasing department that needs to manage the PO's, AP paying the vendors, the vendors submitting the invoice and the contractors themselves, that need to keep one or more versions of their timesheets, depending on the client and vendor requirements. It is very common for companies to spend significant dollars to set up something like a vendor portal or time entry portal for contractors to achieve even a semi-automated system. More often than not, even a minor hiccup in the whole process,
such as a contractor entering the wrong number of hours or entering hours on a holiday could cause a lot of communication and trauma to resolve issues.

In SAP, the combination of SAP Cross-Application Timesheets (CATS), Service Entry Sheets (MM-SRV) and MM-Purchasing with a little bit of Human Resources (HR) infotype maintenance provide an easy solution for this problem. CATS is used in SAP for several time entry scenarios including time entry against projects, networks, CO objects, work orders in Plant Maintenance (PM), Payroll time recording, etc… or a combination of these. In addition to these, it could also be used to have a contractor enter time against a service line item on a purchase order. Since it is not feasible for me to provide screenshots, I am going to layout the process here to accomplish this configuration. I will try to update the post with screenshots when time permits me to do so.


HR Set Up
To avail this functionality, it is important to have the HR functionality activated with bear bone HR infotype maintenance to define a personnel record for the contractor, fill out info types 0001 (Actions), info type 0002 (Organizational Assignment) and info type 0035 (Timesheet Defaults). The following information must be filled:

·         Personnel number.
·         Employee group / subgroup (IT: 0001)
·         Personnel area / subarea (IT: 0001)
·         Cost Center (IT: 0002)
·         Vendor Name (IT: 0035)
·         Purchase Order (IT: 0035)
·         Purchase Order Item (IT: 0035)
·         Activity / Service master number (IT: 0035) – this is the service master number used in setting up the PO line for this contract resource).

NOTE: Please note that some of the information maintained in these Info types needs ongoing maintenance by the HR personnel to keep the records up to date, for example, PO/Item number.


CATS Set Up
A data entry profile must be created that allows users to enter time against purchase orders. Depending on the need a release approval should be set up in the data entry profile. Timesheet defaults should be configured such that the purchase order, item and activity number are copied from IT: 0035 from the user’s personnel master record in HR.

MM-SRV Set Up
One or more service master records must be set up in MM-External Service Management component to represent the types of services rendered by the contract labor force.

MM-Purchasing Set Up
Service Order type purchase orders must be set up for the contract labor to represent the organizations issuance of PO’s to the corresponding vendors. A service line item must be set up under each PO corresponding to the service number set up for the personnel master record in HR IT: 0035.

Additionally, if the organization uses ERS (Evaluated Receipt Settlement) with vendors, the corresponding vendor masters could be configured for ERS payment to gain more automation to the payment process.

The following are the process steps from time entry to vendor payment.
·         Employee (contractor) enters time using the appropriate data entry profile using transaction CAT2 (the data entry profile can be assigned to the user’s user profile). User confirms time has been released by going into transaction CADO.
·         Supervisor / manager approves contractors time using transaction CAPS. The supervisor should set up his/her own variants for their responsible employees so that they can review and approve their time on a single screen. NOTE: The system could be configured in such a way that the managers approval is the single point of approval and approval means payment to the vendor for the approved hours.
·         Run transaction CATM to transfer approved hours to the MM component, which automatically creates a Service Entry Sheet (SES) for the approved time against the PO line item set up for the contractor.
·         Purchasing agent runs transaction ML81N to accept the SES. NOTE: If the organization determines that the manager / supervisor approval could be treated as payment approval, a simple ABAP program could be set up to automatically accept SESs created through the CATM transaction.
·         At this point, a GR (Good Receipt) is posted to the PO in SAP.
·         Depending on the invoicing mechanism in place in the organization, an invoice can be generated in the system against the PO, which will be paid by AP (Accounts Payable) based on payment terms from the PO/vendor master record.
NOTE: Any changes to the timesheet or the approval before SES acceptance are automatically updated in the system. Any changes after the SES approval need to be manually corrected in MM-SRV/MM-PUR in coordination with the manager / contractor.

There are additional discussion points such as the account assignment category of the PO, cost accounting for the time entry, etc…, which should be considered when implementing the solution after discussions with the appropriate departments.
Please feel free to provide your comments or suggestions.

11 comments:

  1. Lanka,
    In the HR portion above you refer to IT 0035. This infotype is for Company Instructions. Is the intent to creat new subtypes for Vendor Name, Purchase Order, Purchase Order Item and Service Master Number and maintain them as separate records?

    ReplyDelete
  2. Actually, the infotype to be maintained is 0315. It was a typo on the blog. Thanks for the question.

    ReplyDelete
  3. Hi Lanka,
    it is a great document, we are in the similar situation. The issue, we have several vendors and each vendor can have more than hundreds worker with different rate. In your document 1 service line item represent 1 personnel record.
    In this case do you create 1 PO for each personnel or you create a service PO with hundreds service line item (hundreds worker)?

    ReplyDelete
  4. You can create one PO/item per person and assign the PO and item number in the contractor's Infotype 0315 record. For each PO / Item, you will need to have the appropriate service master assigned and have it assigned in 0315 or if the contractor may perform multiple types of services, have the contractor enter them on the timesheet in CATS.

    ReplyDelete
  5. We are having this issue: multiple line items (+900 crafts)(using HR minimaster on a framework purchase order that is causing an administrative load. We would like to find a way to handle external labor without a line item per individual contractor. SES post hours against work orders weekly; PO are accumulating large number of items in PO history tables that make it difficult to post against the PO.

    ReplyDelete
  6. But how do you solve it, if one employee has to register hours to more than on PO?
    This could be the case, if he fx. works for more company codes og departments within the same organisation.
    If you use IT 0315 you can only have one PO per employee.

    ReplyDelete
  7. In that case, you will need to stop defaulting from IT0315 for PO/item and bring those fields through field selection into the timesheet. Then, the contractor can enter the PO/item and the corresponding hours directly into the timesheet.

    ReplyDelete
  8. Hi Murali,

    I follow all the instructions but I am getting an Error "Service does not exist
    Message no. LR105".

    Thanks

    ReplyDelete
  9. Hi Murali,

    I have one doubt while entering data in CAT2 system throws error maintain sender cost center and activity type while giving receiver as network and activity number.

    what could be the reason, where as if I give WBSE as receiver then system takes without any error.

    Please advise

    ReplyDelete
  10. We are using CAT2 to enter time and convert them to an SES using CATM but having issue during deleting a timesheet in CAT2 once converted to an SES.

    Sometimes our supplier send credit memo's as they have entered invalid time, so we use the credit memo to delete the service lines on the SES but unable to delete the timesheet in CAT2. we are getting an error which says "The record has already been transferred to Materials Management. You cannot change records that have already been transferred"

    Any help is greatly appreciated.

    ReplyDelete