C_ProjectObjectActivityRltnTP

DDL: C_PROJECTOBJECTACTIVITYRLTNTP Type: view_entity CONSUMPTION
22 Fields 1 Data Sources 2 Associations

Project Object Activity Relationship

C_ProjectObjectActivityRltnTP is a Consumption CDS View that provides data about "Project Object Activity Relationship" in SAP S/4HANA. It reads from 1 data source (R_ProjectObjectActivityRltnTP) and exposes 22 fields with key fields ProjectObjectNode, ProjectObjectNodeType, PredecessorProjectObjectNode, SuccessorProjectObjectNode, NetworkActivityRelationType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectObjectActivityRltnTP R_ProjectObjectActivityRltnTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProjSchedMaintOrderData _MaintOrderPredecessor _MaintOrderPredecessor.OrderInternalBillOfOperations = $projection.PredecessorProjNtwkIntID
[0..1] I_ProjSchedMaintOrderData _MaintOrderSuccessor _MaintOrderSuccessor.OrderInternalBillOfOperations = $projection.SuccessorProjNtwkIntID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Object Activity Relationship view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectNode ProjectObjectNode Object number
KEY ProjectObjectNodeType ProjectObjectNodeType Object Type in PS
KEY PredecessorProjectObjectNode PredecessorProjectObjectNode
KEY SuccessorProjectObjectNode SuccessorProjectObjectNode
KEY NetworkActivityRelationType NetworkActivityRelationType
KEY MaxTimeIntvlIsUsedForSchedg MaxTimeIntvlIsUsedForSchedg
KEY ProjectObjectRootNode ProjectObjectRootNode Object number
PredecessorProjNtwkIntID PredecessorProjNtwkIntID
PredecessorNtwkActyIntID PredecessorNtwkActyIntID
PredecessorNetworkActivity PredecessorNetworkActivity
PredecessorProjectNetwork PredecessorProjectNetwork
SuccessorProjNtwkIntID SuccessorProjNtwkIntID
SuccessorNtwkActyIntID SuccessorNtwkActyIntID
SuccessorNetworkActivity SuccessorNetworkActivity
SuccessorProjectNetwork SuccessorProjectNetwork
NetworkActyRelationDescription NetworkActyRelationDescription
Plant Plant Valuation Area
WorkCenter WorkCenter Work Center
ProjectNetworkObject ProjectNetworkObject
WorkCenterInternalID WorkCenterInternalID Work Center
_MaintOrderPredecessor _MaintOrderPredecessor
_MaintOrderSuccessor _MaintOrderSuccessor

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 C_ProjectObjectActivityRltnTP.
-- 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.

CREATE VIEW C_ProjectObjectActivityRltnTP AS
SELECT
  ProjectObjectNode,
  ProjectObjectNodeType,
  PredecessorProjectObjectNode,
  SuccessorProjectObjectNode,
  NetworkActivityRelationType,
  MaxTimeIntvlIsUsedForSchedg,
  ProjectObjectRootNode,
  PredecessorProjNtwkIntID,
  PredecessorNtwkActyIntID,
  PredecessorNetworkActivity,
  PredecessorProjectNetwork,
  SuccessorProjNtwkIntID,
  SuccessorNtwkActyIntID,
  SuccessorNetworkActivity,
  SuccessorProjectNetwork,
  NetworkActyRelationDescription,
  Plant,
  WorkCenter,
  ProjectNetworkObject,
  WorkCenterInternalID
FROM R_ProjectObjectActivityRltnTP
LEFT OUTER JOIN I_ProjSchedMaintOrderData AS _MaintOrderPredecessor ON _MaintOrderPredecessor.OrderInternalBillOfOperations = PredecessorProjNtwkIntID  -- association [0..1]
LEFT OUTER JOIN I_ProjSchedMaintOrderData AS _MaintOrderSuccessor ON _MaintOrderSuccessor.OrderInternalBillOfOperations = SuccessorProjNtwkIntID  -- association [0..1]
;

Learn More