I_HCMTimeShtAssgmt

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_HCMTimeShtAssgmt.
-- 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_HCMTimeShtAssgmt AS
SELECT
  id AS HCMTmeShtAssgmtUUID,
  uname AS HCMTimeShtUser,
  name AS HCMTmeShtAssgmtName,
  approver AS HCMTimeShtRecdApproverID,
  appr_name AS HCMTmeShtRecdApprvrName,
  admin_assgmt AS HCMTmeShtAssgmtIsAdminAssgmt,
  assign_status AS HCMTmeShtAssgmtIsActv,
  favorite AS HCMTmeShtAssgmtIsFavorite,
  cast('99991231' as datum) AS HCMTimeShtEndDate,
  begda AS HCMTimeShtAssgmtStartDate,
  endda AS HCMTimeShtAssgmtEndDate,
  catshours AS HCMTimeShtRecdRecordedHrs,
  cast ( catsamount as abap.curr(13,2)) AS HCMTimeShtRecdRecordedAmount,
  catsquantity AS HCMTimeShtRecdRecordedQuantity,
  meinh AS HCMTimeShtRecdDisplayUoM,
  unit AS HCMTimeShtRecdUoM,
  longtext AS HCMCommentIsLongText,
  ltxa1 AS HCMShortTextComment,
  alldf AS HCMTimeShtRecdIsForFullDay,
  waers AS Currency,
  beguz AS HCMTimeShtRecdStartTime,
  enduz AS HCMTimeShtRecdEndTime,
  aueru AS HCMTmeShtRecdAutomConfPrpsl,
  awart AS HCMAttendanceAbsenceType,
  lstar AS HCMActivityType,
  prakn AS HCMPremiumNumberCode,
  prakz AS HCMPremiumIndicatorCode,
  bemot AS HCMAccountingIndicatorCode,
  kokrs AS ControllingArea,
  cpr_extid AS HCMExternalProjectID,
  cast (cpr_guid as hrmss_cat_appr_projectguid preserving type ) AS HCMProjectUUID,
  cpr_objgextid AS HCMProjectSubObjectID,
  cpr_objguid AS HCMProjectObjectUUID,
  cpr_objtype AS HCMProjectObjectType,
  extapplication AS HCMExternalApplication,
  extdocumentno AS HCMExternalDocument,
  aufkz AS HCMExtraPayValuation,
  extsystem AS HCMLogicalSystemOfSourceDoc,
  func_area AS HCMReceivingFunctionalArea,
  fund AS HCMReceiverFund,
  grant_nbr AS HCMReceiverGrant,
  rnplnr AS HCMNetworkNumber,
  versl AS HCMOvertimeCompensationType,
  eruzu AS HCMTimeShtRecdHasPrtlConfirm,
  trfgr AS PayScaleGroup,
  trfst AS PayScaleLevel,
  werks AS Plant,
  sebelp AS HCMSendingPurchaseOrderItem,
  sebeln AS HCMSendingPurchaseOrder,
  plans AS HCMPosition,
  vtken AS HCMTimeShtRecdIsForPrevDay,
  rkostl AS ReceiverCostCenter,
  raufnr AS ReceiverOrder,
  rprznr AS ReceiverBusinessProcess,
  rkstr AS ReceiverCostObject,
  rkdpos AS ReceiverSalesOrderItem,
  rkdauf AS ReceiverSalesOrder,
  ofmnw AS HCMRemainingWorkQuantity,
  sprznr AS SenderBusinessProcess,
  skostl AS HCMSenderCostCenter,
  s_func_area AS HCMSendingFunctionalArea,
  s_fund AS HCMSenderFund,
  s_grant_nbr AS HCMSenderGrant,
  lstnr AS ActivityNumber,
  split AS HCMCapacitySplit,
  statkeyfig AS HCMStatisticalKeyFigure,
  tcurr AS HCMTimeShtRecdTransCrcy,
  reinr AS TravelTripNumber,
  lgart AS HCMWageType,
  wtart AS HCMTaxAreaWorkCenter,
  price AS HCMTimeSheetRecordPriceInTC,
  cast ( rproj as ps_s4_pspnr ) AS HCMReceiverWBSElement,
  cast ( posid as ps_s4_posid ) AS HCMReceiverWBSElementExtID,
  arbpl AS WorkCenter,
  TaskType,
  tasklevel AS HCMTaskLevel,
  taskcomponent AS HCMTaskComponent,
  cast ( vornr as abap.char( 4 ) ) AS StdNetworkActivity,
  cast ( uvorn as abap.char( 4 ) ) AS SubOperation,
  kapar AS CapacityCategory,
  bwgrl AS HCMValuationBasisAmount,
  raufpl AS HCMOrderRoutingNumber,
  raplzl AS HCMOrderID,
  paobjnr AS HCMProfitabilitySegment,
  budget_pd AS HCMReceiverBudgetPeriod,
  sbudget_pd AS HCMSenderBudgetPeriod,
  kapid AS HCMCapacityID,
  wablnr AS MaterialDocument,
  otype AS HCMObjectType,
  arbid AS HCMObjectID,
  autyp AS HCMOrderCategory,
  hrcostasg AS HCMMstrCostAcctgVariants,
  hrkostl AS HCMMasterCostCenter,
  hrlstar AS HCMMasterActivityType,
  hrfund AS HCMMasterFund,
  hrfunc_area AS HCMMasterFunctionalArea,
  hrgrant_nbr AS HCMMasterGrant,
  bukrs AS CompanyCode,
  hrbudget_pd AS HCMMasterBudgetPeriod,
  bedid AS CapacityRequirement,
  cast('' as fco_srvdoc_type) AS HCMTimeShtServiceDocType,
  cast('' as fco_srvdoc_id) AS HCMTimeShtServiceDocID,
  abap.numc'000000' AS HCMTimeShtServiceDocItemID,
  sfsf_time_type_uuid AS HCMSuccssFctrsTimeTypeUUID,
  sfsf_time_type_ecode AS HCMSuccssFctrsTimeTypeCode,
  sfsf_time_type_category AS HCMSuccssFctrsTimeTypeCat,
  sfsf_allowance_type_uuid AS HCMSuccssFctrsAllwncTypeUUID,
  sfsf_allowance_type_ecode AS HCMSuccssFctrsAllwncTypeCode
