I_NtwkActRltnVersBasicData

DDL: I_NTWKACTRLTNVERSBASICDATA SQL: INTWKACTRELBDV Type: view COMPOSITE
27 Fields 1 Data Sources

Activity Relationship Version Basic Data

I_NtwkActRltnVersBasicData is a Composite CDS View that provides data about "Activity Relationship Version Basic Data" in SAP S/4HANA. It reads from 1 data source (I_ProjNtwkVersRelationship) and exposes 27 fields with key fields PredecessorProjNtwkIntID, PredecessorNtwkActyIntID, SuccessorProjNtwkIntID, SuccessorNtwkActyIntID, NetworkActivityRelationType.

Data Sources (1)

SourceAliasJoin Type
I_ProjNtwkVersRelationship I_ProjNtwkVersRelationship from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName INTWKACTRELBDV view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Activity Relationship Version Basic Data view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PredecessorProjNtwkIntID PredecessorProjNtwkIntID Prdcsr ID no.
KEY PredecessorNtwkActyIntID PredecessorNtwkActyIntID Counter
KEY SuccessorProjNtwkIntID SuccessorProjNtwkIntID No. identifying the network to which the successor belongs
KEY SuccessorNtwkActyIntID SuccessorNtwkActyIntID Counter
KEY NetworkActivityRelationType NetworkActivityRelationType
KEY MaxTimeIntvlIsUsedForSchedg MaxTimeIntvlIsUsedForSchedg Max. interval
KEY Version Version XML Vers.
PredecessorProjectObjectNode _NetworkActivityPredecessor NetworkActivityObject
PredecessorProjectNetwork _ProjectNetworkPredecessor ProjectNetwork Order
PredecessorNetworkActivity _NetworkActivityPredecessor NetworkActivity Operation/Activity
SuccessorProjectObjectNode _NetworkActivitySuccessor NetworkActivityObject
SuccessorProjectNetwork _ProjectNetworkSuccessor ProjectNetwork Order
SuccessorNetworkActivity _NetworkActivitySuccessor NetworkActivity Operation/Activity
ProjectNetworkObject ProjectNetworkObject Val. Obj. No.
NetworkActivityIntmsnDuration NetworkActivityIntmsnDuration Time Interval
NetworkActivityIntmsnDurnUnit NetworkActivityIntmsnDurnUnit Time unit/meas.
ObjectIsDeleted ObjectIsDeleted Status
TimeIntvlBtwnRelshpInPct TimeIntvlBtwnRelshpInPct Time interval %
TimeInterval TimeInterval Time Interval
FactoryCalendar FactoryCalendar Factory Calendar
Plant Plant Valuation Area
WorkCenterInternalID WorkCenterInternalID Work Center
_NetworkActivityPredecessor _NetworkActivityPredecessor
_NetworkActivitySuccessor _NetworkActivitySuccessor
_ProjectNetworkPredecessor _ProjectNetworkPredecessor
_ProjectNetworkSuccessor _ProjectNetworkSuccessor
_RelshpTypeText _RelshpTypeText

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_NtwkActRltnVersBasicData.
-- 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: INTWKACTRELBDV

CREATE VIEW I_NtwkActRltnVersBasicData AS
SELECT
  PredecessorProjNtwkIntID,
  PredecessorNtwkActyIntID,
  SuccessorProjNtwkIntID,
  SuccessorNtwkActyIntID,
  NetworkActivityRelationType,
  MaxTimeIntvlIsUsedForSchedg,
  Version,
  _NetworkActivityPredecessor.NetworkActivityObject AS PredecessorProjectObjectNode,
  _ProjectNetworkPredecessor.ProjectNetwork AS PredecessorProjectNetwork,
  _NetworkActivityPredecessor.NetworkActivity AS PredecessorNetworkActivity,
  _NetworkActivitySuccessor.NetworkActivityObject AS SuccessorProjectObjectNode,
  _ProjectNetworkSuccessor.ProjectNetwork AS SuccessorProjectNetwork,
  _NetworkActivitySuccessor.NetworkActivity AS SuccessorNetworkActivity,
  ProjectNetworkObject,
  NetworkActivityIntmsnDuration,
  NetworkActivityIntmsnDurnUnit,
  ObjectIsDeleted,
  TimeIntvlBtwnRelshpInPct,
  TimeInterval,
  FactoryCalendar,
  Plant,
  WorkCenterInternalID
FROM I_ProjNtwkVersRelationship
;

Learn More