I_TimeSheetRecord

Time Recording Data | view: ITIMESHEETRECORD | TRAN | Extraction: Full or Incremental | Component: Cross Application Timesheet in S/4HANA
Tables used: CATSDB
Column Name Description
TimeSheetRecord Counter for Records in Time Recording
Column Name Description
💲 Currency Key (Currency):
RecordedAmount CATS Amount
Column Name Description
📏 Unit of Measurement (UnitOfMeasure):
RecordedHours Hours
RecordedQuantity Time Sheet: Number (Unit of Measure)
Column Name Description
TimeSheetDate Date
TimeSheetCreationDate Created On
TimeSheetEntryTime Time of Entry
TimeSheetApprovedDate Date of Approval
TimeSheetLastChangedDate Date of Last Change
TimeSheetLastChangedTime Last Changed At
Column Name Description
TimeSheetStatus Processing status Show values
TimeSheetHasLongText Long Text Show values
Column Name Description Domain name
PersonWorkAgreement Personnel Number PERNR
WBSElementInternalID Receiver WBS Element PS_POSNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PurchaseOrder Sending purchase order EBELN
PurchaseOrderItem Sending purchase order item EBELP
ReceiverCostCenter Receiver Cost Center KOSTL
SenderCostCenter Sender Cost Center KOSTL
InternalOrder Receiver Order AUFNR
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
TimeSheetTaskType Task Type CATSTASKTYPE
TimeSheetTaskLevel Task Level CATSTASKLEVEL
TimeSheetTaskComponent Task component CATSTASKCOMPONENT
CompanyCode Company Code BUKRS
TimeSheetNote Short Text TEXT40
RejectionReason Reason for rejection CATSREASON
TimeSheetPredecessorRecord Reference Counter for Record to be Changed CHAR12
CreatedByUser User Creating Record USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
TimeSheetApprovedByUser Name of person who approved data UNAME
WorkflowTaskInternalID Work item ID SWW_WIID
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
TimeSheetAccountingDocument Document no. BELNR
Master Data Relations Join Conditions
Activity Type
  • ?
  • Client
  • Activity Type
  • Controlling Area
  • I_TIMESHEETRECORD.[column in domain "DATBI"] == CSLA.DATBI
  • I_TIMESHEETRECORD.MANDT == CSLA.MANDT
  • I_TIMESHEETRECORD.ACTIVITYTYPE == CSLA.LSTAR
  • I_TIMESHEETRECORD.CONTROLLINGAREA == CSLA.KOKRS
Controlling Area
  • Client
  • Controlling Area
  • I_TIMESHEETRECORD.MANDT == TKA01.MANDT
  • I_TIMESHEETRECORD.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Currency Key
  • Client
  • I_TIMESHEETRECORD.CURRENCY == TCURC.WAERS
  • I_TIMESHEETRECORD.MANDT == TCURC.MANDT
Unit of Measure for Display
  • Unit of Measure for Display
  • Client
  • I_TIMESHEETRECORD.HOURSUNITOFMEASURE == T006.MSEHI
  • I_TIMESHEETRECORD.MANDT == T006.MANDT