P_MstrProjStructure

DDL: P_MSTRPROJSTRUCTURE SQL: PPROJSTRUCT Type: view COMPOSITE
27 Fields 2 Data Sources

P_MstrProjStructure is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ProjectCostObject, I_Project) and exposes 27 fields.

Data Sources (2)

SourceAliasJoin Type
P_ProjectCostObject ProjCostObj from
I_Project Project union

Annotations (6)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
Project P_ProjectCostObject Project WBS Element
ProjectDescription P_ProjectCostObject ProjectDescription Project Name
BusinessArea P_ProjectCostObject BusinessArea Business Area
CompanyCode P_ProjectCostObject CompanyCode Receiver Company Code
ControllingArea P_ProjectCostObject ControllingArea Controlling Area
ObjectInternalID P_ProjectCostObject ObjectInternalID Object number
ObjectName P_ProjectCostObject WBSDescription1 Project Name
ControllingObject P_ProjectCostObject ControllingObject Object number
OrderID P_ProjectCostObject OrderID Order ID
NetworkActivity P_ProjectCostObject NetworkActivity Operation/Activity
ControllingObjectCurrency P_ProjectCostObject ControllingObjectCurrency Valuation Crcy
WBSElementObject P_ProjectCostObject WBSElementObject Object number
WBSElement P_ProjectCostObject WBSElement WBS Internal ID
Project WBS Element
ProjectDescription I_Project ProjectDescription Project Name
BusinessArea I_Project BusinessArea Business Area
CompanyCode I_Project CompanyCode Receiver Company Code
ControllingArea I_Project ControllingArea Controlling Area
ObjectInternalID Object number
ObjectName I_Project ProjectDescription Project Name
ControllingObject I_Project ProjectObject Object number
OrderID Order ID
NetworkActivity Operation/Activity
ControllingObjectCurrency I_Project Currency Valuation Crcy
WBSElementObject Object number
WBSElement WBS Internal ID
ObjectSource

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_MstrProjStructure.
-- 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: PPROJSTRUCT

CREATE VIEW P_MstrProjStructure AS
SELECT
  ProjCostObj.Project AS Project,
  ProjCostObj.ProjectDescription AS ProjectDescription,
  ProjCostObj.BusinessArea AS BusinessArea,
  ProjCostObj.CompanyCode AS CompanyCode,
  ProjCostObj.ControllingArea AS ControllingArea,
  ProjCostObj.ObjectInternalID AS ObjectInternalID,
  ProjCostObj.WBSDescription1 AS ObjectName,
  ProjCostObj.ControllingObject AS ControllingObject,
  ProjCostObj.OrderID AS OrderID,
  ProjCostObj.NetworkActivity AS NetworkActivity,
  ProjCostObj.ControllingObjectCurrency AS ControllingObjectCurrency,
  ProjCostObj.WBSElementObject AS WBSElementObject,
  ProjCostObj.WBSElement AS WBSElement,
  cast('PRJ' as abap.char(3)) AS ObjectSource
FROM P_ProjectCostObject AS ProjCostObj
-- UNION with additional select branch(es): I_Project
;

Learn More