What is I_HCMActualActivitiesBase in SAP S/4HANA?

I_HCMActualActivitiesBase is a composite CDS view in SAP S/4HANA. Timesheet Actual Activities It contains 174 fields.

Which tables does I_HCMActualActivitiesBase read from?

I_HCMActualActivitiesBase reads data from: I_HCMTimeSheetRecord.

What VDM layer is I_HCMActualActivitiesBase?

I_HCMActualActivitiesBase is classified as a Composite view that combines data from multiple basic views.

I_HCMActualActivitiesBase

DDL: I_HCMACTUALACTIVITIESBASE Type: view_entity COMPOSITE

174 Fields 1 Data Sources 5 Associations

Timesheet Actual Activities

I_HCMActualActivitiesBase is a Composite CDS View that provides data about "Timesheet Actual Activities" in SAP S/4HANA. It reads from 1 data source (I_HCMTimeSheetRecord) and exposes 174 fields with key fields PersonnelNumber, HCMTimeShtRecdID. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_HCMTimeSheetRecord	HCMTimesheetRecord	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_CompanyCode	_HCMEmployeeCompanyCode	`$projection.HCMEmployeeCompanyCode = _HCMEmployeeCompanyCode.CompanyCode`
[0..1]	I_WBSElementData_2	_WBSElement	`HCMTimesheetRecord.HCMReceiverWBSElement = _WBSElement.WBSElementInternalID`
[1..1]	I_CalendarDate	_Date	`$projection.HCMWorkDate = _Date.CalendarDate`
[0..*]	I_HCMCurrentPayrollStatus	_HCMCurrentPayrollStatus	`$projection.PersonnelNumber = _HCMCurrentPayrollStatus.HCMPersonnelNumber`
[0..1]	I_HCMOrganizationalUnitText	_HCMOrganizationalUnit	`$projection.HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit and _HCMOrganizationalUnit.Language = $session.system_language`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Timesheet Actual Activities	view
Metadata.ignorePropagatedAnnotations	false	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
VDM.viewType	#COMPOSITE	view

Fields (174)

