I_DFS_OrganizationalMeasure

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_DFS_OrganizationalMeasure.
-- 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: IORGM

CREATE VIEW I_DFS_OrganizationalMeasure AS
SELECT
  CaseUniqueID AS DfsOrglMeasureUUID,
  CaseType,
  'Organizational Measure' AS DfsOrglMeasureCategoryText,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  cast( CaseCreatedOn as tzntstmps preserving type ) AS CreationDateTime,
  CaseLastChangedBy,
  cast( CaseLastChangedOn as tzntstmps preserving type ) AS LastChangeDateTime,
  CaseClosedBy,
  cast( CaseClosedTime as tzntstmps preserving type ) AS CloseDateTime,
  CaseProcessor,
  CaseResponsible AS DfsOrglMeasureResponsible,
  CaseTitle AS DfsOrglMeasureDescription,
  CaseAuthorizationLevel,
  CaseStatus,
  _CaseAttribute._Individual._Text[1:Language = $session.system_language].CaseStatusName AS CaseStatusName,
  CaseSystemStatus,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  CaseReason,
  TaskApplicationObject.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _MeasureAttributes.DfsOrglMeasureHeaderType AS DfsOrglMeasureHeaderType,
  _MeasureAttributes.DfsOrglMeasureHeaderID AS DfsOrglMeasureHeaderID,
  _MeasureAttributes._MeasureType._Text[1:Language = $session.system_language].DfsOrglMeasureTypeText AS DfsOrglMeasureTypeText,
  _MeasureAttributes.DfsOrglMeasureType AS DfsOrglMeasureType,
  _MeasureAttributes.DfsOrglMsrEffectivenessDate AS DfsOrglMsrEffectivenessDate
FROM I_CaseAttribute AS _CaseAttribute
INNER JOIN I_WorkflowTaskApplObject AS TaskApplicationObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkflowTask AS _WorkflowTask ON TaskApplicationObject.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID  -- association [1..1]
LEFT OUTER JOIN I_DFS_MeasureAttributes AS _MeasureAttributes ON DfsOrglMeasureUUID = _MeasureAttributes.DfsOrglMeasureUUID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsiblePerson ON DfsOrglMeasureResponsible = _ResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_FrcElmntOrgSuplmntyAttrib AS _FrcElmntSuplmntyAttribAssgmt ON dfsorglmeasureheaderid = _FrcElmntSuplmntyAttribAssgmt.ForceElementOrgID AND _FrcElmntSuplmntyAttribAssgmt.FrcElmntOrgLanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FrcElmntOrg AS _FrcElmntOrg ON dfsorglmeasureheaderid = _FrcElmntOrg.ForceElementOrgID  -- association [1..1]
;