C_PurOrdMaintainWBSValHelp

DDL: C_PURORDMAINTAINWBSVALHELP SQL: CPOMAINTVHWBSEL Type: view CONSUMPTION
6 Fields 6 Data Sources

WBS Element Value Help

C_PurOrdMaintainWBSValHelp is a Consumption CDS View that provides data about "WBS Element Value Help" in SAP S/4HANA. It reads from 6 data sources and exposes 6 fields with key fields WBSElement, PurchasingOrganization.

Data Sources (6)

SourceAliasJoin Type
I_PurchasingOrganization _PurchasingOrganization left_outer
I_EngagementProjFinancialPlan FinancialPlan inner
I_EngagementProject Project_Plan from
I_EngmntProjSrvcOrgDetails ServiceOrg inner
I_WBSElement WBSElement inner
I_WorkPackage WorkPackage inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHWBSEL view
EndUserText.label WBS Element Value Help view
AccessControl.authorizationCheck #CHECK view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WorkPackage WBSElementObject Object number
KEY PurchasingOrganization I_PurchasingOrganization PurchasingOrganization Purchasing Organization
WBSElementInternalID
CustomerProjectName I_EngagementProject EngagementProjectName User Group
CustProjWorkPackageName I_WorkPackage WorkPackageName Plan Item Desc.
CompanyCode I_EngmntProjSrvcOrgDetails AssignedOrganisation Org. Unit Key

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 C_PurOrdMaintainWBSValHelp.
-- 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: CPOMAINTVHWBSEL

CREATE VIEW C_PurOrdMaintainWBSValHelp AS
SELECT
  WorkPackage.WBSElementObject AS WBSElement,
  _PurchasingOrganization.PurchasingOrganization AS PurchasingOrganization,
  WorkPackage._WBSElement.WBSElementInternalID AS WBSElementInternalID,
  Project_Plan.EngagementProjectName AS CustomerProjectName,
  WorkPackage.WorkPackageName AS CustProjWorkPackageName,
  ServiceOrg.AssignedOrganisation AS CompanyCode
FROM I_EngagementProject AS Project_Plan
INNER JOIN I_EngmntProjSrvcOrgDetails AS ServiceOrg 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_WorkPackage AS WorkPackage ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElement AS WBSElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON /* join condition not captured in parsed metadata */
;

Learn More