A_ProjNtwkActyRelationship

DDL: A_PROJNTWKACTYRELATIONSHIP Type: view_entity COMPOSITE Package: ODATA_PROJECT_NETWORK_API
21 Fields 1 Data Sources 1 OData Services

Project Network Activity Relationship

A_ProjNtwkActyRelationship is a Composite CDS View that provides data about "Project Network Activity Relationship" in SAP S/4HANA. It reads from 1 data source (R_ProjNtwkActyRelationshipTP) and exposes 21 fields with key fields ProjectNetworkInternalID, ProjNetworkActivityInternalID, ReltdProjNetworkInternalID, ReltdNetworkActivityInternalID, IsSuccessor. It is exposed through 1 OData service (API_PROJECTNETWORK). Part of development package ODATA_PROJECT_NETWORK_API.

Data Sources (1)

SourceAliasJoin Type
R_ProjNtwkActyRelationshipTP R_ProjNtwkActyRelationshipTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Network Activity Relationship view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entitySet.name ProjNtwkActyRelationship view
OData.entityType.name ProjNtwkActyRelationship_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTNETWORK API_PROJECTNETWORK V4 C2 C1

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
KEY ProjNetworkActivityInternalID ProjNetworkActivityInternalID Counter
KEY ReltdProjNetworkInternalID ReltdProjNetworkInternalID
KEY ReltdNetworkActivityInternalID ReltdNetworkActivityInternalID
KEY IsSuccessor IsSuccessor
KEY MaxTimeIntvlIsUsedForSchedg MaxTimeIntvlIsUsedForSchedg
KEY NetworkActivityRelationType NetworkActivityRelationType
ProjectNetwork ProjectNetwork Order
NetworkActivity NetworkActivity Operation/Activity
RelatedProjectNetwork RelatedProjectNetwork Order
RelatedNetworkActivity RelatedNetworkActivity Netwk activity
NetworkActivityRelationTypeExt NetworkActivityRelationTypeExt
FactoryCalendar FactoryCalendar Factory Calendar
NetworkActivityIntmsnDuration NetworkActivityIntmsnDuration
NetworkActivityIntmsnDurnUnit NetworkActivityIntmsnDurnUnit
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
TimeIntvlBtwnRelshpInPct TimeIntvlBtwnRelshpInPct
TimeInterval TimeInterval Time Interval
Plant Plant Valuation Area
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenter WorkCenter Work Center

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 A_ProjNtwkActyRelationship.
-- 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 A_ProjNtwkActyRelationship AS
SELECT
  ProjectNetworkInternalID,
  ProjNetworkActivityInternalID,
  ReltdProjNetworkInternalID,
  ReltdNetworkActivityInternalID,
  IsSuccessor,
  MaxTimeIntvlIsUsedForSchedg,
  NetworkActivityRelationType,
  ProjectNetwork,
  NetworkActivity,
  RelatedProjectNetwork,
  RelatedNetworkActivity,
  NetworkActivityRelationTypeExt,
  FactoryCalendar,
  NetworkActivityIntmsnDuration,
  NetworkActivityIntmsnDurnUnit,
  IsMarkedForDeletion,
  TimeIntvlBtwnRelshpInPct,
  TimeInterval,
  Plant,
  WorkCenterInternalID,
  WorkCenter
FROM R_ProjNtwkActyRelationshipTP
;

Learn More