A_ChangeMaster_1

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 A_ChangeMaster_1.
-- 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 A_ChangeMaster_1 AS
SELECT
  ChangeNumber,
  ChangeNumberStatus,
  AuthorizationGroup,
  ChangeNumberFunction,
  IsTechnicallyReleased,
  ChangeNumberReleaseKey,
  ReasonForChangeText,
  ChangeNumberDescription,
  ChangeNumberValidFromDate,
  ChangeNumberCreationDate,
  ChangeNumberCreatedByUser,
  ChangeNumberLastChangedDate,
  ChangeNumberLastChangedByUser,
  IsUsedForDataDefinition,
  ChangeNumberIsMrkdForDeletion,
  ChangeNumberLastChgdDateTime
FROM I_ChangeMasterTP
LEFT OUTER JOIN A_ChangeMasterClass AS _Classification ON ChangeNumber = _Classification.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN A_ChangeMasterCharc AS _Characteristics ON ChangeNumber = _Characteristics.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN A_ChangeMasterStatus AS _ChangeNumberStatus ON ChangeNumberStatus = _ChangeNumberStatus.ChangeNumberStatus  -- association [0..1]
LEFT OUTER JOIN A_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_ECN'  -- association [0..1]
LEFT OUTER JOIN A_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ChangeNumber = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_ECN'  -- association [0..*]
LEFT OUTER JOIN A_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ChangeNumber = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_ECN' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_ECN' AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuthzn.UserID = $session.user )  -- association [0..*]
LEFT OUTER JOIN A_ChangeMasterAltDate_1 AS _AlternativeDate ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_ChangeMasterObjTypeAssgmt_1 AS _ObjTypeAssignment ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_ChangeMstrObjectMgmtRecord AS _ChangeMstrObjectMgmtRecord ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_ChangeMstrObMgReMaterial AS _ChangeMstrObMgReMaterial ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_ChangeMstrObMgReMatlBOM AS _ChangeMstrObMgReMatlBOM ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_ChangeMstrObMgReDocInfoRecd AS _ChangeMstrObMgReDocInfoRecd ON /* condition not available in parsed metadata */  -- association [1..*]
;