R_EntProjElmntBlockFuncTP

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 R_EntProjElmntBlockFuncTP.
-- 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: RPRJELMNTBLKTP

CREATE VIEW R_EntProjElmntBlockFuncTP AS
SELECT
  TaskUUID,
  I_BlockFuncForEntProjElmnt.ProjectUUID AS ProjectUUID,
  cast(EntProjTimeRecgIsBlkd as boolean preserving type ) AS EntProjTimeRecgIsBlkd,
  cast(EntProjStaffExpensePostgIsBlkd as boolean preserving type ) AS EntProjStaffExpensePostgIsBlkd,
  cast(EntProjServicePostingIsBlkd as boolean preserving type ) AS EntProjServicePostingIsBlkd,
  cast(EntProjOtherExpensePostgIsBlkd as boolean preserving type ) AS EntProjOtherExpensePostgIsBlkd,
  cast(EntProjPurchasingIsBlkd as boolean preserving type ) AS EntProjPurchasingIsBlkd
FROM I_BlockFuncForEntProjElmnt
INNER JOIN I_EnterpriseProject AS EntProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectUUID 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 = ProjectUUID 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 = ProjectUUID 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 = ProjectUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;