I_HCMActualActivities

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_HCMActualActivities.
-- 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_HCMActualActivities AS
SELECT
  PersonnelNumber,
  HCMTimeShtRecdID,
  cast('00000000' as pernr_d) AS HCMTimeShtRecdApproverID,
  HCMEmployeeName,
  HCMOrganizationalUnit,
  HCMOrganizationalUnitName,
  HCMPersonnelArea,
  HCMPersonnelSubarea,
  HCMEmployeeGroup,
  HCMEmployeeSubgroup,
  HCMCountryRegionGrouping,
  HCMPersonnelSubareaGrouping,
  HCMEmployeeCompanyCode,
  HCMEmployeeBlockingDate,
  CalendarDate,
  CalendarMonth,
  CalendarYear,
  CalendarQuarter,
  CalendarWeek,
  CalendarDay,
  YearQuarter,
  YearMonth,
  YearWeek,
  WeekDay,
  YearDay,
  HCMWorkDate,
  HCMTimeShtRecdRecordedHrs,
  HCMTimeShtRecdRecordedAmount,
  HCMTimeShtRecdRecordedQuantity,
  HCMSenderCostCenter,
  HCMActivityType,
  HCMSendingPurchaseOrder,
  HCMSendingPurchaseOrderItem,
  SenderBusinessProcess,
  ActivityNumber,
  ReceiverCostCenter,
  HCMReceiverWBSElementExtID,
  WBSDescription,
  ReceiverOrder,
  HCMNetworkNumber,
  HCMOrderRoutingNumber,
  HCMOrderID,
  ReceiverSalesOrder,
  ReceiverSalesOrderItem,
  ReceiverCostObject,
  ReceiverBusinessProcess,
  HCMProfitabilitySegment,
  HCMReceiverFund,
  HCMReceivingFunctionalArea,
  HCMReceiverGrant,
  HCMSenderFund,
  HCMSendingFunctionalArea,
  HCMSenderGrant,
  HCMReceiverBudgetPeriod,
  HCMSenderBudgetPeriod,
  HCMAttendanceAbsenceType,
  HCMWageType,
  HCMCapacityID,
  HCMCapacitySplit,
  TravelTripNumber,
  MaterialDocument,
  HCMOvertimeCompensationType,
  HCMTaxAreaWorkCenter,
  HCMValuationBasisAmount,
  Currency,
  HCMExtraPayValuation,
  PayScaleGroup,
  PayScaleLevel,
  HCMPremiumNumberCode,
  HCMPremiumIndicatorCode,
  HCMObjectType,
  HCMPosition,
  ControllingArea,
  HCMTimeShtRecdDisplayUoM,
  HCMTimeShtRecdTransCrcy,
  HCMTimeSheetRecordPriceInTC,
  HCMObjectID,
  Plant,
  HCMOrderCategory,
  HCMMstrCostAcctgVariants,
  HCMMasterCostCenter,
  HCMMasterActivityType,
  HCMMasterFund,
  HCMMasterFunctionalArea,
  HCMMasterGrant,
  HCMAccountingIndicatorCode,
  HCMTimeShtRecdUoM,
  HCMStatisticalKeyFigure,
  TaskType,
  HCMTaskLevel,
  HCMTaskComponent,
  CompanyCode,
  HCMProjectUUID,
  HCMExternalProjectID,
  HCMProjectObjectUUID,
  HCMProjectSubObjectID,
  HCMProjectObjectType,
  HCMMasterBudgetPeriod,
  HCMTimeShtRecdCreationDate,
  HCMTimeShtRecdCreationTime,
  HCMTimeShtRecdCreatedByUser,
  HCMTimeShtRecdLastChangedDate,
  HCMTimeShtRecdLastChangedTime,
  HCMTimeShtRecdLastChgdByUser,
  HCMTimeShtRecdApprovedByUser,
  HCMTimeShtRecdApprovalDate,
  HCMWorkItemID,
  HCMLogicalSystemID,
  HCMTimeShtRecdProcessingStatus,
  HCMTimeShtRecdRefNumber,
  HCMTimeShtRecdRejectionReason,
  HCMTimeShtRecdAcctgDoc,
  HCMLogicalSystemOfSourceDoc,
  HCMExternalApplication,
  HCMExternalDocument,
  HCMTaskNumber,
  HCMTimeShtRecdStartTime,
  HCMTimeShtRecdEndTime,
  HCMTimeShtRecdIsForPrevDay,
  HCMTimeShtRecdIsForFullDay,
  HCMRemainingWorkQuantity,
  HCMTmeShtRecdAutomConfPrpsl,
  HCMShortTextComment,
  HCMCommentIsLongText,
  HCMTimeShtRecdHasPrtlConfirm,
  CapacityCategory,
  _HCMAttendanceAbsenceType.HCMAttendanceAbsenceTypeName AS HCMAttendanceAbsenceTypeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _HCMEmployeeCompanyCode.CompanyCodeName AS HCMCompanyCodeName,
  _MasterCostCenter.CostCenterName AS MasterCostCenterName,
  _SenderCostCenter.CostCenterName AS SenderCostCenterName,
  _ReceiverCostCenter.CostCenterName AS ReceiverCostCenterName,
  _ReceiverBusinessProcess.BusinessProcessName AS ReceiverBusinessProcessName,
  _ReceivingFunctionalArea.FunctionalAreaName AS ReceivingFunctionalAreaName,
  _ReceiverGrant.GrantName AS ReceiverGrantName,
  _SendingFunctionalArea.FunctionalAreaName AS SendingFunctionalAreaName,
  _SenderGrant.GrantName AS SenderGrantName,
  _ReceiverBudgetPeriod.BudgetPeriodName AS ReceiverBudgetPeriodName,
  _SenderBudgetPeriod.BudgetPeriodName AS SenderBudgetPeriodName,
  _HCMCapacityID.CapacityText AS CapacityText,
  _Currency.CurrencyName AS CurrencyName,
  _HCMTimeShtRecdTransCrcy.CurrencyName AS TransactionCurrencyName,
  _Plant.PlantName AS PlantName,
  _OrderCategory.OrderCategoryName AS OrderCategoryName,
  _MasterFunctionalArea.FunctionalAreaName AS MasterFunctionalAreaName,
  _MasterGrant.GrantName AS MasterGrantName,
  _StatisticalKeyFigure.StatisticalKeyFigureName AS StatisticalKeyFigureName,
  _UnitOfMeasure.UnitOfMeasureName AS UnitOfMeasureName,
  _MasterBudgetPeriod.BudgetPeriodName AS MasterBudgetPeriodName,
  _AccountingIndicator.BillableControlName AS BillableControlName,
  _SenderBusinessProcess.BusinessProcessName AS SenderBusinessProcessName,
  _ActivityNumber.HCMTimeShtActivityNumberText AS HCMTimeShtActivityNumberText,
  _HCMNetworkNumber.ProjectNetworkDescription AS ProjectNetworkDescription,
  _HCMObjectType.HCMObjectTypeName AS HCMObjectTypeName,
  _HCMPosition.HCMPositionName AS HCMPositionName,
  _ReceiverOrder.OrderDescription AS OrderDescription,
  _HCMTimeShtRecdDisplayUoM.UnitOfMeasureName AS HCMTimeShtRecdDisplayUoMName,
  _TaskType.TimeSheetTaskTypeText AS TimeSheetTaskTypeText,
  _HCMTmeShtRecdAutomConfPrpsl.FinalConfirmationTypeName AS FinalConfirmationTypeName,
  _HCMOvertimeCompensationType.HCMOvertimeCompensationTypeTxt AS HCMOvertimeCompensationTypeTxt,
  _CapacityCategory.CapacityCategoryName AS CapacityCategoryName,
  _HCMTaxAreaWorkCenter.HCMWorkTaxAreaName AS HCMWorkTaxAreaName,
  _HCMTaskLevel.HCMTaskLevelName AS HCMTaskLevelName,
  _HCMTaskComponent.HCMTaskComponentName AS HCMTaskComponentName,
  _HCMPersonnelArea.HCMPersonnelAreaName AS HCMPersonnelAreaName,
  _HCMPersonnelSubarea.PersonnelSubareaName AS HCMPersonnelSubareaName,
  _HCMEmployeeGroup.HCMEmployeeGroupName AS HCMEmployeeGroupName,
  _HCMEmployeeSubGroup.HCMEmployeeSubgroupName AS HCMEmployeeSubgroupName,
  _LogicalSystem.LogicalSystemName AS LogicalSystemName,
  _HCMLogicalSystemOfSourceDoc.LogicalSystemName AS HCMLogicalSystemSourceDocName,
  _HCMTmeShtRecdProcgSts.HCMTmeShtRecdProcgStsTxt AS HCMTmeShtRecdProcgStsTxt,
  _CalendarMonth.CalendarMonthName AS CalendarMonthName,
  _Wagetype.WageTypeName AS WageTypeName,
  _HCMMasterActivityType.CostCtrActivityTypeName AS HCMMasterActivityTypeName,
  _HCMActivityType.CostCtrActivityTypeName AS HCMActivityTypeName,
  _HCMTimeShtRecdRejectionReason.TimeSheetRejectionReasonText AS TimeSheetRejectionReasonText,
  _ReceiverCostObject.CostObjectDesc AS CostObjectDesc
