P_Mpwbs

DDL: P_MPWBS SQL: PMPWBS Type: view COMPOSITE Package: VDM_CPM_WS
11 Fields 4 Data Sources

WBS Details for Master Project List

P_Mpwbs is a Composite CDS View that provides data about "WBS Details for Master Project List" in SAP S/4HANA. It reads from 4 data sources (I_MasterProjectItemList, I_Project, I_SalesDocumentItem, P_WBSObject) and exposes 11 fields. Part of development package VDM_CPM_WS.

Data Sources (4)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_Project ProjectDefinition inner
I_SalesDocumentItem SDItem left_outer
P_WBSObject WBSObject inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMPWBS 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 (11)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID NodeID
MasterProject I_MasterProjectItemList MasterProject Project ID
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType
Project I_Project Project WBS Element
WBSElement P_WBSObject WBSElement WBS Internal ID
WBSElementInternalID P_WBSObject WBSElementInternalID WBS Internal ID
WBSElementObject P_WBSObject WBSElementObject Object number
SalesDocument I_SalesDocumentItem SalesDocument SD Document
SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document 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_Mpwbs.
-- 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: PMPWBS

CREATE VIEW P_Mpwbs AS
SELECT
  MasterProject.MasterProjectUUID AS MasterProjectUUID,
  MasterProject.MasterProject AS MasterProject,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.MasterProjectType AS MasterProjectType,
  ProjectDefinition.Project AS Project,
  WBSObject.WBSElement AS WBSElement,
  WBSObject.WBSElementInternalID AS WBSElementInternalID,
  WBSObject.WBSElementObject AS WBSElementObject,
  SDItem.SalesDocument AS SalesDocument,
  SDItem.SalesDocumentItem AS SalesDocumentItem
FROM I_MasterProjectItemList AS MasterProject
INNER JOIN I_Project AS ProjectDefinition ON /* join condition not captured in parsed metadata */
INNER JOIN P_WBSObject AS WBSObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocumentItem AS SDItem ON /* join condition not captured in parsed metadata */
;

Learn More