CDS Views for Cross Application Timesheet in S/4HANA (CA-TS-S4)

CDS View NameDescriptionSQL View Name
C_MYINBOXTIMESHTAPPRVLConsumption CDS view for My Inbox - Timesheet Approval AppCTMESHTAPPRVL
C_PERSNWRKAGRMTDETFORTMESHTPerson Work Agreement Det. for TimesheetCPERWKAGRDETTS
C_PMPROJCATSANAKPIAnalytics of CATS Data of a Project Manager for KPI TileCPMCATSANAKPI
C_PROJMGRTEAMMISSINGTIMEProject Manager Team CATS DataCPMTEAMCATS
C_TEAMUTILIZATIONRATETeam Utilization ApplicationCTEAMUTILRATE
C_TEAMUTILIZATIONTILETeam Utilization Rate for Last Three MonthsCTEAMUTILTILE
C_TIMESHEETWRKLOCWork Location of an Employee for Timesheet RecordingCTSWRKLOC
E_TIMESHEETRECORDExtension include view for I_TimeSheetRecordETIMESHEETRECORD
I_AVAILABILITYBYWRKAGRMTANDDTEAvailability by Work Agreement and DateIEMPAVAILDATA
I_EMPLCONTACTCARDEmployee Contact Card for CATS ApplicationsIEMPLCONTACTCARD
I_PERSONWORKAGRMTRSCETYPEDetermine the Resource Type of Person Work AgreementIPERSWKAGRRESTYP
I_PMPROJCATSDATAKPICATS Data of employees of a Project Manager for KPI TileIPMCATSDATAKPI
I_PROJECTMGRORGDETRetrieve project details for the session userIPROJMGRORGDET
I_PROJMGRTEAMCATSAGGRGNAggregated CATS Data of Each Employee of a Project By PeriodIPMPROJCATSAGGR
I_PROJSTAFFINGDETRetrieve project staffing details for project managerIPROJSTAFFDET
I_TEAMCATSDATAFORKEYDATESEmployee Recorded and Available Data for last 3 monthsITEAMCATSDATA
I_TEAMCATSHOURSTILETeam Recorded Hours for the Last Three MonthsITEAMCATSTILE
I_TIMEOVERVIEWBYWRKAGRMTANDDTEAvailability of a Person Work AgreementIWRKAGRTMOV
I_TIMESHEETOVERTIMECATOvertime Category for TimesheetITSOVTM
I_TIMESHEETOVERTIMECATTEXTOvertime Category for Timesheet - TextITSOVTMT
I_TIMESHEETRECORDTime Recording DataITIMESHEETRECORD
I_TIMESHEETRECORDLONGTEXTNote of a Timesheet Record - TextITSTLONGTEXT
I_TIMESHEETREJECTIONREASONTEXTRejection Reason for Timesheet - TextITSTREJECTTXT
I_TIMESHEETSTATUSTEXTStatus for Timesheet Record - TextITSTSTATUSTXT
I_TIMESHEETTASKTYPETEXTTask Type for Timesheet - TextITIMSHTTSKTYP
I_TIMESHEETWRKLOCWork Location for TimesheetITSWRKLOC
I_TIMESHEETWRKLOCTEXTWork Location for Timesheet - TextITSWRKLOCTEXT
I_TIMESHTENTRIESFORAPPRVLTimesheet Entries Sent for Approval by Project ManagerITMESHTFORAPPR
I_UTILDATESINGLEREADDummy read to retrieve datesIUTILSNREAD
P_CATSDATAWITHCATEGORYCATS data with the project categoryPCATSDATA
P_CATSRECHRSFORPROJANDNONPROJCats Recorded Hrs for Project and Non project releated tasksPCATSPROJNONPROJ
P_CATSTOTALHRSPROJANDNONPROJTotal Recorded Hours for Project and Non Project TasksPCATSTOTALRECHRS
P_EMPAVAILABILTYBYPERIODRetrieving availability informationPEMPAVAILBYPER
P_EMPLOYEESUNDERLINEMANAGEREmployees Under the Logged in Line ManagerPEMPUNDRLINEMGR
P_EMPWORKINGHOURSDefault working hours for the employeesPEMPWORKHR
P_ENGMNTPROJSUPDATASupply Data of the ProjectsENGMNTPROJSUP
P_PLNDEFFORTFORDMNDTotal Planned Effort of a DemandPLNDEFFORTDMND
P_PLNDEFFORTFORDMNDAGGRPlanned Effort AggregationPLNDEFRTDMNDAGR
P_PMPROJCATSDATACATS Data of employees of a ProjectPMPROJCATSDATA
P_PMPROJSUPPLYDATAProject Plan data of a Project ManagerPMPROJSUPPLYDATA
P_PMPROJSUPPLYDATAKPIFor getting project plan data for a specified date rangePMSUPPLYDATA
P_PMPROJTIMESMAILNotify Missing Times By Manager Via MailPMPROJTIMESMAIL
P_PROJMGRCATSBYPOCATS with activiy type derived from POPROJCATSATBYPO
P_TEAMAVAILDATAFORKEYDATESAvailability data of the Employees in the selected datesPTEAMAVAILDATA
P_TEAMCATSAVAILDATACats and Availability DataPTEAMCATSAVAIL
P_TEAMEMPAVAIL3MONTHSEmployees Availabilty Hours for last 3 monthsPTEAMAVAIL
P_TEAMUTILDATESCalculation of Dates from Present to Last three monthsPTEAMDATECALC
P_TIMESHEETAPPROVEDHOURSTotal Approved HoursPTMESHTAPPRHRS
P_TIMESHEETREJECTEDHOURSTotal Rejected HoursPTMESHTRJCTHRS

Other CDS Views