P_TimeShtHrsAnlysForProjects

Staffing - Timesheet Analysis of Hours spent in Projects | view: PTSANLYS4PROJ | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Tables used: CATSDBPROJPRPS
Column Name Description
Column Name Description
Column Name Description
RecordedHours null
UnapprovedHours null
ApprovedHours null
Column Name Description
TimeSheetDate Date
Column Name Description
TimeSheetStatus Processing status Show values
Column Name Description Domain name
TimeSheetRecord Counter for Records in Time Recording CHAR12
PersonWorkAgreement Personnel Number PERNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WBSElementInternalID Receiver WBS Element PS_POSNR
FiscalYearPeriod null
FiscalYear null
FiscalPeriod null
PurchaseOrder Sending purchase order EBELN
PurchaseOrderItem Sending purchase order item EBELP
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
TimeSheetPredecessorRecord Reference Counter for Record to be Changed CHAR12
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
Master Data Relations Join Conditions
Activity Type
  • ?
  • Activity Type
  • Client
  • ?
  • P_TIMESHTHRSANLYSFORPROJECTS.[column in domain "DATBI"] == CSLA.DATBI
  • P_TIMESHTHRSANLYSFORPROJECTS.ACTIVITYTYPE == CSLA.LSTAR
  • P_TIMESHTHRSANLYSFORPROJECTS.MANDT == CSLA.MANDT
  • P_TIMESHTHRSANLYSFORPROJECTS.[column in domain "KOKRS"] == CSLA.KOKRS
Unit of Measure for Display
  • Client
  • Unit of Measure for Display
  • P_TIMESHTHRSANLYSFORPROJECTS.MANDT == T006.MANDT
  • P_TIMESHTHRSANLYSFORPROJECTS.HOURSUNITOFMEASURE == T006.MSEHI
Profile ID for project structure
  • Project Profile
  • Client
  • P_TIMESHTHRSANLYSFORPROJECTS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • P_TIMESHTHRSANLYSFORPROJECTS.MANDT == TCJ41.MANDT