Key	Field	Source Table	Source Field	Description
KEY	PersonnelNumber	I_HCMTimeSheetRecord	PersonnelNumber	Personnel No.
KEY	HCMTimeShtRecdID	I_HCMTimeSheetRecord	HCMTimeShtRecdID	Version
	HCMEmployeeName	HCMOrganizationalAssignment	HCMEmployeeName	Empl./appl.name
	HCMOrganizationalUnit	HCMOrganizationalAssignment	HCMOrganizationalUnit	Org. Unit
	HCMOrganizationalUnitName	_HCMOrganizationalUnit	HCMOrganizationalUnitName
	HCMPersonnelArea	HCMOrganizationalAssignment	HCMPersonnelArea	Personnel area
	HCMPersonnelSubarea	HCMOrganizationalAssignment	HCMPersonnelSubarea	Pers. subarea
	HCMEmployeeGroup	HCMOrganizationalAssignment	HCMEmployeeGroup	EE group
	HCMEmployeeSubgroup	HCMOrganizationalAssignment	HCMEmployeeSubgroup	EE subgroup
	HCMCountryRegionGrouping
	HCMPersonnelSubareaGrouping
	HCMEmployeeCompanyCode	HCMOrganizationalAssignment	CompanyCode	Employee Company Code
	HCMEmployeeBlockingDate	_HCMCurrentPayrollStatus	HCMEmployeeBlockingDate	Blocking Date
	CalendarDate	_Date	CalendarDate	Calendar Date
	CalendarMonth	_Date	CalendarMonth	Calendar Month
	CalendarYear	_Date	CalendarYear	Year
	CalendarQuarter	_Date	CalendarQuarter	Calendar Quarter
	CalendarWeek	_Date	CalendarWeek	Calendar Week
	CalendarDay	_Date	CalendarDay	Occur Day in a Month
	YearQuarter	_Date	YearQuarter	Year Quarter
	YearMonth	_Date	YearMonth	Year Month
	YearWeek	_Date	YearWeek	Year and Calendar Week
	WeekDay	_Date	WeekDay	Weekdays
	YearDay	_Date	YearDay	Day of the year
	HCMWorkDate	I_HCMTimeSheetRecord	HCMWorkDate	Date
	HCMTimeShtRecdRecordedHrs	I_HCMTimeSheetRecord	HCMTimeShtRecdRecordedHrs
	HCMTimeShtRecdRecordedAmount	I_HCMTimeSheetRecord	HCMTimeShtRecdRecordedAmount	Amount
	HCMTimeShtRecdRecordedQuantity	I_HCMTimeSheetRecord	HCMTimeShtRecdRecordedQuantity	Number (unit)
	HCMSenderCostCenter	I_HCMTimeSheetRecord	HCMSenderCostCenter	Send. CCtr
	HCMActivityType	I_HCMTimeSheetRecord	HCMActivityType	Activity Type
	HCMSendingPurchaseOrder	I_HCMTimeSheetRecord	HCMSendingPurchaseOrder	Sending order
	HCMSendingPurchaseOrderItem	I_HCMTimeSheetRecord	HCMSendingPurchaseOrderItem	Send. PO item
	SenderBusinessProcess	I_HCMTimeSheetRecord	SenderBusinessProcess	Send.Bus.Proc.
	ActivityNumber	I_HCMTimeSheetRecord	ActivityNumber	Service number
	ReceiverCostCenter	I_HCMTimeSheetRecord	ReceiverCostCenter	Rec. CCtr
	HCMReceiverWBSElementExtID
	WBSDescription	_WBSElement	WBSDescription	WBS Element Name
	ReceiverOrder	I_HCMTimeSheetRecord	ReceiverOrder	Rec. order
	HCMNetworkNumber	I_HCMTimeSheetRecord	HCMNetworkNumber	Network
	HCMOrderRoutingNumber	I_HCMTimeSheetRecord	HCMOrderRoutingNumber	Plan No.f.Oper.
	HCMOrderID	I_HCMTimeSheetRecord	HCMOrderID	Counter
	ReceiverSalesOrder	I_HCMTimeSheetRecord	ReceiverSalesOrder	Rec. sales ord.
	ReceiverSalesOrderItem	I_HCMTimeSheetRecord	ReceiverSalesOrderItem	RecSalOrd. item
	ReceiverCostObject	I_HCMTimeSheetRecord	ReceiverCostObject	Cost object
	ReceiverBusinessProcess	I_HCMTimeSheetRecord	ReceiverBusinessProcess	Rec.bus.process
	HCMProfitabilitySegment	I_HCMTimeSheetRecord	HCMProfitabilitySegment	Profit. segment
	HCMReceiverFund	I_HCMTimeSheetRecord	HCMReceiverFund	Sender Fund
	HCMReceivingFunctionalArea	I_HCMTimeSheetRecord	HCMReceivingFunctionalArea	Receiving Func. Area
	HCMReceiverGrant	I_HCMTimeSheetRecord	HCMReceiverGrant	Receiver Grant
	HCMSenderFund	I_HCMTimeSheetRecord	HCMSenderFund	Sender Fund
	HCMSendingFunctionalArea	I_HCMTimeSheetRecord	HCMSendingFunctionalArea	Sender Fnc.Area
	HCMSenderGrant	I_HCMTimeSheetRecord	HCMSenderGrant	Sender Grant
	HCMReceiverBudgetPeriod	I_HCMTimeSheetRecord	HCMReceiverBudgetPeriod	Rec BudPer
	HCMSenderBudgetPeriod	I_HCMTimeSheetRecord	HCMSenderBudgetPeriod	Sender BudPer
	HCMAttendanceAbsenceType	I_HCMTimeSheetRecord	HCMAttendanceAbsenceType	Att./abs. type
	HCMWageType	I_HCMTimeSheetRecord	HCMWageType	Wage type
	HCMCapacityID	I_HCMTimeSheetRecord	HCMCapacityID	Capacity ID
	HCMCapacitySplit	I_HCMTimeSheetRecord	HCMCapacitySplit	Splitting
	TravelTripNumber	I_HCMTimeSheetRecord	TravelTripNumber	Trip Number
	MaterialDocument	I_HCMTimeSheetRecord	MaterialDocument	Material Doc.
	HCMOvertimeCompensationType	I_HCMTimeSheetRecord	HCMOvertimeCompensationType	OT comp. type
	HCMTaxAreaWorkCenter	I_HCMTimeSheetRecord	HCMTaxAreaWorkCenter	Tax area
	HCMValuationBasisAmount	I_HCMTimeSheetRecord	HCMValuationBasisAmount	Valuation basis
	Currency	I_HCMTimeSheetRecord	Currency	Valuation Crcy
	HCMExtraPayValuation	I_HCMTimeSheetRecord	HCMExtraPayValuation	Qty Struct. Control
	PayScaleGroup	I_HCMTimeSheetRecord	PayScaleGroup	Pay Scale Group
	PayScaleLevel	I_HCMTimeSheetRecord	PayScaleLevel	PS level
	HCMPremiumNumberCode	I_HCMTimeSheetRecord	HCMPremiumNumberCode	Premium no.
	HCMPremiumIndicatorCode	I_HCMTimeSheetRecord	HCMPremiumIndicatorCode	Premium ID
	HCMObjectType	I_HCMTimeSheetRecord	HCMObjectType	Type of Val.
	HCMPosition	I_HCMTimeSheetRecord	HCMPosition	Position
	ControllingArea	I_HCMTimeSheetRecord	ControllingArea	Controlling Area
	HCMTimeShtRecdDisplayUoM	I_HCMTimeSheetRecord	HCMTimeShtRecdDisplayUoM	Unit of Measure
	HCMTimeShtRecdTransCrcy	I_HCMTimeSheetRecord	HCMTimeShtRecdTransCrcy	Trans. Currency
	HCMTimeSheetRecordPriceInTC	I_HCMTimeSheetRecord	HCMTimeSheetRecordPriceInTC	RVP f.PricePro.
	HCMObjectID	I_HCMTimeSheetRecord	HCMObjectID	WorkCtrGp plan.
	Plant	I_HCMTimeSheetRecord	Plant	Valuation Area
	HCMOrderCategory	I_HCMTimeSheetRecord	HCMOrderCategory	Order category
	HCMMstrCostAcctgVariants	I_HCMTimeSheetRecord	HCMMstrCostAcctgVariants	Cost acc. var.
	HCMMasterCostCenter	I_HCMTimeSheetRecord	HCMMasterCostCenter	Cost center
	HCMMasterActivityType	I_HCMTimeSheetRecord	HCMMasterActivityType	Activity type
	HCMMasterFund	I_HCMTimeSheetRecord	HCMMasterFund	Master Fund
	HCMMasterFunctionalArea	I_HCMTimeSheetRecord	HCMMasterFunctionalArea	MasterFunc.Area
	HCMMasterGrant	I_HCMTimeSheetRecord	HCMMasterGrant	Master Grant
	HCMAccountingIndicatorCode	I_HCMTimeSheetRecord	HCMAccountingIndicatorCode	AcctIndicator
	HCMTimeShtRecdUoM	I_HCMTimeSheetRecord	HCMTimeShtRecdUoM	UoM
	HCMStatisticalKeyFigure	I_HCMTimeSheetRecord	HCMStatisticalKeyFigure	Stat. key fig.
	TaskType	I_HCMTimeSheetRecord	TaskType	Task Type
	HCMTaskLevel	I_HCMTimeSheetRecord	HCMTaskLevel	Task level
	HCMTaskComponent	I_HCMTimeSheetRecord	HCMTaskComponent	Task component
	CompanyCode	I_HCMTimeSheetRecord	CompanyCode	Receiver Company Code
	HCMProjectUUID	I_HCMTimeSheetRecord	HCMProjectUUID
	HCMExternalProjectID	I_HCMTimeSheetRecord	HCMExternalProjectID	Project
	HCMProjectObjectUUID	I_HCMTimeSheetRecord	HCMProjectObjectUUID	Subobject
	HCMProjectSubObjectID	I_HCMTimeSheetRecord	HCMProjectSubObjectID	Subobject
	HCMProjectObjectType	I_HCMTimeSheetRecord	HCMProjectObjectType	Object Type
	HCMMasterBudgetPeriod	I_HCMTimeSheetRecord	HCMMasterBudgetPeriod	MasterBP
	HCMTimeShtRecdCreationDate	I_HCMTimeSheetRecord	HCMTimeShtRecdCreationDate	Entry Date
	HCMTimeShtRecdCreationTime	I_HCMTimeSheetRecord	HCMTimeShtRecdCreationTime	Time
	HCMTimeShtRecdCreatedByUser	I_HCMTimeSheetRecord	HCMTimeShtRecdCreatedByUser	User Name
	HCMTimeShtRecdLastChangedDate	I_HCMTimeSheetRecord	HCMTimeShtRecdLastChangedDate	Last Change
	HCMTimeShtRecdLastChangedTime	I_HCMTimeSheetRecord	HCMTimeShtRecdLastChangedTime	Time
	HCMTimeShtRecdLastChgdByUser	I_HCMTimeSheetRecord	HCMTimeShtRecdLastChgdByUser	User Name
	HCMTimeShtRecdApprovedByUser	I_HCMTimeSheetRecord	HCMTimeShtRecdApprovedByUser	Approved by
	HCMTimeShtRecdApprovalDate	I_HCMTimeSheetRecord	HCMTimeShtRecdApprovalDate	Approval date
	HCMWorkItemID	I_HCMTimeSheetRecord	HCMWorkItemID	Work Item ID
	HCMLogicalSystemID	I_HCMTimeSheetRecord	HCMLogicalSystemID	Source system
	HCMTimeShtRecdProcessingStatus	I_HCMTimeSheetRecord	HCMTimeShtRecdProcessingStatus	Workflow Status
	HCMTimeShtRecdRefNumber	I_HCMTimeSheetRecord	HCMTimeShtRecdRefNumber	Ref. counter
	HCMTimeShtRecdRejectionReason	I_HCMTimeSheetRecord	HCMTimeShtRecdRejectionReason	Sp.Tax Code Reason
	HCMTimeShtRecdAcctgDoc	I_HCMTimeSheetRecord	HCMTimeShtRecdAcctgDoc	SD Document
	HCMLogicalSystemOfSourceDoc	I_HCMTimeSheetRecord	HCMLogicalSystemOfSourceDoc	Logical system
	HCMExternalApplication	I_HCMTimeSheetRecord	HCMExternalApplication	External appl.
	HCMExternalDocument	I_HCMTimeSheetRecord	HCMExternalDocument	Document no.
	HCMTaskNumber	I_HCMTimeSheetRecord	HCMTaskNumber	Task number
	HCMTimeShtRecdStartTime	I_HCMTimeSheetRecord	HCMTimeShtRecdStartTime	Start time
	HCMTimeShtRecdEndTime	I_HCMTimeSheetRecord	HCMTimeShtRecdEndTime	End time
	HCMTimeShtRecdIsForPrevDay	I_HCMTimeSheetRecord	HCMTimeShtRecdIsForPrevDay	Previous day
	HCMTimeShtRecdIsForFullDay	I_HCMTimeSheetRecord	HCMTimeShtRecdIsForFullDay	Full-day
	HCMRemainingWorkQuantity	I_HCMTimeSheetRecord	HCMRemainingWorkQuantity	Remaining work
	HCMTmeShtRecdAutomConfPrpsl	I_HCMTimeSheetRecord	HCMTmeShtRecdAutomConfPrpsl	Final Confirmtn
	HCMShortTextComment	I_HCMTimeSheetRecord	HCMShortTextComment	Short Text
	HCMCommentIsLongText	I_HCMTimeSheetRecord	HCMCommentIsLongText	Text Name
	HCMTimeShtRecdHasPrtlConfirm	I_HCMTimeSheetRecord	HCMTimeShtRecdHasPrtlConfirm	Part. con.
	HCMTimeShtEndDate	I_HCMTimeSheetRecord	HCMTimeShtEndDate
	CapacityCategory
	_Date		_Date
	_HCMEmployeeCompanyCode		_HCMEmployeeCompanyCode
	_HCMCurrentPayrollStatus		_HCMCurrentPayrollStatus
	_ControllingArea	I_HCMTimeSheetRecord	_ControllingArea
	_CompanyCode	I_HCMTimeSheetRecord	_CompanyCode
	_MasterCostCenter	I_HCMTimeSheetRecord	_MasterCostCenter
	_SenderCostCenter	I_HCMTimeSheetRecord	_SenderCostCenter
	_ReceiverCostCenter	I_HCMTimeSheetRecord	_ReceiverCostCenter
	_ReceiverSalesOrder	I_HCMTimeSheetRecord	_ReceiverSalesOrder
	_ReceiverSalesOrderItem	I_HCMTimeSheetRecord	_ReceiverSalesOrderItem
	_ReceiverBusinessProcess	I_HCMTimeSheetRecord	_ReceiverBusinessProcess
	_ReceivingFunctionalArea	I_HCMTimeSheetRecord	_ReceivingFunctionalArea
	_ReceiverGrant	I_HCMTimeSheetRecord	_ReceiverGrant
	_SendingFunctionalArea	I_HCMTimeSheetRecord	_SendingFunctionalArea
	_SenderGrant	I_HCMTimeSheetRecord	_SenderGrant
	_ReceiverBudgetPeriod	I_HCMTimeSheetRecord	_ReceiverBudgetPeriod
	_SenderBudgetPeriod	I_HCMTimeSheetRecord	_SenderBudgetPeriod
	_HCMCapacityID	I_HCMTimeSheetRecord	_HCMCapacityID
	_Currency	I_HCMTimeSheetRecord	_Currency
	_Plant	I_HCMTimeSheetRecord	_Plant
	_OrderCategory	I_HCMTimeSheetRecord	_OrderCategory
	_MasterFunctionalArea	I_HCMTimeSheetRecord	_MasterFunctionalArea
	_MasterGrant	I_HCMTimeSheetRecord	_MasterGrant
	_StatisticalKeyFigure	I_HCMTimeSheetRecord	_StatisticalKeyFigure
	_UnitOfMeasure	I_HCMTimeSheetRecord	_UnitOfMeasure
	_MasterBudgetPeriod	I_HCMTimeSheetRecord	_MasterBudgetPeriod
	_AccountingIndicator	I_HCMTimeSheetRecord	_AccountingIndicator
	_HCMSendingPurchaseOrderItem	I_HCMTimeSheetRecord	_HCMSendingPurchaseOrderItem
	_HCMSendingPurchaseOrder	I_HCMTimeSheetRecord	_HCMSendingPurchaseOrder
	_SenderBusinessProcess	I_HCMTimeSheetRecord	_SenderBusinessProcess
	_ActivityNumber	I_HCMTimeSheetRecord	_ActivityNumber
	_HCMNetworkNumber	I_HCMTimeSheetRecord	_HCMNetworkNumber
	_HCMObjectType	I_HCMTimeSheetRecord	_HCMObjectType
	_HCMPosition	I_HCMTimeSheetRecord	_HCMPosition
	_HCMReceivingFunctionalArea	I_HCMTimeSheetRecord	_HCMReceivingFunctionalArea
	_HCMReceiverGrant	I_HCMTimeSheetRecord	_HCMReceiverGrant
	_ReceiverOrder	I_HCMTimeSheetRecord	_ReceiverOrder
	_HCMTimeShtRecdDisplayUoM	I_HCMTimeSheetRecord	_HCMTimeShtRecdDisplayUoM
	_TaskType	I_HCMTimeSheetRecord	_TaskType
	_HCMTmeShtRecdAutomConfPrpsl	I_HCMTimeSheetRecord	_HCMTmeShtRecdAutomConfPrpsl
	_HCMOvertimeCompensationType	I_HCMTimeSheetRecord	_HCMOvertimeCompensationType
	_HCMTaxAreaWorkCenter	I_HCMTimeSheetRecord	_HCMTaxAreaWorkCenter
	_HCMTaskLevel	I_HCMTimeSheetRecord	_HCMTaskLevel
	_HCMTaskComponent	I_HCMTimeSheetRecord	_HCMTaskComponent
	_HCMPersonnelArea	HCMOrganizationalAssignment	_HCMPersonnelArea
	_HCMPersonnelSubarea	HCMOrganizationalAssignment	_HCMPersonnelSubarea
	_HCMEmployeeGroup	HCMOrganizationalAssignment	_HCMEmployeeGroup
	_HCMEmployeeSubGroup	HCMOrganizationalAssignment	_HCMEmployeeSubGroup

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_HCMActualActivitiesBase.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_HCMActualActivitiesBase AS
SELECT
  HCMTimesheetRecord.PersonnelNumber AS PersonnelNumber,
  HCMTimesheetRecord.HCMTimeShtRecdID AS HCMTimeShtRecdID,
  HCMOrganizationalAssignment.HCMEmployeeName AS HCMEmployeeName,
  HCMOrganizationalAssignment.HCMOrganizationalUnit AS HCMOrganizationalUnit,
  _HCMOrganizationalUnit.HCMOrganizationalUnitName AS HCMOrganizationalUnitName,
  HCMOrganizationalAssignment.HCMPersonnelArea AS HCMPersonnelArea,
  HCMOrganizationalAssignment.HCMPersonnelSubarea AS HCMPersonnelSubarea,
  HCMOrganizationalAssignment.HCMEmployeeGroup AS HCMEmployeeGroup,
  HCMOrganizationalAssignment.HCMEmployeeSubgroup AS HCMEmployeeSubgroup,
  HCMOrganizationalAssignment._HCMPersonnelArea.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  HCMOrganizationalAssignment._HCMPersonnelSubarea.HCMPersonnelSubareaGrouping AS HCMPersonnelSubareaGrouping,
  HCMOrganizationalAssignment.CompanyCode AS HCMEmployeeCompanyCode,
  _HCMCurrentPayrollStatus.HCMEmployeeBlockingDate AS HCMEmployeeBlockingDate,
  _Date.CalendarDate AS CalendarDate,
  _Date.CalendarMonth AS CalendarMonth,
  _Date.CalendarYear AS CalendarYear,
  _Date.CalendarQuarter AS CalendarQuarter,
  _Date.CalendarWeek AS CalendarWeek,
  _Date.CalendarDay AS CalendarDay,
  _Date.YearQuarter AS YearQuarter,
  _Date.YearMonth AS YearMonth,
  _Date.YearWeek AS YearWeek,
  _Date.WeekDay AS WeekDay,
  _Date.YearDay AS YearDay,
  HCMTimesheetRecord.HCMWorkDate AS HCMWorkDate,
  HCMTimesheetRecord.HCMTimeShtRecdRecordedHrs AS HCMTimeShtRecdRecordedHrs,
  HCMTimesheetRecord.HCMTimeShtRecdRecordedAmount AS HCMTimeShtRecdRecordedAmount,
  HCMTimesheetRecord.HCMTimeShtRecdRecordedQuantity AS HCMTimeShtRecdRecordedQuantity,
  HCMTimesheetRecord.HCMSenderCostCenter AS HCMSenderCostCenter,
  HCMTimesheetRecord.HCMActivityType AS HCMActivityType,
  HCMTimesheetRecord.HCMSendingPurchaseOrder AS HCMSendingPurchaseOrder,
  HCMTimesheetRecord.HCMSendingPurchaseOrderItem AS HCMSendingPurchaseOrderItem,
  HCMTimesheetRecord.SenderBusinessProcess AS SenderBusinessProcess,
  HCMTimesheetRecord.ActivityNumber AS ActivityNumber,
  HCMTimesheetRecord.ReceiverCostCenter AS ReceiverCostCenter,
  cast(_WBSElement.WBSElement as ps_s4_posid) AS HCMReceiverWBSElementExtID,
  _WBSElement.WBSDescription AS WBSDescription,
  HCMTimesheetRecord.ReceiverOrder AS ReceiverOrder,
  HCMTimesheetRecord.HCMNetworkNumber AS HCMNetworkNumber,
  HCMTimesheetRecord.HCMOrderRoutingNumber AS HCMOrderRoutingNumber,
  HCMTimesheetRecord.HCMOrderID AS HCMOrderID,
  HCMTimesheetRecord.ReceiverSalesOrder AS ReceiverSalesOrder,
  HCMTimesheetRecord.ReceiverSalesOrderItem AS ReceiverSalesOrderItem,
  HCMTimesheetRecord.ReceiverCostObject AS ReceiverCostObject,
  HCMTimesheetRecord.ReceiverBusinessProcess AS ReceiverBusinessProcess,
  HCMTimesheetRecord.HCMProfitabilitySegment AS HCMProfitabilitySegment,
  HCMTimesheetRecord.HCMReceiverFund AS HCMReceiverFund,
  HCMTimesheetRecord.HCMReceivingFunctionalArea AS HCMReceivingFunctionalArea,
  HCMTimesheetRecord.HCMReceiverGrant AS HCMReceiverGrant,
  HCMTimesheetRecord.HCMSenderFund AS HCMSenderFund,
  HCMTimesheetRecord.HCMSendingFunctionalArea AS HCMSendingFunctionalArea,
  HCMTimesheetRecord.HCMSenderGrant AS HCMSenderGrant,
  HCMTimesheetRecord.HCMReceiverBudgetPeriod AS HCMReceiverBudgetPeriod,
  HCMTimesheetRecord.HCMSenderBudgetPeriod AS HCMSenderBudgetPeriod,
  HCMTimesheetRecord.HCMAttendanceAbsenceType AS HCMAttendanceAbsenceType,
  HCMTimesheetRecord.HCMWageType AS HCMWageType,
  HCMTimesheetRecord.HCMCapacityID AS HCMCapacityID,
  HCMTimesheetRecord.HCMCapacitySplit AS HCMCapacitySplit,
  HCMTimesheetRecord.TravelTripNumber AS TravelTripNumber,
  HCMTimesheetRecord.MaterialDocument AS MaterialDocument,
  HCMTimesheetRecord.HCMOvertimeCompensationType AS HCMOvertimeCompensationType,
  HCMTimesheetRecord.HCMTaxAreaWorkCenter AS HCMTaxAreaWorkCenter,
  HCMTimesheetRecord.HCMValuationBasisAmount AS HCMValuationBasisAmount,
  HCMTimesheetRecord.Currency AS Currency,
  HCMTimesheetRecord.HCMExtraPayValuation AS HCMExtraPayValuation,
  HCMTimesheetRecord.PayScaleGroup AS PayScaleGroup,
  HCMTimesheetRecord.PayScaleLevel AS PayScaleLevel,
  HCMTimesheetRecord.HCMPremiumNumberCode AS HCMPremiumNumberCode,
  HCMTimesheetRecord.HCMPremiumIndicatorCode AS HCMPremiumIndicatorCode,
  HCMTimesheetRecord.HCMObjectType AS HCMObjectType,
  HCMTimesheetRecord.HCMPosition AS HCMPosition,
  HCMTimesheetRecord.ControllingArea AS ControllingArea,
  HCMTimesheetRecord.HCMTimeShtRecdDisplayUoM AS HCMTimeShtRecdDisplayUoM,
  HCMTimesheetRecord.HCMTimeShtRecdTransCrcy AS HCMTimeShtRecdTransCrcy,
  HCMTimesheetRecord.HCMTimeSheetRecordPriceInTC AS HCMTimeSheetRecordPriceInTC,
  HCMTimesheetRecord.HCMObjectID AS HCMObjectID,
  HCMTimesheetRecord.Plant AS Plant,
  HCMTimesheetRecord.HCMOrderCategory AS HCMOrderCategory,
  HCMTimesheetRecord.HCMMstrCostAcctgVariants AS HCMMstrCostAcctgVariants,
  HCMTimesheetRecord.HCMMasterCostCenter AS HCMMasterCostCenter,
  HCMTimesheetRecord.HCMMasterActivityType AS HCMMasterActivityType,
  HCMTimesheetRecord.HCMMasterFund AS HCMMasterFund,
  HCMTimesheetRecord.HCMMasterFunctionalArea AS HCMMasterFunctionalArea,
  HCMTimesheetRecord.HCMMasterGrant AS HCMMasterGrant,
  HCMTimesheetRecord.HCMAccountingIndicatorCode AS HCMAccountingIndicatorCode,
  HCMTimesheetRecord.HCMTimeShtRecdUoM AS HCMTimeShtRecdUoM,
  HCMTimesheetRecord.HCMStatisticalKeyFigure AS HCMStatisticalKeyFigure,
  HCMTimesheetRecord.TaskType AS TaskType,
  HCMTimesheetRecord.HCMTaskLevel AS HCMTaskLevel,
  HCMTimesheetRecord.HCMTaskComponent AS HCMTaskComponent,
  HCMTimesheetRecord.CompanyCode AS CompanyCode,
  HCMTimesheetRecord.HCMProjectUUID AS HCMProjectUUID,
  HCMTimesheetRecord.HCMExternalProjectID AS HCMExternalProjectID,
  HCMTimesheetRecord.HCMProjectObjectUUID AS HCMProjectObjectUUID,
  HCMTimesheetRecord.HCMProjectSubObjectID AS HCMProjectSubObjectID,
  HCMTimesheetRecord.HCMProjectObjectType AS HCMProjectObjectType,
  HCMTimesheetRecord.HCMMasterBudgetPeriod AS HCMMasterBudgetPeriod,
  HCMTimesheetRecord.HCMTimeShtRecdCreationDate AS HCMTimeShtRecdCreationDate,
  HCMTimesheetRecord.HCMTimeShtRecdCreationTime AS HCMTimeShtRecdCreationTime,
  HCMTimesheetRecord.HCMTimeShtRecdCreatedByUser AS HCMTimeShtRecdCreatedByUser,
  HCMTimesheetRecord.HCMTimeShtRecdLastChangedDate AS HCMTimeShtRecdLastChangedDate,
  HCMTimesheetRecord.HCMTimeShtRecdLastChangedTime AS HCMTimeShtRecdLastChangedTime,
  HCMTimesheetRecord.HCMTimeShtRecdLastChgdByUser AS HCMTimeShtRecdLastChgdByUser,
  HCMTimesheetRecord.HCMTimeShtRecdApprovedByUser AS HCMTimeShtRecdApprovedByUser,
  HCMTimesheetRecord.HCMTimeShtRecdApprovalDate AS HCMTimeShtRecdApprovalDate,
  HCMTimesheetRecord.HCMWorkItemID AS HCMWorkItemID,
  HCMTimesheetRecord.HCMLogicalSystemID AS HCMLogicalSystemID,
  HCMTimesheetRecord.HCMTimeShtRecdProcessingStatus AS HCMTimeShtRecdProcessingStatus,
  HCMTimesheetRecord.HCMTimeShtRecdRefNumber AS HCMTimeShtRecdRefNumber,
  HCMTimesheetRecord.HCMTimeShtRecdRejectionReason AS HCMTimeShtRecdRejectionReason,
  HCMTimesheetRecord.HCMTimeShtRecdAcctgDoc AS HCMTimeShtRecdAcctgDoc,
  HCMTimesheetRecord.HCMLogicalSystemOfSourceDoc AS HCMLogicalSystemOfSourceDoc,
  HCMTimesheetRecord.HCMExternalApplication AS HCMExternalApplication,
  HCMTimesheetRecord.HCMExternalDocument AS HCMExternalDocument,
  HCMTimesheetRecord.HCMTaskNumber AS HCMTaskNumber,
  HCMTimesheetRecord.HCMTimeShtRecdStartTime AS HCMTimeShtRecdStartTime,
  HCMTimesheetRecord.HCMTimeShtRecdEndTime AS HCMTimeShtRecdEndTime,
  HCMTimesheetRecord.HCMTimeShtRecdIsForPrevDay AS HCMTimeShtRecdIsForPrevDay,
  HCMTimesheetRecord.HCMTimeShtRecdIsForFullDay AS HCMTimeShtRecdIsForFullDay,
  HCMTimesheetRecord.HCMRemainingWorkQuantity AS HCMRemainingWorkQuantity,
  HCMTimesheetRecord.HCMTmeShtRecdAutomConfPrpsl AS HCMTmeShtRecdAutomConfPrpsl,
  HCMTimesheetRecord.HCMShortTextComment AS HCMShortTextComment,
  HCMTimesheetRecord.HCMCommentIsLongText AS HCMCommentIsLongText,
  HCMTimesheetRecord.HCMTimeShtRecdHasPrtlConfirm AS HCMTimeShtRecdHasPrtlConfirm,
  HCMTimesheetRecord.HCMTimeShtEndDate AS HCMTimeShtEndDate,
  HCMTimesheetRecord._HCMCapacityID.CapacityCategoryCode AS CapacityCategory,
  HCMTimesheetRecord._ControllingArea AS _ControllingArea,
  HCMTimesheetRecord._CompanyCode AS _CompanyCode,
  HCMTimesheetRecord._MasterCostCenter AS _MasterCostCenter,
  HCMTimesheetRecord._SenderCostCenter AS _SenderCostCenter,
  HCMTimesheetRecord._ReceiverCostCenter AS _ReceiverCostCenter,
  HCMTimesheetRecord._ReceiverSalesOrder AS _ReceiverSalesOrder,
  HCMTimesheetRecord._ReceiverSalesOrderItem AS _ReceiverSalesOrderItem,
  HCMTimesheetRecord._ReceiverBusinessProcess AS _ReceiverBusinessProcess,
  HCMTimesheetRecord._ReceivingFunctionalArea AS _ReceivingFunctionalArea,
  HCMTimesheetRecord._ReceiverGrant AS _ReceiverGrant,
  HCMTimesheetRecord._SendingFunctionalArea AS _SendingFunctionalArea,
  HCMTimesheetRecord._SenderGrant AS _SenderGrant,
  HCMTimesheetRecord._ReceiverBudgetPeriod AS _ReceiverBudgetPeriod,
  HCMTimesheetRecord._SenderBudgetPeriod AS _SenderBudgetPeriod,
  HCMTimesheetRecord._HCMCapacityID AS _HCMCapacityID,
  HCMTimesheetRecord._Currency AS _Currency,
  HCMTimesheetRecord._Plant AS _Plant,
  HCMTimesheetRecord._OrderCategory AS _OrderCategory,
  HCMTimesheetRecord._MasterFunctionalArea AS _MasterFunctionalArea,
  HCMTimesheetRecord._MasterGrant AS _MasterGrant,
  HCMTimesheetRecord._StatisticalKeyFigure AS _StatisticalKeyFigure,
  HCMTimesheetRecord._UnitOfMeasure AS _UnitOfMeasure,
  HCMTimesheetRecord._MasterBudgetPeriod AS _MasterBudgetPeriod,
  HCMTimesheetRecord._AccountingIndicator AS _AccountingIndicator,
  HCMTimesheetRecord._HCMSendingPurchaseOrderItem AS _HCMSendingPurchaseOrderItem,
  HCMTimesheetRecord._HCMSendingPurchaseOrder AS _HCMSendingPurchaseOrder,
  HCMTimesheetRecord._SenderBusinessProcess AS _SenderBusinessProcess,
  HCMTimesheetRecord._ActivityNumber AS _ActivityNumber,
  HCMTimesheetRecord._HCMNetworkNumber AS _HCMNetworkNumber,
  HCMTimesheetRecord._HCMObjectType AS _HCMObjectType,
  HCMTimesheetRecord._HCMPosition AS _HCMPosition,
  HCMTimesheetRecord._HCMReceivingFunctionalArea AS _HCMReceivingFunctionalArea,
  HCMTimesheetRecord._HCMReceiverGrant AS _HCMReceiverGrant,
  HCMTimesheetRecord._ReceiverOrder AS _ReceiverOrder,
  HCMTimesheetRecord._HCMTimeShtRecdDisplayUoM AS _HCMTimeShtRecdDisplayUoM,
  HCMTimesheetRecord._TaskType AS _TaskType,
  HCMTimesheetRecord._HCMTmeShtRecdAutomConfPrpsl AS _HCMTmeShtRecdAutomConfPrpsl,
  HCMTimesheetRecord._HCMOvertimeCompensationType AS _HCMOvertimeCompensationType,
  HCMTimesheetRecord._HCMTaxAreaWorkCenter AS _HCMTaxAreaWorkCenter,
  HCMTimesheetRecord._HCMTaskLevel AS _HCMTaskLevel,
  HCMTimesheetRecord._HCMTaskComponent AS _HCMTaskComponent,
  HCMOrganizationalAssignment._HCMPersonnelArea AS _HCMPersonnelArea,
  HCMOrganizationalAssignment._HCMPersonnelSubarea AS _HCMPersonnelSubarea,
  HCMOrganizationalAssignment._HCMEmployeeGroup AS _HCMEmployeeGroup,
  HCMOrganizationalAssignment._HCMEmployeeSubGroup AS _HCMEmployeeSubGroup
FROM I_HCMTimeSheetRecord AS HCMTimesheetRecord
LEFT OUTER JOIN I_CompanyCode AS _HCMEmployeeCompanyCode ON HCMEmployeeCompanyCode = _HCMEmployeeCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON HCMTimesheetRecord.HCMReceiverWBSElement = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _Date ON HCMWorkDate = _Date.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_HCMCurrentPayrollStatus AS _HCMCurrentPayrollStatus ON PersonnelNumber = _HCMCurrentPayrollStatus.HCMPersonnelNumber  -- association [0..*]
LEFT OUTER JOIN I_HCMOrganizationalUnitText AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit AND _HCMOrganizationalUnit.Language = $session.system_language  -- association [0..1]
;

Depth:

I_HCMActualActivitiesBase view_entity

I_HCMTimeSheetRecord view

I_HCMActualActivities view