I_EntProjTeamChgDocuments

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_EntProjTeamChgDocuments.
-- 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 I_EntProjTeamChgDocuments AS
SELECT
  cdhdr.ChangeDocObject AS ChangeDocObject,
  cdhdr.ChangeDocObjectClass AS ChangeDocObjectClass,
  cdpos.DatabaseTable AS DatabaseTable,
  cdpos.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  cdpos.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  EntProject.ProjectUUID AS ProjectUUID,
  EntProject.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  EntProject.Project AS Project,
  EntProject.ProjectDescription AS ProjectName,
  EntProject.ControllingArea AS ControllingArea,
  EntProject.ProfitCenter AS ProfitCenter,
  EntProject.CompanyCode AS CompanyCode,
  EntProject.ResponsibleCostCenter AS ResponsibleCostCenter,
  EntProject.ProjectProfileCode AS ProjectProfileCode,
  EntProject.Plant AS Plant,
  EntProject.EnterpriseProjectType AS EnterpriseProjectType,
  EntProject.FunctionalArea AS FunctionalArea,
  cast (hextobin(cdpos.BusinessPartnerUUID) as sysuuid_x ) AS ResourceUUID,
  ChangeDocPreviousFieldValue AS ChangeDocumentOldFieldValue,
  ChangeDocNewFieldValue AS ChangeDocumentNewFieldValue,
  cdhdr.CreatedByUser AS LastChangedByUser,
  cdhdr.CreationDate AS LastChangeDate,
  cdhdr.CreationTime AS LastChangeTime,
  cdpos.BusinessPartnerRoleName AS BusinessPartnerRoleName
FROM I_ChangeDocument AS cdhdr
INNER JOIN I_EnterpriseProject AS EntProject ON /* join condition not captured in parsed metadata */
INNER JOIN I_EntProjTeamChgDocItem AS cdpos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ContactData AS _ChangedBy ON LastChangedByUser = _ChangedBy.UserID  -- association [0..*]
LEFT OUTER JOIN I_EntProjChangeIndicatorText AS _ChangeTypeText ON ChangeDocItemChangeType = _ChangeTypeText.ChangeDocItemChangeType  -- association [0..*]
LEFT OUTER JOIN I_EntProjChgDocTableFieldText AS _FieldText ON ( _FieldText.ChangeDocDatabaseTableField = ChangeDocDatabaseTableField AND _FieldText.DatabaseTable = cdpos.DatabaseTable )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;