R_EntProjectBlockFunctionTP

@AbapCatalog.sqlViewName: 'RENTPRJBLKFUNCTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Transactional Processing for proj block function'
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
//@feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    representativeKey: 'ProjectUUID',
//   alternativeKey: [ { id : 'ProjectSummaryTaskUUID',   element: ['ProjectSummaryTaskUUID'], uniqueness: #UNIQUE },

//                     { id : 'ProjectInternalID',        element: ['ProjectInternalID'], uniqueness: #UNIQUE }], 

    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}
define view R_EntProjectBlockFunctionTP
  as select from I_BlockFuncForEntProject as ProjectBlkFunc
  //inner join I_EnterpriseProjectTP as Project on ProjectBlkFunc.ProjectUUID = Project.ProjectUUID

  // associations to authorization views

  association        to parent I_EnterpriseProjectTP as _EnterpriseProject on  $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
  association [0..*] to I_PPM_AuthznByUsrH           as _AuthUser          on  _AuthUser.ReferencedObjectUUID = $projection.ProjectUUID
                                                                           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.ProjectUUID
                                                                           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.ProjectUUID
                                                                           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.ProjectUUID
                                                                           and _AuthGroup.UserID               = $session.user
                                                                           and (
                                                                              _AuthGroup.Activity              = 'Admin'
                                                                              or _AuthGroup.Activity           = 'Write'
                                                                              or _AuthGroup.Activity           = 'Read'
                                                                            )
{
      //@ObjectModel.readOnly:true

  key ProjectBlkFunc.ProjectUUID,
      //@ObjectModel.readOnly:true

      ProjectBlkFunc.ParentObjectUUID,

      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,
      //Project.LastChangeDateTime as ProjectLastChangedDateTime,

      //_EnterpriseProject.LastChangeDateTime as ProjectLastChangedDateTime,

      _EnterpriseProject,
      _AuthUser,
      _AuthSubst,
      _AuthRole,
      _AuthGroup
            
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BLOCKFUNCFORENTPROJECT"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECTTP",
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/