I_EntProjectElementJVATP_2
Extension fields for JVA on Task level
I_EntProjectElementJVATP_2 is a Transactional CDS View that provides data about "Extension fields for JVA on Task level" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectTaskJVA) and exposes 26 fields with key field ProjectElementUUID. It has 14 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PPM_ProjectTaskJVA | ProjectElementJVA | from |
Associations (14)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_EnterpriseProjectTP_2 | _EnterpriseProject | ProjectElementJVA.ProjectUUID = _EnterpriseProject.ProjectUUID |
| [0..1] | I_JntVntrValueHelp | _JointVentureVH | $projection.JointVenture = _JointVentureVH.JointVenture and $projection.CompanyCode = _JointVentureVH.CompanyCode |
| [0..1] | I_JointVentureDesc | _JointVentureText | $projection.JointVenture = _JointVentureText.JointVenture and $projection.CompanyCode = _JointVentureText.CompanyCode and _JointVentureText.Language = $session.system_language |
| [0..1] | I_JntVntrRecoveryIndVH | _JntVntrCostRecoveryCodeVH | $projection.JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeVH.JointVentureRecoveryCode and $projection.CompanyCode = _JntVntrCostRecoveryCodeVH.CompanyCode |
| [0..1] | I_JntVntrRecoveryIndText | _JntVntrCostRecoveryCodeText | $projection.JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeText.JointVentureRecoveryCode and $projection.CompanyCode = _JntVntrCostRecoveryCodeText.CompanyCode and _JntVntrCostRecoveryCodeText.Language = $session.system_language |
| [0..1] | I_JntVntrEquityTypeVH | _JntVntrEquityTypeVH | $projection.JointVentureEquityType = _JntVntrEquityTypeVH.JointVentureEquityType and $projection.CompanyCode = _JntVntrEquityTypeVH.CompanyCode |
| [0..1] | I_JntVntrEquityTypeDesc | _JntVntrEquityTypeText | $projection.JointVentureEquityType = _JntVntrEquityTypeText.JointVentureEquityType and $projection.CompanyCode = _JntVntrEquityTypeText.CompanyCode and _JntVntrEquityTypeText.Language = $session.system_language |
| [0..1] | I_JntVntrProjectTypeVH | _JntVntrProjectTypeVH | $projection.JntVntrProjectType = _JntVntrProjectTypeVH.JntVntrProjectType and $projection.CompanyCode = _JntVntrProjectTypeVH.CompanyCode |
| [0..1] | I_JntVntrProjectTypeText | _JntVntrProjectTypeText | $projection.JntVntrProjectType = _JntVntrProjectTypeText.JntVntrProjectType and $projection.CompanyCode = _JntVntrProjectTypeText.CompanyCode and _JntVntrProjectTypeText.Language = $session.system_language |
| [0..1] | I_JntIntrstBillgClassVH | _JntIntrstBillgClassVH | $projection.JntIntrstBillgClass = _JntIntrstBillgClassVH.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgClassVH.CompanyCode |
| [0..1] | I_JntIntrstBillgClassText | _JntIntrstBillgClassText | $projection.JntIntrstBillgClass = _JntIntrstBillgClassText.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgClassText.CompanyCode and _JntIntrstBillgClassText.Language = $session.system_language |
| [0..1] | I_JntIntrstBillgSubclassVH | _JntIntrstBillgSubclassVH | $projection.JntIntrstBillgSubClass = _JntIntrstBillgSubclassVH.JntIntrstBillgSubClass and $projection.JntIntrstBillgClass = _JntIntrstBillgSubclassVH.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgSubclassVH.CompanyCode |
| [0..1] | I_JntIntrstBillgSubclassT | _JntIntrstBillgSubclassText | $projection.JntIntrstBillgSubClass = _JntIntrstBillgSubclassText.JntIntrstBillgSubClass and $projection.JntIntrstBillgClass = _JntIntrstBillgSubclassText.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgSubclassText.CompanyCode and _JntIntrstBillgSubclassText.Language = $session.system_language |
| [0..1] | I_JointVentureTypeText | _JntTypeText | $projection.JointVentureType = _JntTypeText.JointVentureType and _JntTypeText.Language = $session.system_language |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | ProjectElementUUID | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| EndUserText.label | Extension fields for JVA on Task level | view |
Fields (26)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectElementUUID | TaskUUID | ||
| WBSElementInternalID | I_PPM_ProjectTaskJVA | WBSElementInternalID | ||
| ProjectUUID | I_PPM_ProjectTaskJVA | ProjectUUID | ||
| JointVenture | JointVenture | |||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | |||
| JointVentureEquityType | JointVentureEquityType | |||
| JntVntrProjectType | JntVntrProjectType | |||
| JntIntrstBillgClass | JntIntrstBillgClass | |||
| JntIntrstBillgSubClass | JntIntrstBillgSubClass | |||
| JointVentureType | JointVentureType | |||
| CompanyCode | _EnterpriseProjectElement | CompanyCode | ||
| _EnterpriseProject | _EnterpriseProject | |||
| _EnterpriseProjectElement | _EnterpriseProjectElement | |||
| _JointVentureVH | _JointVentureVH | |||
| _JointVentureText | _JointVentureText | |||
| _JntVntrCostRecoveryCodeVH | _JntVntrCostRecoveryCodeVH | |||
| _JntVntrCostRecoveryCodeText | _JntVntrCostRecoveryCodeText | |||
| _JntVntrEquityTypeVH | _JntVntrEquityTypeVH | |||
| _JntVntrEquityTypeText | _JntVntrEquityTypeText | |||
| _JntVntrProjectTypeVH | _JntVntrProjectTypeVH | |||
| _JntVntrProjectTypeText | _JntVntrProjectTypeText | |||
| _JntIntrstBillgClassVH | _JntIntrstBillgClassVH | |||
| _JntIntrstBillgClassText | _JntIntrstBillgClassText | |||
| _JntIntrstBillgSubclassVH | _JntIntrstBillgSubclassVH | |||
| _JntIntrstBillgSubclassText | _JntIntrstBillgSubclassText | |||
| _JntTypeText | _JntTypeText |
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
representativeKey: 'ProjectElementUUID',
alternativeKey: [ { id : 'WBSElementInternalID', element: ['WBSElementInternalID'], uniqueness: #UNIQUE } ],
usageType:
{
serviceQuality: #D,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Extension fields for JVA on Task level'
define view entity I_EntProjectElementJVATP_2
as select from I_PPM_ProjectTaskJVA as ProjectElementJVA
association to parent I_EnterpriseProjectElementTP_2 as _EnterpriseProjectElement on $projection.ProjectElementUUID = _EnterpriseProjectElement.ProjectElementUUID
association [1..1] to I_EnterpriseProjectTP_2 as _EnterpriseProject on ProjectElementJVA.ProjectUUID = _EnterpriseProject.ProjectUUID
association [0..1] to I_JntVntrValueHelp as _JointVentureVH on $projection.JointVenture = _JointVentureVH.JointVenture
and $projection.CompanyCode = _JointVentureVH.CompanyCode
association [0..1] to I_JointVentureDesc as _JointVentureText on $projection.JointVenture = _JointVentureText.JointVenture
and $projection.CompanyCode = _JointVentureText.CompanyCode
and _JointVentureText.Language = $session.system_language
association [0..1] to I_JntVntrRecoveryIndVH as _JntVntrCostRecoveryCodeVH on $projection.JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeVH.JointVentureRecoveryCode
and $projection.CompanyCode = _JntVntrCostRecoveryCodeVH.CompanyCode
association [0..1] to I_JntVntrRecoveryIndText as _JntVntrCostRecoveryCodeText on $projection.JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeText.JointVentureRecoveryCode
and $projection.CompanyCode = _JntVntrCostRecoveryCodeText.CompanyCode
and _JntVntrCostRecoveryCodeText.Language = $session.system_language
association [0..1] to I_JntVntrEquityTypeVH as _JntVntrEquityTypeVH on $projection.JointVentureEquityType = _JntVntrEquityTypeVH.JointVentureEquityType
and $projection.CompanyCode = _JntVntrEquityTypeVH.CompanyCode
association [0..1] to I_JntVntrEquityTypeDesc as _JntVntrEquityTypeText on $projection.JointVentureEquityType = _JntVntrEquityTypeText.JointVentureEquityType
and $projection.CompanyCode = _JntVntrEquityTypeText.CompanyCode
and _JntVntrEquityTypeText.Language = $session.system_language
association [0..1] to I_JntVntrProjectTypeVH as _JntVntrProjectTypeVH on $projection.JntVntrProjectType = _JntVntrProjectTypeVH.JntVntrProjectType
and $projection.CompanyCode = _JntVntrProjectTypeVH.CompanyCode
association [0..1] to I_JntVntrProjectTypeText as _JntVntrProjectTypeText on $projection.JntVntrProjectType = _JntVntrProjectTypeText.JntVntrProjectType
and $projection.CompanyCode = _JntVntrProjectTypeText.CompanyCode
and _JntVntrProjectTypeText.Language = $session.system_language
association [0..1] to I_JntIntrstBillgClassVH as _JntIntrstBillgClassVH on $projection.JntIntrstBillgClass = _JntIntrstBillgClassVH.JntIntrstBillgClass
and $projection.CompanyCode = _JntIntrstBillgClassVH.CompanyCode
association [0..1] to I_JntIntrstBillgClassText as _JntIntrstBillgClassText on $projection.JntIntrstBillgClass = _JntIntrstBillgClassText.JntIntrstBillgClass
and $projection.CompanyCode = _JntIntrstBillgClassText.CompanyCode
and _JntIntrstBillgClassText.Language = $session.system_language
association [0..1] to I_JntIntrstBillgSubclassVH as _JntIntrstBillgSubclassVH on $projection.JntIntrstBillgSubClass = _JntIntrstBillgSubclassVH.JntIntrstBillgSubClass
and $projection.JntIntrstBillgClass = _JntIntrstBillgSubclassVH.JntIntrstBillgClass
and $projection.CompanyCode = _JntIntrstBillgSubclassVH.CompanyCode
association [0..1] to I_JntIntrstBillgSubclassT as _JntIntrstBillgSubclassText on $projection.JntIntrstBillgSubClass = _JntIntrstBillgSubclassText.JntIntrstBillgSubClass
and $projection.JntIntrstBillgClass = _JntIntrstBillgSubclassText.JntIntrstBillgClass
and $projection.CompanyCode = _JntIntrstBillgSubclassText.CompanyCode
and _JntIntrstBillgSubclassText.Language = $session.system_language
association [0..1] to I_JointVentureTypeText as _JntTypeText on $projection.JointVentureType = _JntTypeText.JointVentureType
and _JntTypeText.Language = $session.system_language
{
key TaskUUID as ProjectElementUUID,
ProjectElementJVA.WBSElementInternalID as WBSElementInternalID,
ProjectElementJVA.ProjectUUID as ProjectUUID,
@Consumption: {
valueHelp: '_JOINTVENTUREVH',
filter.hidden: true
}
JointVenture,
@Consumption.valueHelp: '_JntVntrCostRecoveryCodeVH'
JointVentureCostRecoveryCode,
@Consumption.valueHelp: '_JntVntrEquityTypeVH'
JointVentureEquityType,
@Consumption.valueHelp: '_JntVntrProjectTypeVH'
JntVntrProjectType,
@Consumption.valueHelp: '_JntIntrstBillgClassVH'
JntIntrstBillgClass,
@Consumption.valueHelp: '_JntIntrstBillgSubclassVH'
JntIntrstBillgSubClass,
JointVentureType,
_EnterpriseProjectElement.CompanyCode as CompanyCode,
//Association
_EnterpriseProject,
_EnterpriseProjectElement,
_JointVentureVH,
_JointVentureText,
_JntVntrCostRecoveryCodeVH,
_JntVntrCostRecoveryCodeText,
_JntVntrEquityTypeVH,
_JntVntrEquityTypeText,
_JntVntrProjectTypeVH,
_JntVntrProjectTypeText,
_JntIntrstBillgClassVH,
_JntIntrstBillgClassText,
_JntIntrstBillgSubclassVH,
_JntIntrstBillgSubclassText,
_JntTypeText
}
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