P_DFS_MeasureAreaBasic

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 P_DFS_MeasureAreaBasic.
-- 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: PORGMAREABA

CREATE VIEW P_DFS_MeasureAreaBasic AS
SELECT
  CaseUniqueID AS DfsMeasureAreaUUID,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseProcessor,
  CaseResponsible AS DfsOrglMeasureResponsible,
  CaseTitle AS DfsMeasureAreaDescription,
  CaseAuthorizationLevel,
  CaseSystemStatus,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  cast( CaseCreatedOn as tzntstmps preserving type ) AS CreationDateTime,
  cast( CaseLastChangedOn as tzntstmps preserving type ) AS LastChangeDateTime,
  cast( CaseClosedTime as tzntstmps preserving type ) AS CloseDateTime,
  CaseStatus,
  _case._Individual._Text[1:Language = $session.system_language].CaseStatusName AS CaseStatusName
FROM I_CaseAttribute AS _case
;