I_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 I_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 I_HCMCompliance AS
SELECT
  HCMTimesheetRecord.PersonnelNumber AS PersonnelNumber,
  HCMTimesheetRecord.HCMTimeShtRecdID AS HCMTimeShtRecdID,
  HCMOrganizationalAssignment.HCMEmployeeName AS HCMEmployeeName,
  HCMOrganizationalAssignment.HCMOrganizationalUnit AS HCMOrganizationalUnit,
  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,
  cast( 08.00 as abap.fltp ) AS HCMTimeShtTargetHours,
  cast( '%' as abap.unit( 2 )) AS HCMTimeShtCmplncPctUnit,
  cast( 100 as abap.dec(10,2) ) AS HCMTimeShtCmplncPct,
  cast( 0 as abap.int1 ) AS HCMTimeShtCmplncCriticality,
  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,
  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,
  _HCMAttendanceAbsenceType.HCMAttendanceAbsenceTypeName AS HCMAttendanceAbsenceTypeName,
  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
FROM I_HCMTimeSheetRecord AS HCMTimesheetRecord
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit  -- association [0..*]
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 C_HCMTimeShtAttndncAbsncType AS _HCMAttendanceAbsenceType ON PersonnelNumber = _HCMAttendanceAbsenceType.PersonnelNumber AND HCMAttendanceAbsenceType = _HCMAttendanceAbsenceType.HCMAttendanceAbsenceType AND HCMWorkDate = _HCMAttendanceAbsenceType.HCMWorkDate  -- association [0..1]
;