cancel
Showing results for 
Search instead for 
Did you mean: 

reporting - time recording and costs

Expert
Active Contributor
0 Kudos

our customer would like to see the hours that they have recorded in one or more projects. They would like to make lists of the entries that users add. These lists must include the username, text added to the entry or the number of hours per entry, if the entry has been invoiced or not, or any amounts corresponding to the fees (sale price) based on work carried out (e.g. a three-hour entry by a user with a 300€ rate should show 900€ for that entry). They need to list this information in this  format means so they know what they need to invoice to their customer. Any hint which report they could use?

Accepted Solutions (1)

Accepted Solutions (1)

Saumitra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Out-of-the box, project reporting apps like "Project Profitability", "Projects Actuals" , "Project WIP Details" as well as general ledger Fiori apps like "Display line items in general ledger" all provide reporting capability that you described, to an extent. The condition however, is that the timesheet entries must have been approved and actually posted to the project. Further these apps are also extendable in terms of their data source allowing the end user to add additional standard fields to the reports out-of-the box.

Assuming that the Fiori app "Manage My Timesheet" is being used for timee recording and you wish to report on the above-mentioned information taking into account the status of the timesheet entry like "saved" or "pending approval" etc. then you may need to consider building a custom report using whitelisted CDS views like I_TimeSheetRecord,I_WorkPackage and others in case you wish to include billing status information.

You could refer to certain aspects of the workforce utilization reporting guide to understand the building blocks of the underlying views you may use for building a custom timesheet report. Specifically on: Create a Custom CDS View for Project Information and Create a Custom CDS View Combining Time Records with Project Information. The rest of the steps detailed in this guide may not be applicable to your case as this is a reference extensiblity scenario.

https://help.sap.com/viewer/ecd3b679d6e94fadbe4dfbdaaaf0cad3/SHIP/en-US/6678857bc8da496caef43b655529...

Answers (1)

Answers (1)

LucaBia
Participant
0 Kudos

As far as I know, currently it is not possible to reconstruct the whole document flow (from the timesheet record to the billing request) using the released CDS views. Basically, what is not accessible is the relationship between the timesheet counter and the CO object related to the cost accounting document generated by the approval.

https://influence.sap.com/sap/ino/#/idea/220659

Former Member
0 Kudos

luca.biasotto I think we had same conversation in the past. Since 2002 this is possible since they added a new field in I_TimeSheetRecord (Accounting Document). Really is not the accounting document but the documentreference. In any case, digging in the sub-world of CDS views (with the tremendous bugs and lack of functionality they still have) you will be able, to an extent, to develop a report in SCP or eSAC.

We did it despite sometimes SAP support (we opened almost 40 incidences of incidences related reporting topic) told us that what we wanted to achieve was not possible, specially with the timesheetnote field.

You will have to invest a lot of time for preparing the CDS, some Cloud BADI code and code in SCP for presenting the Smart Table (notice that they still have more bugs with UI versions that could lead you to not be able to group columns or to export to SpreadSheet).

LucaBia
Participant
0 Kudos

Hi Former Member, yes, I do remember. I was not aware of the new field in I_TimeSheetRecord, thanks for sharing this info.

We luckily stopped digging into this dark side some months ago, after we were finally able to come to an end via extensibility. In the beginning of the project we developed a side-by-side app to post time entries, since the standard one didn't solve our requirements.

Later on we added a custom field "Timesheet Counter", enabled in TimeSheet and Coding block scenarios; after the initial posting of the record in status 10, we get back the standard Counter field from the OData and we move it to the custom Counter field, then we write it back to S4HC when releasing (10->20). Since the field is enabled for the Coding block, it is transferred to the accounting document upon approval (20->30). This way we build the direct relationship between timesheet and accounting.

We also created a series of joins down to the RRB and billing CDS views and now we can say to have a decent reporting on T&E activities.

KR