I_LogAccMContext

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_LogAccMContext.
-- 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: ILOGACCMCONTEXT

CREATE VIEW I_LogAccMContext AS
SELECT
  objid AS LogAccMContextInternalId,
  context_id_ext AS LogAccMContext,
  context_type AS LogAccMContextType,
  is_active AS LogAccMContextIsActivated,
  is_deleted AS LogAccMContextIsDeleted,
  create_datetime AS CreationDateTime,
  create_user_id AS CreatedByUser,
  change_datetime AS LastChangeDateTime,
  change_user_id AS LastChangedByUser
FROM hrp7600
LEFT OUTER JOIN I_LogAccMContextText AS _LogAccMContextText ON LogAccMContextInternalId = _LogAccMContextText.LogAccMContextInternalId  -- 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]
LEFT OUTER JOIN I_LogAccMSecureIDRepository AS _LogAccMSecureIDRepository ON LogAccMContextInternalId = _LogAccMSecureIDRepository.LogAccMSecureIDOwnerID  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_ACC'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON LogAccMContextInternalId = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_ACC'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON LogAccMContextInternalId = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_ACC' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_ACC' AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuthzn.UserID = $session.user )  -- association [0..*]
;