I_ChgMgmtRequest

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_ChgMgmtRequest.
-- 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: ICMREQUEST

CREATE VIEW I_ChgMgmtRequest AS
SELECT
  db_key AS ChgMgmtReqUUID,
  node_cat_key AS ChgMgmtReqNodeCatUUID,
  cast(issue_id as chgmgmtrequest preserving type) AS ChgMgmtRequest,
  cast(issue_type as chgmgmtreqtype preserving type) AS ChgMgmtReqType,
  cast(issue_category as chgmgmtreqcategory preserving type) AS ChgMgmtReqCategory,
  par_issue_uuid AS ParentChgMgmtReqUUID,
  sortno AS ChgMgmtReqSortSequenceValue,
  auth_group AS ChgMgmtReqAuthorizationGroup,
  cast (criticality as /moc/criticality preserving type) AS ChgMgmtReqImpact,
  cast(emergency as /moc/is_emergency_no_fix_vals preserving type) AS ChgMgmtReqIsEmergency,
  reported_by AS ChgMgmtReqReportedByBPName,
  duration_cd AS ChgMgmtReqDurationCode,
  cast(country as /moc/country preserving type) AS Country,
  status_profile AS ChgMgmtUserStatusProfile,
  cast(lcycle_cd as chgmgmtreqlifecyclestatus preserving type) AS ChgMgmtReqLifecycleStatus,
  deferral_cd AS ChgMgmtDeferralStatus,
  cast(digsign_cd as chgmgmtdigitalsgntrstatus preserving type) AS ChgMgmtDigitalSgntrStatus,
  archiving_cd AS ChgMgmtArchivingStatus,
  user_status_01 AS ChgMgmtUserStatus1,
  user_status_02 AS ChgMgmtUserStatus2,
  user_status_03 AS ChgMgmtUserStatus3,
  user_status_04 AS ChgMgmtUserStatus4,
  user_status_05 AS ChgMgmtUserStatus5,
  created_by AS CreatedByUser,
  cast(created_on as chgmgmtcreationdatetime preserving type) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast(changed_on as chgmgmtlastchangedatetime preserving type) AS LastChangeDateTime,
  migration_source AS ChgMgmtReqMigrationSource,
  restr_access_ind AS ChgMgmtReqIsAccessRestricted
