I_NetworkActivityForCostReport

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_NetworkActivityForCostReport.
-- 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: INTWACTFORCSTRPT

CREATE VIEW I_NetworkActivityForCostReport AS
SELECT
  cast ( afko.aufnr as ps_s4_aufnr ) AS ProjectNetwork,
  case when afvc.sumnr is initial then cast( afvc.vornr as ps_vornr) else cast( SuperiorNA.vornr as ps_vornr) end as NetworkActivity AS vornrasps_vornrendasNetworkActivity,
  afvc.aufpl AS ProjectNetworkInternalID,
  afvc.aplzl AS NetworkActivityInternalID,
  cast ( afvc.ltxa1 as ps_s4_ltxa1 ) AS NetworkActivityDescription,
  cast ( afvc.projn as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast ( afko.pronr as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  cast ( afvc.prctr as prctr ) AS ProfitCenter,
  afvc.objnr AS NetworkActivityObject,
  afvc.sumnr AS SuperiorNtwkActivityInternalID,
  afvc.netzkont AS NtwkAccountAssignmentCode,
  afvc.werks AS Plant,
  cast ( afvc.arbid as pph_arbpl ) AS WorkCenter,
  aufk.auart AS ProjectNetworkType,
  afvc.waers AS Currency
FROM afvc
INNER JOIN aufk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_Project AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON afvc.werks = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _ActivityShortText ON _ActivityShortText.Language = $session.system_language AND _ActivityShortText.ProjectApplicationIdentifier = 'PS' AND _ActivityShortText.ProjectObjectType = 'NV' AND NetworkActivityObject = _ActivityShortText.ProjectObjectNode  -- association [0..1]
;