P_PROJWITHPROJCAT6

CDS View

Enterprise Proj and Project with Project Category 7

P_PROJWITHPROJCAT6 is a CDS View in S/4HANA. Enterprise Proj and Project with Project Category 7. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_ENTPROJECTACTCOSTS view from COMPOSITE Project Cost Line Items with Actual Costs
P_ENTPROJECTCMTMTCOSTS view from COMPOSITE Project Cost Line Items with Commitment Costs
P_ENTPROJECTPLNCOSTS view from COMPOSITE Project Cost Line Items with Planning Category Costs
P_ENTPROJPPLNCOSTS view from COMPOSITE Project Cost Line Items with Planning Category Costs

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ProjectInternalID ProjectInternalID 4 
@AbapCatalog.sqlViewName: 'PPROJCAT6'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PROJWITHPROJCAT6
  as select from R_EnterpriseProject   as Project
    inner join   I_WBSElementBasicData as WBS on  Project.WBSElementInternalID = WBS.WBSElementInternalID
                                              and Project.ProjectInternalID    = WBS.ProjectInternalID

  // associations to authorization views

  association [0..*] to I_PPM_AuthznByUsrH      as _AuthUser    on  _AuthUser.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                and _AuthUser.UserID               = $session.user
                                                                and (
                                                                   _AuthUser.Activity              = 'Admin'
                                                                   or _AuthUser.Activity           = 'Write'
                                                                   or _AuthUser.Activity           = 'Read'
                                                                 )
  association [0..*] to I_PPM_AuthznBySubstitH  as _AuthSubst   on  _AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                and _AuthSubst.UserID               = $session.user
                                                                and (
                                                                   _AuthSubst.Activity              = 'Admin'
                                                                   or _AuthSubst.Activity           = 'Write'
                                                                   or _AuthSubst.Activity           = 'Read'
                                                                 )
  association [0..*] to I_PPM_AuthznByUserRoleH as _AuthRole    on  _AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                and _AuthRole.UserID               = $session.user
                                                                and (
                                                                   _AuthRole.Activity              = 'Admin'
                                                                   or _AuthRole.Activity           = 'Write'
                                                                   or _AuthRole.Activity           = 'Read'
                                                                 )
  association [0..*] to I_PPM_AuthznByUsrGrpH   as _AuthGroup   on  _AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                and _AuthGroup.UserID               = $session.user
                                                                and (
                                                                   _AuthGroup.Activity              = 'Admin'
                                                                   or _AuthGroup.Activity           = 'Write'
                                                                   or _AuthGroup.Activity           = 'Read'
                                                                 )

  // PS Root WBS Element

  association [0..1] to I_WBSElementBasicData   as _ProjObjRoot on  _ProjObjRoot.WBSElementInternalID = $projection.WBSElementInternalID

{
  key Project.ProjectInternalID,
      Project.ProjectUUID,
      Project.ProjectSummaryTaskUUID,
      Project.ProjectCategory,
      Project.WBSElementInternalID,
      WBS.CompanyCode,
      //for DCL

      Project.ProjectProfileCode,

      _ProjObjRoot,
      _AuthUser,
      _AuthSubst,
      _AuthRole,
      _AuthGroup

}
where
  Project.ProjectCategory = '6'

Learn More