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:
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.
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.
Lanka,
ReplyDeleteIn 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?
Actually, the infotype to be maintained is 0315. It was a typo on the blog. Thanks for the question.
ReplyDeleteHi Lanka,
ReplyDeleteit 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)?
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.
ReplyDeleteWe 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
ReplyDeleteThis is very useful to me...
Timesheet Management Application
But how do you solve it, if one employee has to register hours to more than on PO?
ReplyDeleteThis 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.
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.
ReplyDeleteHi Murali,
ReplyDeleteI follow all the instructions but I am getting an Error "Service does not exist
Message no. LR105".
Thanks
Hi Murali,
ReplyDeleteI 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
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.
ReplyDeleteSometimes 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.