I_ChangeMaster

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_ChangeMaster.
-- 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: ICHANGEMASTER

CREATE VIEW I_ChangeMaster AS
SELECT
  aennr AS ChangeNumber,
  cast( aenst as /plmb/ecn_status preserving type ) AS ChangeNumberStatus,
  cast( aenbe as /plmb/aenbe preserving type ) AS AuthorizationGroup,
  aefun AS ChangeNumberFunction,
  terel AS IsTechnicallyReleased,
  cast( rlkey as /plmb/cc_rlkey preserving type ) AS ChangeNumberReleaseKey,
  aegru AS ReasonForChangeText,
  aetxt AS ChangeNumberDescription,
  datuv AS ChangeNumberValidFromDate,
  cast ( andat as /plmb/cc_andat preserving type ) AS ChangeNumberCreationDate,
  cast ( annam as /plmb/cc_annam preserving type ) AS ChangeNumberCreatedByUser,
  cast ( aedat as /plmb/aedat preserving type ) AS ChangeNumberLastChangedDate,
  cast ( aenam as /plmb/aenam preserving type ) AS ChangeNumberLastChangedByUser,
  cast (fluse as /plmb/inuse preserving type) AS IsUsedForDataDefinition,
  cast (lvorm as /plmb/loekz preserving type) AS ChangeNumberIsMrkdForDeletion,
  lastchangeddatetime AS ChangeNumberLastChgdDateTime
FROM aenr
LEFT OUTER JOIN I_ChangeMasterStatus AS _ChangeNumberStatus ON ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus  -- association [0..1]
LEFT OUTER JOIN I_ChangeMasterFunction AS _ChangeNumberFunction ON ChangeNumberFunction = _ChangeNumberFunction.ChangeNumberFunction  -- association [0..1]
LEFT OUTER JOIN I_ChangeMasterReleaseKey AS _ChangeNumberReleaseKey ON ChangeNumberReleaseKey = _ChangeNumberReleaseKey.ChangeNumberReleaseKey  -- association [0..1]
LEFT OUTER JOIN I_ChangeMasterObjTypeAssgmt AS _ObjTypeAssignment ON ChangeNumber = _ObjTypeAssignment.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMasterAltDate AS _AlternativeDate ON ChangeNumber = _AlternativeDate.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMasterHierarchy AS _LeadingChangeNumber ON ChangeNumber = _LeadingChangeNumber.PackageChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_ChangeMstrObjectMgmtRecord AS _ChangeMstrObjectMgmtRecord ON ChangeNumber = _ChangeMstrObjectMgmtRecord.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMstrObMgReDocInfoRecd AS _ChangeMstrObMgReDocInfoRecd ON ChangeNumber = _ChangeMstrObMgReDocInfoRecd.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMstrObMgReMaterial AS _ChangeMstrObMgReMaterial ON ChangeNumber = _ChangeMstrObMgReMaterial.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMstrObMgReMatlBOM AS _ChangeMstrObMgReMatlBOM ON ChangeNumber = _ChangeMstrObMgReMatlBOM.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON ChangeNumberCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON ChangeNumberLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClfnObjectClassForKeyDate ON ChangeNumber = _ClfnObjectClassForKeyDate.ClfnObjectID AND _ClfnObjectClassForKeyDate.ClfnObjectTable = 'AENR'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _ClfnObjectCharcValForKeyDate ON ChangeNumber = _ClfnObjectCharcValForKeyDate.ClfnObjectID AND _ClfnObjectCharcValForKeyDate.ClfnObjectTable = 'AENR'  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordObjectLink AS _DocumentInfoRecordObjectLink ON ChangeNumber = _DocumentInfoRecordObjectLink.LinkedSAPObjectKey AND _DocumentInfoRecordObjectLink.LinkedSAPObject = 'AENR'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_ECN'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ChangeNumber = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_ECN'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ChangeNumber = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_ECN' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_ECN' AND _LogAccMObjectUserAuthzn.LogAccMReadActivityIsEnabled = 'X' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user AND _LogAccMObjectUserAuthzn.UserID = $session.user  -- association [0..*]
LEFT OUTER JOIN I_ChangeMasterLogAccMActive AS _ChangeMasterLogAccMActive ON _ChangeMasterLogAccMActive.LogAccMObjectType = 'PLM_ECN'  -- association [0..1]
LEFT OUTER JOIN I_ChgMstrLogAccMSecureIDAssgmt AS _ChgMstrLogAccMSecureIDAssgmt ON _ChgMstrLogAccMSecureIDAssgmt.LogAccMObjectID = ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ChangeMstrLogAccMUserAuthzn AS _ChangeMstrLogAccMUserAuthzn ON _ChangeMstrLogAccMUserAuthzn.LogAccMObjectID = ChangeNumber AND _ChangeMstrLogAccMUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND _ChangeMstrLogAccMUserAuthzn.LogAccMReadActivityIsEnabled = 'X' AND _ChangeMstrLogAccMUserAuthzn.UserID = $session.user AND _ChangeMstrLogAccMUserAuthzn.LogAccMUserEntityID = $session.user  -- association [0..*]
;