I_EHSTaskInstanceCube

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_EHSTaskInstanceCube.
-- 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.
-- SQL view name: IEHSTASKINSTCUBE
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW I_EHSTaskInstanceCube AS
SELECT
  EHSTaskPlannedInstance.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date).EHSParentLocationID AS EHSMainLocationID,
  _EHSLocClassifier._EHSClassifierRoot.EHSLocClassifierID AS EHSLocClassifierID,
  _EHSDeviationTriggeringTask.TaskFollowRefObjUUID AS TaskFollowRefObjUUID,
  EHSTaskPlannedInstance.EHSPlannedTaskID AS EHSPlannedTaskID,
  EHSTaskPlannedInstance.EHSTaskDueDate AS EHSTaskDueDate,
  EHSTaskPlannedInstance.EHSTaskStartDate AS EHSTaskStartDate,
  EHSTaskPlannedInstance.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  EHSTaskPlannedInstance.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  EHSTaskPlannedInstance._EHSTaskOwnerUser.PersonFullName AS EHSTaskOwnerUserName,
  _EHSTaskDefinition.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  _EHSTaskDefinition.EHSTaskTitle AS EHSTaskTitle,
  _EHSTaskDefinition.EHSTaskPriority AS EHSTaskPriority,
  EHSTaskPlannedInstance._EHSTaskDefinition._EHSTaskPriority.EHSTaskPriorityName AS EHSTaskPriorityName,
  cast( _EHSTaskDefinition.EHSTaskDefinitionStatus as ehfnd_tdef_status_code ) AS EHSTaskDefinitionStatus,
  EHSTaskPlannedInstance.EHSTaskAssignedBP AS EHSTaskAssignedUser,
  EHSTaskPlannedInstance._EHSTaskAssigneeUser.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskPlannedInstance.EHSTaskApprovingBP AS EHSTaskApprovingUser,
  _EHSTaskPlannedInstance._EHSTaskApprovingUser.PersonFullName AS EHSTaskApprovingUserName,
  EHSTaskPlannedInstance._EHSTaskDefinition._EHSTaskAdapterClass.EHSSemanticObject AS EHSSemanticObject,
  _EHSTaskDefinition.EHSLocationUUID AS EHSLocationUUID,
  _EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  EHSTaskPlannedInstance._EHSTaskDefinition._EHSTaskDefinitionType._EHSTaskDefinitionTypeText[1: Language = $parameters.P_Language].EHSTaskDefinitionTypeName AS EHSTaskDefinitionTypeName,
  cast( _EHSCombinedTaskDefAndInstce.EHSTaskStatusValueForSorting as ehfnd_task_sorting_status_nc preserving type ) AS EHSTaskStatus,
  _EHSCombinedTaskDefAndInstce.WorkflowTaskStatus AS WorkflowTaskStatus,
  _EHSTaskDefReference.EHSTaskRelatedObjInstanceUUID AS EHSTaskRelatedObjInstanceUUID,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationRevisionName[1: Language = $parameters.P_Language].EHSLocationName AS EHSLocationName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationType AS EHSLocationType,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSLocationType._Text[1: Language = $parameters.P_Language].EHSLocationTypeText AS EHSLocationTypeText,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Country AS Country,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Country._Text[1: Language = $parameters.P_Language].CountryName AS CountryName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Region AS Region,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Region._RegionText[1: Language = $parameters.P_Language].RegionName AS RegionName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].Plant AS Plant,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._Plant.PlantName AS PlantName,
  cast ( _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].OrganizationalUnit as ehfnd_org_unit_id_nc preserving type ) AS OrganizationalUnit,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._OrganizationalUnit._OrgUnitText[1: Language = $parameters.P_Language].OrganizationalUnitName AS OrganizationalUnitName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].ControllingArea AS ControllingArea,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CostCenter AS CostCenter,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._CostCenter[1: ValidityStartDate <= $parameters.P_Date and ValidityEndDate >= $parameters.P_Date]._Text[1: Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].CompanyCode AS CompanyCode,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationStatus AS EHSLocationStatus,
  cast( _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  _EHSLocation[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].BusinessArea AS BusinessArea,
  _EHSLocationRoot.EHSLocationID AS EHSLocationID,
  _EHSLocClassifiers(P_Mandt: $session.client, P_Langu: $parameters.P_Language).Classifiers AS EHSLocClassifiersText,
  _EHSTaskFollowUp.TaskFollowCategoryCode AS TaskFollowCategoryCode,
  _EHSTaskTriggerCategoryText[1: Language = $parameters.P_Language].EHSTriggerCategoryDesc AS EHSTriggerCategoryDesc,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ].CmplRqVersUUID AS CmplRqVersUUID,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ].ComplianceRequirement AS ComplianceRequirement,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ]._CmplRqVersText[1: Language = $parameters.P_Language].CmplRqVersName AS CmplRqVersName,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ].CmplRqUUID AS CmplRqUUID,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ]._CmplncRqmtType.CmplRqType AS CmplRqType,
  _EHSCmplReq[1:EffectiveDate <= $parameters.P_Date and CmplRqVersValidToDate >= $parameters.P_Date ]._CmplncRqmtType._Text[1: Language = $parameters.P_Language].CmplRqTypeName AS CmplRqTypeName,
  _EHSCmplParagraph.CmplRqVersParagraphID AS CmplRqVersParagraphID,
  _EHSCmplParagraph.CmplRqVersParagraphName AS CmplRqVersParagraphName,
  _EHSCmplScen[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSComplianceScenarioRootUUID AS EHSComplianceScenarioRootUUID,
  _EHSCmplScen[1:RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ]._EHSCmplncScenName[1: Language = $parameters.P_Language].EHSComplianceScenarioName AS EHSComplianceScenarioName,
  _EHSDeviationTriggeringTask.DeviationUUID AS DeviationUUID,
  _EHSDeviationTriggeringTask.IncidentRefUUID AS IncidentRefUUID,
  _EHSDeviationTriggeringTask.IncidentID AS IncidentID,
  _EHSTaskDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  _EHSTaskDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  _EHSTaskDefinition._IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncdntTskRefAccessRestriction,
  0 AS NumberOfRecords,
  _EHSTaskDefinition._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  _EHSTaskDefinition._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  _EHSTaskDefinition._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  _EHSTaskDefinition._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  _EHSTaskDefinition._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields
FROM I_EHSTaskPlannedInstance AS EHSTaskPlannedInstance
INNER JOIN I_EHSTaskDefinition AS _EHSTaskDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocationRoot AS _EHSLocationRoot ON _EHSTaskDefinition.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationForFiltering AS _EHSLocationForFiltering ON _EHSTaskDefinition.EHSLocationUUID = _EHSLocationForFiltering.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLocation ON _EHSTaskDefinition.EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_DvtnIncdntTriggeringTask AS _EHSDeviationTriggeringTask ON _EHSTaskFollowUp.TaskFollowRefObjUUID = _EHSDeviationTriggeringTask.IncidentRefUUID AND EHSTaskPlannedInstance.EHSPlannedTaskUUID = _EHSDeviationTriggeringTask.EHSPlannedTaskUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskTriggerCategoryText AS _EHSTaskTriggerCategoryText ON TaskFollowCategoryCode = _EHSTaskTriggerCategoryText.TaskFollowCategoryCode  -- association [0..*]
LEFT OUTER JOIN I_EHSCombinedTaskDefAndInstce AS _EHSCombinedTaskDefAndInstce ON EHSTaskPlannedInstance.EHSPlannedTaskUUID = _EHSCombinedTaskDefAndInstce.EHSPlannedTaskUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _EHSCmplReq ON _EHSTaskDefinition.EHSTaskHostObjectInstanceUUID = _EHSCmplReq.CmplRqUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqVersStructure AS _EHSCmplParagraph ON _EHSTaskDefReference.EHSTaskRelatedObjInstanceUUID = _EHSCmplParagraph.CmplRqUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSCmplncScenRoot AS _EHSCmplScen ON _EHSTaskDefinition.EHSTaskHostObjectInstanceUUID = _EHSCmplScen.EHSCmplncScenOrignRootUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocClassifier AS _EHSLocClassifier ON _EHSTaskDefinition.EHSLocationUUID = _EHSLocClassifier.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN P_EHSLOCCLASSIFIERS AS _EHSLocClassifiers ON EHSLocationUUID = _EHSLocClassifiers.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSRiskControl AS _EHSRiskControl ON EHSTaskHostObjectInstanceUUID = _EHSRiskControl.EHSControlInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSRiskAssessment AS _EHSRiskAssessment ON EHSTaskHostObjectInstanceUUID = _EHSRiskAssessment.EHSRiskAssessmentUUID  -- association [0..1]
;