I_MPNetworkActivity

DDL: I_MPNETWORKACTIVITY SQL: IMPNWACT Type: view COMPOSITE
12 Fields 2 Data Sources

Get Master Project Network Activity

I_MPNetworkActivity is a Composite CDS View that provides data about "Get Master Project Network Activity" in SAP S/4HANA. It reads from 2 data sources (I_MasterProjectItemList, I_NetworkActivity) and exposes 12 fields with key fields MasterProject, ProjectNetwork.

Data Sources (2)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_NetworkActivity NetworkActivity inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPNWACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Get Master Project Network Activity view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MasterProjectItemList MasterProject Project ID
KEY ProjectNetwork I_NetworkActivity ProjectNetwork Order
NetworkActivity I_NetworkActivity NetworkActivity Operation/Activity
NetworkActivityDescription I_NetworkActivity NetworkActivityDescription
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectItem I_MasterProjectItemList MasterProjectItem
ProjectNetworkInternalID I_NetworkActivity ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_NetworkActivity NetworkActivityInternalID Counter
NetworkActivityObject
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType

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_MPNetworkActivity.
-- 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: IMPNWACT

CREATE VIEW I_MPNetworkActivity AS
SELECT
  MasterProject.MasterProject AS MasterProject,
  NetworkActivity.ProjectNetwork AS ProjectNetwork,
  NetworkActivity.NetworkActivity AS NetworkActivity,
  NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription,
  MasterProject.MasterProjectName AS MasterProjectName,
  MasterProject.MasterProjectItem AS MasterProjectItem,
  NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  cast(concat(concat(NetworkActivity.ProjectNetwork,'-'), NetworkActivity.NetworkActivity) as j_objnr ) AS NetworkActivityObject,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.MasterProjectType AS MasterProjectType
FROM I_MasterProjectItemList AS MasterProject
INNER JOIN I_NetworkActivity AS NetworkActivity ON /* join condition not captured in parsed metadata */
;

Learn More