R_EntProjElmntWorkItemTP

DDL: R_ENTPROJELMNTWORKITEMTP Type: view_entity TRANSACTIONAL

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.

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_ENTPROJELMNTWORKITEM"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECTELEMENTTP_2",
"I_ENTERPRISEPROJECTFORUSER",
"I_ENTERPRISEPROJECTTP_2",
"I_WORKITEMTEXT"
],
"BASE":
[
"R_ENTPROJELMNTWORKITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/