R_NtwkActyGraphObjectDetailTP

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 R_NtwkActyGraphObjectDetailTP.
-- 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 R_NtwkActyGraphObjectDetailTP AS
SELECT
  _NtwkActByIntKey.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  _NtwkActByIntKey.NetworkActivityInternalID AS NetworkActivityInternalID,
  Hierarchy.ProjectObjectRootNode AS ProjectObjectRootNode,
  Hierarchy.ProjectObject AS ProjectObject,
  _NtwkActByIntKey._ProjectNetworkBasicData.ProjectNetwork AS ProjectNetwork,
  _NtwkActByIntKey.NetworkActivity AS NetworkActivity,
  cast( '' as vsnmr_v ) AS Version,
  _WBSElement.ProjectInternalID AS ProjectInternalID,
  _NtwkActByIntKey.WBSElementInternalID AS WBSElementInternalID,
  _NtwkActByIntKey.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  _NtwkActByIntKey.Supplier AS Supplier,
  _NtwkActByIntKey.NetworkActivityObject AS NetworkActivityObject,
  _NtwkActByIntKey.CostCtrActivityType AS CostCtrActivityType,
  _NtwkActByIntKey.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  _NtwkActByIntKey.OperationImportance AS OperationImportance,
  _NtwkActByIntKey.WorkCenterInternalID AS WorkCenterInternalID,
  _NtwkActByIntKey.NetworkActivityCurrency AS NetworkActivityCurrency,
  _NtwkActByIntKey.ExternalProcessingPrice AS ExternalProcessingPrice,
  _NtwkActByIntKey.CostElement AS CostElement,
  _NtwkActByIntKey.IsMarkedForDeletion AS IsMarkedForDeletion,
  _NetworkActivityDatesQuantity.StandardDuration AS StandardDuration,
  _NetworkActivityDatesQuantity.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivityDatesQuantity.NetworkActivityQuantityUnit AS NetworkActivityQuantityUnit,
  _NetworkActivityDatesQuantity.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivityDatesQuantity.ActualStartDate AS ActualStartDate,
  _NetworkActivityDatesQuantity.ActualEndDate AS ActualEndDate,
  _NetworkActivityDatesQuantity.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  _NetworkActivityDatesQuantity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivityDatesQuantity.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivityDatesQuantity.RemainingWorkQuantity AS RemainingWorkQuantity,
  _NetworkActivityDatesQuantity.ActivityQuantity AS ActivityQuantity,
  _NetworkActivityDatesQuantity.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  _NetworkActivityDatesQuantity.StartDateOffsetDuration AS StartDateOffsetDuration,
  _NetworkActivityDatesQuantity.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  _NetworkActivityDatesQuantity.EndDateOffsetDuration AS EndDateOffsetDuration,
  _NetworkActivityDatesQuantity.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  _NtwkActByIntKey._ProjectNetworkBasicData.ProdAvailyCheckPlanningType AS ProdAvailyCheckPlanningType,
  _NtwkActByIntKey._ProjectNetworkBasicData.ControllingArea AS ControllingArea,
  _NtwkActByIntKey.Plant AS Plant,
  _NtwkActByIntKey._ProjectNetworkBasicData.ProjectNetworkType AS ProjectNetworkType,
  case when _WorkCenter.WorkCenter is null then '' else _WorkCenter.WorkCenter end as WorkCenter AS WorkCenterendasWorkCenter,
  case when _WBSElement._WBSElementShortText.LanguageBasedShortText is not initial then _WBSElement._WBSElementShortText.LanguageBasedShortText else _WBSElement.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
  _NetworkActivityUserFields.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _NetworkActivityUserFields._UserFieldLabel.FreeDfndTableFieldSemanticName AS FreeDfndTableFieldSemanticName,
  _NetworkActivityUserFields.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityUserFields.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityUserFields.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityUserFields.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityUserFields.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityUserFields.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _NetworkActivityUserFields.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityUserFields.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityUserFields.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityUserFields.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  cast( _NetworkActivityUserFields.FreeDefinedAmount1 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount1,
  cast( _NetworkActivityUserFields.FreeDefinedAmount2 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount2,
  _NetworkActivityUserFields.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityUserFields.FreeDefinedDate2 AS FreeDefinedDate2,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute01Label AS FreeDefinedAttribute01Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute02Label AS FreeDefinedAttribute02Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute03Label AS FreeDefinedAttribute03Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute04Label AS FreeDefinedAttribute04Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedIndicator1Label AS FreeDefinedIndicator1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedIndicator2Label AS FreeDefinedIndicator2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedQuantity1Label AS FreeDefinedQuantity1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedQuantity2Label AS FreeDefinedQuantity2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAmount1Label AS FreeDefinedAmount1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAmount2Label AS FreeDefinedAmount2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedDate1Label AS FreeDefinedDate1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedDate2Label AS FreeDefinedDate2Label,
  _NtwkActByIntKey._ProjectNetworkBasicData._OrderType.StatusProfile AS MaintUserStatusProfileCode,
  cast( _NtwkActByIntKey._ActivityTypeText[1:Language = $session.system_language ].CostCtrActivityTypeName as ps_s4_lstar_text ) AS CostCtrActivityTypeName,
  cast( _OperationControlProfileText.OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  _Plant.PlantName AS PlantName,
  cast( _PriorityCode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext ) AS PriorityCodeName,
  cast( _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText as ps_s4_workcentertext ) AS WorkCenterText,
  cast( _NtwkActByIntKey._ProjectNetworkBasicData._OrderType._Text[1: Language = $session.system_language ].OrderTypeName as ps_s4_auarttext) AS OrderTypeName,
  _NetworkActivityCtrlProfile.IsCostActivity AS IsCostActivity,
  _NetworkActivityCtrlProfile.IsServiceActivity AS IsServiceActivity,
  cast( '' as vdm_j_systemstatusname ) AS SystemStatusName,
  cast( '' as vdm_j_user_status_short_t ) AS UserStatusShortName,
  _NtwkActByIntKey.NetworkActivityConfirmation AS NetworkActivityConfirmation,
  _NtwkActByIntKey.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  cast( 'X' as boole_d ) AS NetworkActivityHasPredecessor,
  cast( 'X' as boole_d ) AS NetworkActivityHasSuccessor
FROM I_NetworkActivityByInternalKey AS _NtwkActByIntKey
INNER JOIN I_ProjectObjectHierNodeRltn AS Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NetworkActivityDatesQuantity AS _NetworkActivityDatesQuantity ON ProjectNetworkInternalID = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_OperationControlProfileText AS _OperationControlProfileText ON NetworkActivityControlProfile = _OperationControlProfileText.OperationControlProfile AND _OperationControlProfileText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Prioritycode AS _PriorityCode ON OperationImportance = _PriorityCode.PriorityCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _ConcatenatedStsObjActiveSts ON _ConcatenatedStsObjActiveSts.StatusObject = NetworkActivityObject  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityUserFields AS _NetworkActivityUserFields ON _NetworkActivityUserFields.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivityUserFields.NetworkActivityInternalID = NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityCtrlProfile AS _NetworkActivityCtrlProfile ON _NetworkActivityCtrlProfile.OperationControlProfile = NetworkActivityControlProfile  -- association [1..1]
LEFT OUTER JOIN R_ProjectNetworkRelationshipTP AS _Successor ON _Successor.PredecessorProjNtwkIntID = ProjectNetworkInternalID AND _Successor.PredecessorNtwkActyIntID = NetworkActivityInternalID AND _Successor.ProjectObjectRootNode = ProjectObjectRootNode  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkRelationshipTP AS _Predecessor ON _Predecessor.SuccessorProjNtwkIntID = ProjectNetworkInternalID AND _Predecessor.SuccessorNtwkActyIntID = NetworkActivityInternalID AND _Predecessor.ProjectObjectRootNode = ProjectObjectRootNode  -- association [0..*]
LEFT OUTER JOIN I_OrderConfirmationBasic AS _OrderConfirmationBasic ON NetworkActivityConfirmation = _OrderConfirmationBasic.ConfirmationGroup AND NumberOfOperationConfirmations = _OrderConfirmationBasic.OrderConfirmation  -- association [0..1]
;