R_EntProjElmntWorkItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| R_EntProjElmntWorkItem | R_EntProjElmntWorkItem | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1] | I_EnterpriseProjectTP_2 | _EnterpriseProject | $projection.ProjectUUID = _EnterpriseProject.ProjectUUID |
| [0..1] | I_EnterpriseProjectForUser | _EnterpriseProjectForUser | _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA