I_EntProjectElementJVATP

DDL: I_ENTPROJECTELEMENTJVATP SQL: IENTPRJELEMJVATP Type: view COMPOSITE
18 Fields 1 Data Sources 6 Associations

Extension fields for JVA on Task level

I_EntProjectElementJVATP is a Composite 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 18 fields with key field ProjectElementUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectTaskJVA ProjectElementJVA from

Associations (6)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IENTPRJELEMJVATP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE 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 (18)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID TaskUUID
WBSElementInternalID I_PPM_ProjectTaskJVA WBSElementInternalID WBS Internal ID
ProjectUUID I_PPM_ProjectTaskJVA ProjectUUID Project UUID
ControllingArea I_PPM_ProjectTaskJVA ControllingArea Controlling Area
ProfitCenter I_PPM_ProjectTaskJVA ProfitCenter Profit Center
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JntVntrProjectType JntVntrProjectType JV Object Type
JntIntrstBillgClass JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgSubClass JntIntrstBillgSubClass JIB/JIBE SbClsA
ProjectLastChangedDateTime _EnterpriseProject LastChangeDateTime Timestamp
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_EnterpriseProject _EnterpriseProject
_EnterpriseProjectElement _EnterpriseProjectElement

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EntProjectElementJVATP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IENTPRJELEMJVATP

CREATE VIEW I_EntProjectElementJVATP AS
SELECT
  TaskUUID AS ProjectElementUUID,
  ProjectElementJVA.WBSElementInternalID AS WBSElementInternalID,
  ProjectElementJVA.ProjectUUID AS ProjectUUID,
  ProjectElementJVA.ControllingArea AS ControllingArea,
  ProjectElementJVA.ProfitCenter AS ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  JntVntrProjectType,
  JntIntrstBillgClass,
  JntIntrstBillgSubClass,
  _EnterpriseProject.LastChangeDateTime AS ProjectLastChangedDateTime
FROM I_PPM_ProjectTaskJVA AS ProjectElementJVA
LEFT OUTER JOIN I_EnterpriseProjectElementTP AS _ProjectElement ON _ProjectElement.ProjectElementUUID = ProjectElementUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectTP AS _EnterpriseProject ON ProjectElementJVA.ProjectUUID = _EnterpriseProject.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectElementUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectElementUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectElementUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectElementUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;

Learn More