I_ECRAttr

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_ECRAttr.
-- 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: IECRATTR

CREATE VIEW I_ECRAttr AS
SELECT
  EngRecordHeader.case_guid AS EngineeringRecordUUID,
  ecr_id AS EngineeringRecord,
  cust_change_no AS CustomerReferenceNumber,
  change_coord AS ChangeCoordinator,
  release_coord AS ReleaseCoordinator,
  cast( CaseType as /plmb/ecr_type preserving type ) AS EngineeringRecordType,
  CaseCreatedBy AS CreatedByUser,
  cast( CaseCreatedOn as tzntstmps preserving type ) AS CreationDateTime,
  CaseLastChangedBy AS LastChangedByUser,
  cast( CaseLastChangedOn as tzntstmps preserving type ) AS LastChangeDateTime,
  CaseClosedBy AS ClosedByUser,
  cast( CaseClosedTime as tzntstmps preserving type ) AS CloseDateTime,
  CasePriority AS PriorityCode,
  cast( CaseStatus as /plmb/ecr_hdr_status ) AS Status,
  cast( CaseReason as /plmb/ecr_change_reason ) AS ChangeReason,
  CaseTitle AS EngineeringRecordDescription,
  CaseStatusProfile AS StatusProfile
FROM /plmi/ecr_hdr AS EngRecordHeader
INNER JOIN I_CaseAttribute AS CaseMgtAttribute ON /* join condition not captured in parsed metadata */
;