C_HCMCompliance

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 C_HCMCompliance.
-- 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 C_HCMCompliance AS
SELECT
  HCMTimeShtRecdID,
  PersonnelNumber,
  HCMEmployeeName,
  HCMOrganizationalUnit,
  HCMPersonnelArea,
  HCMPersonnelSubarea,
  HCMEmployeeGroup,
  HCMEmployeeSubgroup,
  HCMPersonnelSubareaGrouping,
  HCMEmployeeCompanyCode,
  CalendarDate,
  CalendarMonth,
  CalendarYear,
  CalendarQuarter,
  CalendarWeek,
  CalendarDay,
  YearQuarter,
  YearMonth,
  YearWeek,
  WeekDay,
  YearDay,
  HCMWorkDate,
  HCMTimeShtRecdRecordedHrs,
  HCMTimeShtRecdRecordedHrs AS HCMTimeShtRecdCYrRecordedHrs,
  HCMTimeShtRecdRecordedAmount,
  HCMTimeShtRecdRecordedQuantity,
  HCMTimeShtTargetHours,
  HCMTimeShtCmplncPctUnit,
  HCMTimeShtCmplncPct,
  abap.dec'100.00' AS HCMTimeShtOverallCmplncPct,
  abap.int1'0' AS HCMTimeShtCmplncCriticality,
  HCMSenderCostCenter,
  HCMActivityType,
  HCMSendingPurchaseOrder,
  HCMSendingPurchaseOrderItem,
  SenderBusinessProcess,
  ActivityNumber,
  ReceiverCostCenter,
  ReceiverOrder,
  HCMNetworkNumber,
  HCMOrderRoutingNumber,
  HCMOrderID,
  ReceiverSalesOrder,
  ReceiverSalesOrderItem,
  ReceiverCostObject,
  ReceiverBusinessProcess,
  HCMProfitabilitySegment,
  HCMReceiverFund,
  HCMReceivingFunctionalArea,
  HCMReceiverGrant,
  HCMSenderFund,
  HCMSendingFunctionalArea,
  HCMSenderGrant,
  HCMReceiverBudgetPeriod,
  HCMSenderBudgetPeriod,
  HCMAttendanceAbsenceType,
  HCMAttendanceAbsenceTypeName,
  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
FROM I_HCMCompliance
LEFT OUTER JOIN C_HCMComplianceDetails AS _ComplianceDetails ON PersonnelNumber = _ComplianceDetails.PersonnelNumber  -- association [0..*]
LEFT OUTER JOIN C_HCMEmployeeQuickView AS _EmployeeCardQuickView ON PersonnelNumber = _EmployeeCardQuickView.HCMPersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _MasterCostCenter ON HCMMasterCostCenter = _MasterCostCenter.CostCenter AND ControllingArea = _MasterCostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _SenderCostCenter ON HCMSenderCostCenter = _SenderCostCenter.CostCenter AND ControllingArea = _SenderCostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _ReceiverCostCenter ON ReceiverCostCenter = _ReceiverCostCenter.CostCenter AND ControllingArea = _ReceiverCostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _ReceiverSalesOrder ON ReceiverSalesOrder = _ReceiverSalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _ReceiverSalesOrderItem ON ReceiverSalesOrderItem = _ReceiverSalesOrderItem.SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcess AS _ReceiverBusinessProcess ON ReceiverBusinessProcess = _ReceiverBusinessProcess.BusinessProcess AND ControllingArea = _ReceiverBusinessProcess.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _ReceivingFunctionalArea ON HCMReceivingFunctionalArea = _ReceivingFunctionalArea.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_BudgetPeriodStdVH AS _ReceiverBudgetPeriod ON HCMReceiverBudgetPeriod = _ReceiverBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _SenderBudgetPeriod ON HCMSenderBudgetPeriod = _SenderBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelSubareaGrouping AS _PersSubareaGrpg ON HCMPersonnelSubareaGrouping = _PersSubareaGrpg.HCMPersonnelSubareaGrouping  -- association [0..1]
LEFT OUTER JOIN I_HCMAttendanceAbsenceType AS _HCMAttendanceAbsenceType ON HCMPersonnelSubareaGrouping = _HCMAttendanceAbsenceType.HCMPersonnelSubareaGrouping AND HCMAttendanceAbsenceType = _HCMAttendanceAbsenceType.HCMAttendanceAbsenceType  -- association [0..*]
LEFT OUTER JOIN I_Wagetypetext AS _HCMWageType ON HCMWageType = _HCMWageType.EmployeeWageType  -- association [0..*]
LEFT OUTER JOIN I_CapacityStdVH AS _HCMCapacityID ON HCMCapacityID = _HCMCapacityID.CapacityInternalID  -- association [0..1]
LEFT OUTER JOIN I_CurrencyStdVH AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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_CostCenterActivityType AS _CostCenterActivityType ON HCMMasterActivityType = _CostCenterActivityType.CostCtrActivityType AND ControllingArea = _CostCenterActivityType.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _MasterFunctionalArea ON HCMMasterFunctionalArea = _MasterFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON HCMMasterGrant = _Grant.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_UnitOfMeasureStdVH AS _UnitOfMeasure ON HCMTimeShtRecdUoM = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _MasterBudgetPeriod ON HCMMasterBudgetPeriod = _MasterBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystemID ON HCMLogicalSystemID = _LogicalSystemID.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_HCMTmeShtRecdProcgSts AS _HCMTmeShtRecdProcgSts ON HCMTimeShtRecdProcessingStatus = _HCMTmeShtRecdProcgSts.HCMTimeShtRecdProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelArea AS _HCMPersonnelArea ON HCMPersonnelArea = _HCMPersonnelArea.HCMPersonnelArea  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelSubarea AS _HCMPersonnelSubarea ON HCMPersonnelSubarea = _HCMPersonnelSubarea.HCMPersonnelSubarea AND HCMPersonnelArea = _HCMPersonnelSubarea.HCMPersonnelArea  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeGroup AS _HCMEmployeeGroup ON HCMEmployeeGroup = _HCMEmployeeGroup.HCMEmployeeGroup  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeSubgroup AS _HCMEmployeeSubgroup ON HCMEmployeeSubgroup = _HCMEmployeeSubgroup.HCMEmployeeSubgroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _HCMEmployeeCompanyCode ON HCMEmployeeCompanyCode = _HCMEmployeeCompanyCode.CompanyCode  -- association [0..1]
;