P_Purordmaintaincustproj

DDL: P_PURORDMAINTAINCUSTPROJ SQL: PPOMAINTCUSTPROJ Type: view CONSUMPTION
7 Fields 4 Data Sources

Customer Project Workpackage

P_Purordmaintaincustproj is a Consumption CDS View that provides data about "Customer Project Workpackage" in SAP S/4HANA. It reads from 4 data sources (I_EngagementProjFinancialPlan, I_EngagementProject, I_WorkPackage, I_WBSElement) and exposes 7 fields with key field WBSElementID.

Data Sources (4)

SourceAliasJoin Type
I_EngagementProjFinancialPlan FinancialPlan inner
I_EngagementProject Project inner
I_WorkPackage ProjectWorkpackage from
I_WBSElement WBSElement inner

Annotations (5)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PPOMAINTCUSTPROJ view
EndUserText.label Customer Project Workpackage view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WBSElementID I_WBSElement WBSElement WBS Internal ID
WBSElement I_WBSElement WBSElementObject Object number
WBSElementInternalID
CustomerProjectWorkPackage I_WorkPackage WorkPackage Plan Item
CustProjWorkPackageName I_WorkPackage WorkPackageName Plan Item Desc.
CustomerProject I_EngagementProject EngagementProject Engmnt Project ID
CustomerProjectName I_EngagementProject EngagementProjectName User Group

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_Purordmaintaincustproj.
-- 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: PPOMAINTCUSTPROJ

CREATE VIEW P_Purordmaintaincustproj AS
SELECT
  WBSElement.WBSElement AS WBSElementID,
  WBSElement.WBSElementObject AS WBSElement,
  ProjectWorkpackage._WBSElement.WBSElementInternalID AS WBSElementInternalID,
  ProjectWorkpackage.WorkPackage AS CustomerProjectWorkPackage,
  ProjectWorkpackage.WorkPackageName AS CustProjWorkPackageName,
  Project.EngagementProject AS CustomerProject,
  Project.EngagementProjectName AS CustomerProjectName
FROM I_WorkPackage AS ProjectWorkpackage
INNER JOIN I_WBSElement AS WBSElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProjFinancialPlan AS FinancialPlan ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProject AS Project ON /* join condition not captured in parsed metadata */
;

Learn More