C_NetworkActivityValueHelp

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_NetworkActivityValueHelp.
-- 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: CNTWKACTYVH

CREATE VIEW C_NetworkActivityValueHelp AS
SELECT
  cast( I_NetworkActivityValueHelp.NetworkActivity as ps_s4_vornr ) AS NetworkActivity,
  I_NetworkActivityValueHelp.ProjectNetwork AS ProjectNetwork,
  I_NetworkActivityValueHelp.NetworkActivityDescription AS NetworkActivityDescription,
  I_NetworkActivityValueHelp.NetworkActivityCategory AS NetworkActivityCategory,
  I_NetworkActivityValueHelp.Plant AS Plant,
  I_NetworkActivityValueHelp.WorkCenter AS WorkCenter,
  I_NetworkActivityValueHelp.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  I_NetworkActivityValueHelp.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  I_NetworkActivityValueHelp.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  I_NetworkActivityValueHelp.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  I_NetworkActivityValueHelp.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  I_NetworkActivityValueHelp.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  I_NetworkActivityValueHelp.WBSElementInternalID AS WBSElementInternalID,
  I_NetworkActivityValueHelp._WBSElement.ResponsiblePerson AS ResponsiblePerson,
  I_NetworkActivityValueHelp._WBSElement.ApplicantCode AS ApplicantCode,
  I_NetworkActivityValueHelp._WBSElement AS _WBSElement
FROM I_NetworkActivityValueHelp
LEFT OUTER JOIN I_ProjectResponsiblePerson AS _ResponsiblePerson ON responsibleperson = _ResponsiblePerson.ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON applicantcode = _ProjectApplicant.ApplicantCode  -- association [0..1]
;