FROM /iam/d_i_root
LEFT OUTER JOIN I_ChgMgmtActivity AS _ChgMgmtActivity ON ChgMgmtReqUUID = _ChgMgmtActivity.ChgMgmtReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtReqDescription AS _ChgMgmtReqDescription ON ChgMgmtReqUUID = _ChgMgmtReqDescription.ChgMgmtReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtReqDescription AS _ChgMgmtReqExplanation ON ChgMgmtReqUUID = _ChgMgmtReqExplanation.ChgMgmtReqUUID AND _ChgMgmtReqExplanation.ChgMgmtDescriptionType = 'EXPLN'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqType AS _ChgMgmtReqType ON ChgMgmtReqType = _ChgMgmtReqType.ChgMgmtReqType  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqDate ON ChgMgmtReqUUID = _ChgMgmtReqDate.ChgMgmtReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqReversalDate ON ChgMgmtReqUUID = _ChgMgmtReqReversalDate.ChgMgmtReqUUID AND _ChgMgmtReqReversalDate.ChgMgmtDateRole = 'REV'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqApprovalDate ON ChgMgmtReqUUID = _ChgMgmtReqApprovalDate.ChgMgmtReqUUID AND _ChgMgmtReqApprovalDate.ChgMgmtDateRole = 'APP'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqExecStartDate ON ChgMgmtReqUUID = _ChgMgmtReqExecStartDate.ChgMgmtReqUUID AND _ChgMgmtReqExecStartDate.ChgMgmtDateRole = 'EXS'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqOplStartDate ON ChgMgmtReqUUID = _ChgMgmtReqOplStartDate.ChgMgmtReqUUID AND _ChgMgmtReqOplStartDate.ChgMgmtDateRole = 'OPS'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDate AS _ChgMgmtReqReportedDate ON ChgMgmtReqUUID = _ChgMgmtReqReportedDate.ChgMgmtReqUUID AND _ChgMgmtReqReportedDate.ChgMgmtDateRole = 'RBY'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqDuration AS _ChgMgmtReqDuration ON ChgMgmtReqDurationCode = _ChgMgmtReqDuration.ChgMgmtReqDurationCode  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqImpact AS _ChgMgmtReqImpact ON ChgMgmtReqImpact = _ChgMgmtReqImpact.ChgMgmtReqImpact  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqPersonInvolved AS _ChgMgmtReqPersonInvolved ON ChgMgmtReqUUID = _ChgMgmtReqPersonInvolved.ChgMgmtReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtReqPersonInvolved AS _ChgMgmtReqReporter ON ChgMgmtReqUUID = _ChgMgmtReqReporter.ChgMgmtReqUUID AND _ChgMgmtReqReporter.ChgMgmtReqPersnInvolvedIsRptr = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqRelatedObject AS _ChgMgmtReqRelatedObject ON ChgMgmtReqUUID = _ChgMgmtReqRelatedObject.ChgMgmtReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtReqRelatedObject AS _ChgMgmtReqLeadingObject ON ChgMgmtReqUUID = _ChgMgmtReqLeadingObject.ChgMgmtReqUUID AND _ChgMgmtReqLeadingObject.ChgMgmtReqReltdObjIsLeading = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqRelatedObject AS _ChgMgmtReqLeadingObjectLoc ON ChgMgmtReqUUID = _ChgMgmtReqLeadingObjectLoc.ChgMgmtReqUUID AND _ChgMgmtReqLeadingObjectLoc.ChgMgmtReltdObjType = 'LOC' AND _ChgMgmtReqLeadingObjectLoc.ChgMgmtReqReltdObjIsLeading = 'L'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqLifeCycStatus AS _ChgMgmtReqLifeCycStatus ON ChgMgmtReqLifecycleStatus = _ChgMgmtReqLifeCycStatus.ChgMgmtReqLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtDeferralStatus AS _ChgMgmtDeferralStatus ON ChgMgmtDeferralStatus = _ChgMgmtDeferralStatus.ChgMgmtDeferralStatus  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtDigitalSgntrSts AS _ChgMgmtDigitalSgntrSts ON ChgMgmtDigitalSgntrStatus = _ChgMgmtDigitalSgntrSts.ChgMgmtDigitalSgntrStatus  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStatusProfile AS _ChgMgmtUserStatusProfile ON ChgMgmtUserStatusProfile = _ChgMgmtUserStatusProfile.ChgMgmtUserStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts AS _ChgMgmtUserStsPrflFldSts1 ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts1.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus1 = _ChgMgmtUserStsPrflFldSts1.ChgMgmtUserStatus AND _ChgMgmtUserStsPrflFldSts1.ChgMgmtUserStatusField = '01'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts AS _ChgMgmtUserStsPrflFldSts2 ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts2.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus2 = _ChgMgmtUserStsPrflFldSts2.ChgMgmtUserStatus AND _ChgMgmtUserStsPrflFldSts2.ChgMgmtUserStatusField = '02'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts AS _ChgMgmtUserStsPrflFldSts3 ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts3.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus3 = _ChgMgmtUserStsPrflFldSts3.ChgMgmtUserStatus AND _ChgMgmtUserStsPrflFldSts3.ChgMgmtUserStatusField = '03'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts AS _ChgMgmtUserStsPrflFldSts4 ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts4.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus4 = _ChgMgmtUserStsPrflFldSts4.ChgMgmtUserStatus AND _ChgMgmtUserStsPrflFldSts4.ChgMgmtUserStatusField = '04'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts AS _ChgMgmtUserStsPrflFldSts5 ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts5.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus5 = _ChgMgmtUserStsPrflFldSts5.ChgMgmtUserStatus AND _ChgMgmtUserStsPrflFldSts5.ChgMgmtUserStatusField = '05'  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- 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_BusinessUser AS _EnteredBy ON CreatedByUser = _EnteredBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _Indicator ON ChgMgmtReqIsEmergency = _Indicator.IndicatorValue  -- association [0..1]
;