P_PROJWITHPROJCAT6

DDL: P_PROJWITHPROJCAT6 SQL: PPROJCAT6 Type: view COMPOSITE Package: ODATA_PS_COS_PROJFIN_MNTR

Enterprise Proj and Project with Project Category 7

P_PROJWITHPROJCAT6 is a Composite CDS View that provides data about "Enterprise Proj and Project with Project Category 7" in SAP S/4HANA. It reads from 2 data sources (R_EnterpriseProject, I_WBSElementBasicData) and exposes 12 fields with key field ProjectInternalID. It has 5 associations to related views. Part of development package ODATA_PS_COS_PROJFIN_MNTR.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
R_EnterpriseProject Project from
I_WBSElementBasicData WBS inner

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_PPM_AuthznByUsrH _AuthUser _AuthUser.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthUser.UserID = $session.user and ( _AuthUser.Activity = 'Admin' or _AuthUser.Activity = 'Write' or _AuthUser.Activity = 'Read' )
[0..*] I_PPM_AuthznBySubstitH _AuthSubst _AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthSubst.UserID = $session.user and ( _AuthSubst.Activity = 'Admin' or _AuthSubst.Activity = 'Write' or _AuthSubst.Activity = 'Read' )
[0..*] I_PPM_AuthznByUserRoleH _AuthRole _AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthRole.UserID = $session.user and ( _AuthRole.Activity = 'Admin' or _AuthRole.Activity = 'Write' or _AuthRole.Activity = 'Read' )
[0..*] I_PPM_AuthznByUsrGrpH _AuthGroup _AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' or _AuthGroup.Activity = 'Read' )
[0..1] I_WBSElementBasicData _ProjObjRoot _ProjObjRoot.WBSElementInternalID = $projection.WBSElementInternalID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPROJCAT6 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID R_EnterpriseProject ProjectInternalID
ProjectUUID R_EnterpriseProject ProjectUUID
ProjectSummaryTaskUUID R_EnterpriseProject ProjectSummaryTaskUUID
ProjectCategory R_EnterpriseProject ProjectCategory
WBSElementInternalID R_EnterpriseProject WBSElementInternalID
CompanyCode I_WBSElementBasicData CompanyCode
ProjectProfileCode R_EnterpriseProject ProjectProfileCode
_ProjObjRoot _ProjObjRoot
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup 
@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