P_Mpnwe

DDL: P_MPNWE SQL: PMPNWE Type: view COMPOSITE
8 Fields 3 Data Sources

P_Mpnwe is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MasterProjectItemList, I_NetworkActivity, I_Project) and exposes 8 fields.

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_NetworkActivity Network inner
I_Project ProjectDefinition inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMPNWE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID NodeID
MasterProject I_MasterProjectItemList MasterProject Project ID
MasterProjectType I_MasterProjectItemList MasterProjectType
Project I_Project Project WBS Element
NetworkActivityInternalID I_NetworkActivity NetworkActivityInternalID Counter
ProjectNetworkInternalID I_NetworkActivity ProjectNetworkInternalID Plan No.f.Oper.
PurchasingDocument I_NetworkActivity PurchasingDocument Purchasing Document
PurchasingDocumentItem I_NetworkActivity PurchasingDocumentItem Purchasing Doc. Item

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 P_Mpnwe.
-- 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: PMPNWE

CREATE VIEW P_Mpnwe AS
SELECT
  MasterProject.MasterProjectUUID AS MasterProjectUUID,
  MasterProject.MasterProject AS MasterProject,
  MasterProject.MasterProjectType AS MasterProjectType,
  ProjectDefinition.Project AS Project,
  Network.NetworkActivityInternalID AS NetworkActivityInternalID,
  Network.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Network.PurchasingDocument AS PurchasingDocument,
  Network.PurchasingDocumentItem AS PurchasingDocumentItem
FROM I_MasterProjectItemList AS MasterProject
INNER JOIN I_Project AS ProjectDefinition ON /* join condition not captured in parsed metadata */
INNER JOIN I_NetworkActivity AS Network ON /* join condition not captured in parsed metadata */
;

Learn More