I_ChgRecHeader

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_ChgRecHeader.
-- 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_ChgRecHeader AS
SELECT
  Header.db_key AS ChangeRecordUUID,
  cast(Header.issue_id as /plmb/cr_id preserving type) AS ChangeRecord,
  cast(Header.issue_type as /plmb/cr_type preserving type) AS ChangeRecordType,
  Header.par_issue_uuid AS ParentChangeRecordUUID,
  Header.root_issue_uuid AS RootChangeRecordUUID,
  Header.priority AS ChangeRecordPriority,
  cast(Header.user_status_01 as /plmb/cr_hdr_status preserving type) AS ChangeRecordStatus,
  Header.change_no AS ChangeNumber,
  Header.issue_category AS ChangeRecordCategory,
  Header.application AS ChgRecordApplication,
  Header.created_by AS CreatedByUser,
  cast( Header.created_on as tzntstmps ) AS CreationDateTime,
  Header.changed_by AS LastChangedByUser,
  cast( Header.changed_on as tzntstmps ) AS LastChangeDateTime,
  Header.lcycle_cd AS ChangeRecordLifecycleStatus,
  Header.digsign_cd AS ChgRecdDigitalSignatureStatus,
  Header.auth_group AS ChgRecdAuthGroup
FROM /iam/d_i_root AS Header
;