I_ChangeRecordBsc

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_ChangeRecordBsc.
-- 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: ICHGRECDBSC

CREATE VIEW I_ChangeRecordBsc 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,
  cast(ChangeResponsible.partner_id as /plmb/cr_chg_responsible preserving type) AS Partner,
  _Text[1:Language = $session.system_language].ChgRecordDescriptionText AS ChgRecordDescriptionText,
  Header.auth_group AS ChgRecdAuthGroup,
  cast(crhdrext.reasonforchange as /plmi/cr_chg_no_rsn ) AS ChgRecdReasonForChange,
  crhdrext.expected_comp_dat AS ChgRecdExpectedCompletionDate,
  crhdrext.profile AS ChgRecdPrflIdn,
  crhdrext.rich_text AS ChangeRecordDetailDescription,
  crhdrext.db_key AS ChgRecdHdrExtnUUID,
  crhdrext.eng_effective_date AS ChgRecdEngEffectiveDate,
  crhdrext.mfg_effective_date AS ChgRecdMfgEffectiveDate,
  crhdrext.digsign_user_act AS ChgRecdInitiatedStatusAction,
  crhdrext.item_change_allowed AS ChangeRecordItemEditMode,
  crhdrext.cr_change_reason AS ChgRecdHdrRsnForChgCode,
  _LogAccMObjSecureIDAssgmt.LogAccMSecureID AS LogAccMSecureID,
  _LogAccMObjSecureIDAssgmt._LogAccMSecureIDRepository.LogAccMSecureIDOwnerID AS LogAccMSecureIDOwnerID,
  _PriorityText[1:Language = $session.system_language].ChangeRecordPriorityDesc AS ChangeRecordPriorityDesc
FROM /iam/d_i_root AS Header
LEFT OUTER JOIN I_ChangeRecordText AS _Text ON ChangeRecordUUID = _Text.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_CR'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ChangeRecord = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_CR'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ChangeRecord = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_CR' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_CR' AND _LogAccMObjectUserAuthzn.LogAccMReadActivityIsEnabled = 'X' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON _Calendar.CalendarDate = $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ChgRecdPrioDescTxt AS _PriorityText ON ChangeRecordPriority = _PriorityText.ChangeRecordPriority  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRsnForChgText AS _RsnForChgText ON ChgRecdHdrRsnForChgCode = _RsnForChgText.ChgRecdHdrRsnForChgCode  -- association [0..*]
;