R_EntProjElmntBlockFuncTP

DDL: R_ENTPROJELMNTBLOCKFUNCTP SQL: RPRJELMNTBLKTP Type: view TRANSACTIONAL

Transactional Processing for proj elmnt block function

R_EntProjElmntBlockFuncTP is a Transactional CDS View that provides data about "Transactional Processing for proj elmnt block function" in SAP S/4HANA. It reads from 2 data sources (I_EnterpriseProject, I_BlockFuncForEntProjElmnt) and exposes 12 fields with key field TaskUUID. It has 4 associations to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_EnterpriseProject EntProject inner
I_BlockFuncForEntProjElmnt I_BlockFuncForEntProjElmnt from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_PPM_AuthznByUsrH _AuthUser _AuthUser.ReferencedObjectUUID = $projection.ProjectUUID 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.ProjectUUID 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.ProjectUUID 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.ProjectUUID and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' or _AuthGroup.Activity = 'Read' )

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RPRJELMNTBLKTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Transactional Processing for proj elmnt block function view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TaskUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID TaskUUID
ProjectUUID I_BlockFuncForEntProjElmnt ProjectUUID
EntProjTimeRecgIsBlkd
EntProjStaffExpensePostgIsBlkd
EntProjServicePostingIsBlkd
EntProjOtherExpensePostgIsBlkd
EntProjPurchasingIsBlkd
_EntProjElmntBlkFunc _EntProjElmntBlkFunc
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup 
@AbapCatalog.sqlViewName: 'RPRJELMNTBLKTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Transactional Processing for proj elmnt block function'
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    representativeKey: 'TaskUUID',
    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}
define view R_EntProjElmntBlockFuncTP as select from I_BlockFuncForEntProjElmnt 
inner join I_EnterpriseProject as EntProject on EntProject.ProjectUUID = I_BlockFuncForEntProjElmnt.ProjectUUID
  association  to parent I_EnterpriseProjectElementTP as _EntProjElmntBlkFunc on  $projection.ProjectUUID = _EntProjElmntBlkFunc.ProjectElementUUID
  
  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

  key TaskUUID,
      //@ObjectModel.readOnly

      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,
      //_EntProjElmntBlkFunc.LastChangeDateTime as ProjectLastChangeDateTime,

      _EntProjElmntBlkFunc,
      _AuthUser,
      _AuthSubst,
      _AuthRole,
      _AuthGroup
}
where EntProject.ProjectCategory <> '7'

Learn More