I_ChgMgmtReqRelatedObject

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_ChgMgmtReqRelatedObject.
-- 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: ICMREQRELTDOBJ

CREATE VIEW I_ChgMgmtReqRelatedObject AS
SELECT
  db_key AS ChgMgmtReqReltdObjUUID,
  parent_key AS ChgMgmtReqUUID,
  node_cat_key AS ChgMgmtReqReltdObjNodeCatUUID,
  category_cd AS ChgMgmtReltdObjCategory,
  type_cd AS ChgMgmtReltdObjType,
  id AS ChgMgmtReqReltdObject,
  internal_id1 AS ChgMgmtReqReltdObjInternalID1,
  internal_id2 AS ChgMgmtReqReltdObjInternalID2,
  internal_id3 AS ChgMgmtReqReltdObjInternalID3,
  internal_id4 AS ChgMgmtReqReltdObjInternalID4,
  internal_guid AS ChgMgmtReqReltdObjInternalUUID,
  url AS ChgMgmtReqReltdObjURL,
  src_system AS ChgMgmtReqReltdObjSystem,
  main_ref_ind AS ChgMgmtReqReltdObjIsLeading,
  add_field1 AS ChgMgmtReqReltdObjAddlField1,
  add_field2 AS ChgMgmtReqReltdObjAddlField2,
  add_field3 AS ChgMgmtReqReltdObjAddlField3,
  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
FROM /iam/d_i_obj_ref AS relobj
LEFT OUTER JOIN I_ChgMgmtRequest AS _ChgMgmtRequest ON ChgMgmtReqUUID = _ChgMgmtRequest.ChgMgmtReqUUID  -- association [1..1]
LEFT OUTER JOIN I_ChgMgmtReqRelatedObjectText AS _Text ON ChgMgmtReqReltdObjUUID = _Text.ChgMgmtReqReltdObjUUID  -- association [0..*]
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]
;