FROM I_HCMActualActivitiesBase
LEFT OUTER JOIN I_HCMAttendanceAbsenceTypeText AS _HCMAttendanceAbsenceType ON HCMPersonnelSubareaGrouping = _HCMAttendanceAbsenceType.HCMPersonnelSubareaGrouping AND HCMAttendanceAbsenceType = _HCMAttendanceAbsenceType.HCMAttendanceAbsenceType AND _HCMAttendanceAbsenceType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _MasterCostCenter ON _MasterCostCenter.CostCenter = HCMMasterCostCenter AND _MasterCostCenter.ControllingArea = ControllingArea AND _MasterCostCenter.Language = $session.system_language AND _MasterCostCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _SenderCostCenter ON _SenderCostCenter.CostCenter = HCMSenderCostCenter AND _SenderCostCenter.ControllingArea = ControllingArea AND _SenderCostCenter.Language = $session.system_language AND _SenderCostCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _ReceiverCostCenter ON _ReceiverCostCenter.CostCenter = ReceiverCostCenter AND _ReceiverCostCenter.ControllingArea = ControllingArea AND _ReceiverCostCenter.Language = $session.system_language AND _ReceiverCostCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _ReceiverBusinessProcess ON _ReceiverBusinessProcess.BusinessProcess = ReceiverBusinessProcess AND _ReceiverBusinessProcess.ControllingArea = ControllingArea AND _ReceiverBusinessProcess.Language = $session.system_language AND _ReceiverBusinessProcess.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _ReceivingFunctionalArea ON _ReceivingFunctionalArea.FunctionalArea = HCMReceivingFunctionalArea AND _ReceivingFunctionalArea.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _ReceiverGrant ON _ReceiverGrant.GrantID = HCMReceiverGrant AND _ReceiverGrant.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _SendingFunctionalArea ON _SendingFunctionalArea.FunctionalArea = HCMSendingFunctionalArea AND _SendingFunctionalArea.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _SenderGrant ON _SenderGrant.GrantID = HCMSenderGrant AND _SenderGrant.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _ReceiverBudgetPeriod ON _ReceiverBudgetPeriod.BudgetPeriod = HCMReceiverBudgetPeriod AND _ReceiverBudgetPeriod.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _SenderBudgetPeriod ON _SenderBudgetPeriod.BudgetPeriod = HCMSenderBudgetPeriod AND _SenderBudgetPeriod.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CapacityText AS _HCMCapacityID ON _HCMCapacityID.CapacityInternalID = HCMCapacityID AND _HCMCapacityID.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _Currency ON _Currency.Currency = Currency AND _Currency.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _HCMTimeShtRecdTransCrcy ON _HCMTimeShtRecdTransCrcy.Currency = HCMTimeShtRecdTransCrcy AND _HCMTimeShtRecdTransCrcy.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategory ON _OrderCategory.OrderCategory = HCMOrderCategory AND _OrderCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _MasterFunctionalArea ON _MasterFunctionalArea.Language = $session.system_language AND _MasterFunctionalArea.FunctionalArea = HCMMasterFunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _MasterGrant ON _MasterGrant.GrantID = HCMMasterGrant AND _MasterGrant.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StatisticalKeyFigureText AS _StatisticalKeyFigure ON _StatisticalKeyFigure.Language = $session.system_language AND _StatisticalKeyFigure.ControllingArea = ControllingArea AND _StatisticalKeyFigure.StatisticalKeyFigure = HCMStatisticalKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasure ON _UnitOfMeasure.Language = $session.system_language AND _UnitOfMeasure.UnitOfMeasure = HCMTimeShtRecdUoM  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _MasterBudgetPeriod ON _MasterBudgetPeriod.Language = $session.system_language AND _MasterBudgetPeriod.BudgetPeriod = HCMMasterBudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BillableControlText AS _AccountingIndicator ON _AccountingIndicator.BillableControl = HCMAccountingIndicatorCode AND _AccountingIndicator.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrentBusinessProcessText AS _SenderBusinessProcess ON _SenderBusinessProcess.ControllingArea = ControllingArea AND _SenderBusinessProcess.BusinessProcess = SenderBusinessProcess AND _SenderBusinessProcess.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtActivityNumberTxt AS _ActivityNumber ON _ActivityNumber.Language = $session.system_language AND _ActivityNumber.ActivityNumber = ActivityNumber  -- association [0..1]
LEFT OUTER JOIN I_HCMObjectTypeText AS _HCMObjectType ON _HCMObjectType.Language = $session.system_language AND _HCMObjectType.HCMObjectType = HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMPositionText AS _HCMPosition ON _HCMPosition.Language = $session.system_language AND _HCMPosition.HCMObjectType = HCMObjectType AND _HCMPosition.HCMPosition = HCMPosition AND _HCMPosition.EndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _HCMTimeShtRecdDisplayUoM ON _HCMTimeShtRecdDisplayUoM.Language = $session.system_language AND _HCMTimeShtRecdDisplayUoM.UnitOfMeasure = HCMTimeShtRecdDisplayUoM  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetTaskTypeText AS _TaskType ON _TaskType.Language = $session.system_language AND _TaskType.TimeSheetTaskType = TaskType  -- association [0..1]
LEFT OUTER JOIN I_FinalConfirmationTypeText AS _HCMTmeShtRecdAutomConfPrpsl ON _HCMTmeShtRecdAutomConfPrpsl.FinalConfirmationType = HCMTmeShtRecdAutomConfPrpsl AND _HCMTmeShtRecdAutomConfPrpsl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtOvertimeCompnTypeT AS _HCMOvertimeCompensationType ON _HCMOvertimeCompensationType.Language = $session.system_language AND _HCMOvertimeCompensationType.HCMOvertimeCompensationType = HCMOvertimeCompensationType  -- association [0..1]
LEFT OUTER JOIN I_CapacityCategoryText AS _CapacityCategory ON _CapacityCategory.CapacityCategoryCode = CapacityCategory AND _CapacityCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeGroupText AS _HCMEmployeeGroup ON _HCMEmployeeGroup.HCMEmployeeGroup = HCMEmployeeGroup AND _HCMEmployeeGroup.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeSubgroupText AS _HCMEmployeeSubGroup ON _HCMEmployeeSubGroup.HCMEmployeeSubgroup = HCMEmployeeSubgroup AND _HCMEmployeeSubGroup.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _CalendarMonth ON _CalendarMonth.CalendarMonth = CalendarMonth AND _CalendarMonth.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystemText AS _LogicalSystem ON _LogicalSystem.LogicalSystem = HCMLogicalSystemID AND _LogicalSystem.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystemText AS _HCMLogicalSystemOfSourceDoc ON _HCMLogicalSystemOfSourceDoc.LogicalSystem = HCMLogicalSystemOfSourceDoc AND _HCMLogicalSystemOfSourceDoc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMTmeShtRecdProcgStsTxt AS _HCMTmeShtRecdProcgSts ON _HCMTmeShtRecdProcgSts.HCMTimeShtRecdProcessingStatus = HCMTimeShtRecdProcessingStatus AND _HCMTmeShtRecdProcgSts.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Wagetypetext AS _Wagetype ON _Wagetype.EmployeeWageType = HCMWageType AND _Wagetype.PersonnelCountryGroup = HCMCountryRegionGrouping AND _Wagetype.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _HCMMasterActivityType ON _HCMMasterActivityType.CostCtrActivityType = HCMMasterActivityType AND _HCMMasterActivityType.ControllingArea = ControllingArea AND _HCMMasterActivityType.Language = $session.system_language AND _HCMMasterActivityType.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _HCMActivityType ON _HCMActivityType.CostCtrActivityType = HCMActivityType AND _HCMActivityType.ControllingArea = ControllingArea AND _HCMActivityType.Language = $session.system_language AND _HCMActivityType.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetRejectionReasonText AS _HCMTimeShtRecdRejectionReason ON _HCMTimeShtRecdRejectionReason.TimeSheetRejectionReason = HCMTimeShtRecdRejectionReason AND _HCMTimeShtRecdRejectionReason.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_CostObjectText AS _ReceiverCostObject ON _ReceiverCostObject.CostObject = ReceiverCostObject AND _ReceiverCostObject.LanguageCode = $session.system_language AND _ReceiverCostObject.ValidityEndDate = '99991231'  -- association [0..1]
;