FROM hrfio_assignment
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _MasterCostCenter ON HCMMasterCostCenter = _MasterCostCenter.CostCenter AND ControllingArea = _MasterCostCenter.ControllingArea AND HCMTimeShtEndDate =_MasterCostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _SenderCostCenter ON HCMSenderCostCenter = _SenderCostCenter.CostCenter AND ControllingArea = _SenderCostCenter.ControllingArea AND HCMTimeShtEndDate = _SenderCostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ReceiverCostCenter ON ReceiverCostCenter = _ReceiverCostCenter.CostCenter AND ControllingArea = _ReceiverCostCenter.ControllingArea AND HCMTimeShtEndDate = _ReceiverCostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _ReceiverSalesOrder ON ReceiverSalesOrder = _ReceiverSalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _ReceiverSalesOrderItem ON ReceiverSalesOrder = _ReceiverSalesOrderItem.SalesOrder AND ReceiverSalesOrderItem = _ReceiverSalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _ReceiverBusinessProcess ON ReceiverBusinessProcess = _ReceiverBusinessProcess.BusinessProcess AND ControllingArea = _ReceiverBusinessProcess.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _HCMReceivingFunctionalArea ON HCMReceivingFunctionalArea = _HCMReceivingFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _ReceiverGrant ON HCMReceiverGrant = _ReceiverGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _SendingFunctionalArea ON HCMSendingFunctionalArea = _SendingFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _SenderGrant ON HCMSenderGrant = _SenderGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _ReceiverBudgetPeriod ON HCMReceiverBudgetPeriod = _ReceiverBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _SenderBudgetPeriod ON HCMSenderBudgetPeriod = _SenderBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Capacity AS _HCMCapacityID ON HCMCapacityID = _HCMCapacityID.CapacityInternalID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON HCMOrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _MasterFunctionalArea ON HCMMasterFunctionalArea = _MasterFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _MasterGrant ON HCMMasterGrant = _MasterGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_StatisticalKeyFigure AS _StatisticalKeyFigure ON HCMStatisticalKeyFigure = _StatisticalKeyFigure.StatisticalKeyFigure AND ControllingArea = _StatisticalKeyFigure.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON HCMTimeShtRecdUoM = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _MasterBudgetPeriod ON HCMMasterBudgetPeriod = _MasterBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BillableControl AS _AccountingIndicator ON HCMAccountingIndicatorCode = _AccountingIndicator.BillableControl  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _HCMSendingPurchaseOrder ON HCMSendingPurchaseOrder = _HCMSendingPurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _HCMSendingPurchaseOrderItem ON HCMSendingPurchaseOrder = _HCMSendingPurchaseOrderItem.PurchaseOrder AND HCMSendingPurchaseOrderItem = _HCMSendingPurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _SenderBusinessProcess ON ControllingArea = _SenderBusinessProcess.ControllingArea AND SenderBusinessProcess = _SenderBusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategory = _CapacityCategory.CapacityCategoryCode  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtActivityNumber AS _ActivityNumber ON ActivityNumber = _ActivityNumber.ActivityNumber  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _HCMNetworkNumber ON HCMNetworkNumber = _HCMNetworkNumber.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_HCMObjectType AS _HCMObjectType ON HCMObjectType = _HCMObjectType.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMPosition AS _HCMPosition ON HCMPosition = _HCMPosition.HCMPosition AND HCMObjectType = _HCMPosition.HCMObjectType AND HCMTimeShtEndDate = _HCMPosition.EndDate  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _HCMReceiverGrant ON HCMReceiverGrant = _HCMReceiverGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _ReceiverOrder ON ReceiverOrder = _ReceiverOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HCMTimeShtRecdDisplayUoM ON HCMTimeShtRecdDisplayUoM = _HCMTimeShtRecdDisplayUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtTaskType AS _TaskType ON TaskType = _TaskType.TimeSheetTaskType  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _HCMReceiverWBSElementExt ON HCMReceiverWBSElementExtID = _HCMReceiverWBSElementExt.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_FinalConfirmationType AS _HCMTmeShtRecdAutomConfPrpsl ON HCMTmeShtRecdAutomConfPrpsl = _HCMTmeShtRecdAutomConfPrpsl.FinalConfirmationType  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtOvertimeCompnType AS _HCMOvertimeCompensationType ON HCMOvertimeCompensationType = _HCMOvertimeCompensationType.HCMOvertimeCompensationType  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtTaxArea AS _HCMTaxAreaWorkCenter ON HCMTaxAreaWorkCenter = _HCMTaxAreaWorkCenter.HCMWorkTaxArea AND HCMTimeShtEndDate = _HCMTaxAreaWorkCenter.HCMValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtTaskLevel AS _HCMTaskLevel ON HCMTaskLevel = _HCMTaskLevel.HCMTaskLevel  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeShtTaskComponent AS _HCMTaskComponent ON HCMTaskComponent = _HCMTaskComponent.HCMTaskComponent  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _HCMTimeShtEndDate ON HCMTimeShtEndDate = _HCMTimeShtEndDate.CalendarDate  -- association [0..1]
;