R_EntProjElmntWorkItemTP

DDL: R_ENTPROJELMNTWORKITEMTP Type: view_entity TRANSACTIONAL Package: VDM_PPM_OBJECTS_WORKITEM

Ent.Proj.Elem.Workitem-Trans. Processing

R_EntProjElmntWorkItemTP is a Transactional CDS View that provides data about "Ent.Proj.Elem.Workitem-Trans. Processing" in SAP S/4HANA. It reads from 1 data source (R_EntProjElmntWorkItem) and exposes 16 fields with key field EntProjElmntWorkItemUUID. It has 2 associations to related views. Part of development package VDM_PPM_OBJECTS_WORKITEM.

Data Sources (1)

SourceAliasJoin Type
R_EntProjElmntWorkItem R_EntProjElmntWorkItem from

Associations (2)

CardinalityTargetAliasCondition
[1] I_EnterpriseProjectTP_2 _EnterpriseProject $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
[0..1] I_EnterpriseProjectForUser _EnterpriseProjectForUser _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Ent.Proj.Elem.Workitem-Trans. Processing view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EntProjElmntWorkItemUUID EntProjElmntWorkItemUUID
EntProjElmntWorkItem EntProjElmntWorkItem
EntProjElmntWorkItemName EntProjElmntWorkItemName
EntProjElmntWorkItemIsInactive EntProjElmntWorkItemIsInactive
EntProjElmntWorkItemIsCnfgrd EntProjElmntWorkItemIsCnfgrd
ProjectUUID ProjectUUID
ProjectElementUUID ProjectElementUUID
EntProjElmntWrkItmLastUpdtSrce EntProjElmntWrkItmLastUpdtSrce
EntProjElmntWrkItmCrtedByUsr EntProjElmntWrkItmCrtedByUsr
EntProjElmntWrkItmCrtnDteTme EntProjElmntWrkItmCrtnDteTme
EntProjElmntWrkItmLstChgByUsr EntProjElmntWrkItmLstChgByUsr
EntProjElmntWrkItmLstChgDteTme EntProjElmntWrkItmLstChgDteTme
_WorkItemText _WorkItemText
_EnterpriseProjectElement _EnterpriseProjectElement
_EnterpriseProject _EnterpriseProject
_EnterpriseProjectForUser _EnterpriseProjectForUser
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Ent.Proj.Elem.Workitem-Trans. Processing'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view entity R_EntProjElmntWorkItemTP
  as select from R_EntProjElmntWorkItem
  association        to parent I_EnterpriseProjectElementTP_2 as _EnterpriseProjectElement on  $projection.ProjectElementUUID = _EnterpriseProjectElement.ProjectElementUUID

  association [1]    to I_EnterpriseProjectTP_2               as _EnterpriseProject        on  $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
  //For Cat 7 Authorization

  association [0..1] to I_EnterpriseProjectForUser            as _EnterpriseProjectForUser on  _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID  
{
  key EntProjElmntWorkItemUUID,
      EntProjElmntWorkItem,
      EntProjElmntWorkItemName,
      @Semantics.booleanIndicator: true
      EntProjElmntWorkItemIsInactive,
      @Semantics.booleanIndicator: true
      EntProjElmntWorkItemIsCnfgrd,
      ProjectUUID,
      ProjectElementUUID,
      EntProjElmntWrkItmLastUpdtSrce,
      EntProjElmntWrkItmCrtedByUsr,
      EntProjElmntWrkItmCrtnDteTme,
      EntProjElmntWrkItmLstChgByUsr,
      EntProjElmntWrkItmLstChgDteTme,

      // Associations

      _WorkItemText,
      _EnterpriseProjectElement,
      _EnterpriseProject,
      _EnterpriseProjectForUser

}