C_PurOrdWBSValHelp

DDL: C_PURORDWBSVALHELP SQL: CPURORDWBS_VH Type: view CONSUMPTION
17 Fields 2 Data Sources

WBS Element Value Help

C_PurOrdWBSValHelp is a Consumption CDS View that provides data about "WBS Element Value Help" in SAP S/4HANA. It reads from 2 data sources (I_WBSElementBasicData, P_PURORDWBSVALHELP) and exposes 17 fields with key field WBSElementExternalID.

Data Sources (2)

SourceAliasJoin Type
I_WBSElementBasicData I_WBSElementBasicData from
P_PURORDWBSVALHELP P_PURORDWBSVALHELP left_outer

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPURORDWBS_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey WBSElementExternalID view
ObjectModel.representativeKey WBSElementExternalID view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label WBS Element Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WBSElementExternalID I_WBSElementBasicData WBSElementExternalID WBS Element External ID
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSDescription I_WBSElementBasicData WBSDescription WBS Element Name
ProjectName P_PURORDWBSVALHELP ProjectName Project Name
WorkPackageName P_PURORDWBSVALHELP WorkPackageName Work Package Name
Customer Customer Customer Name
CustomerName _Customer CustomerName Name of Customer
CompanyCode I_WBSElementBasicData CompanyCode Company Code
ControllingArea I_WBSElementBasicData ControllingArea Controlling Area
ProfitCenter I_WBSElementBasicData ProfitCenter Profit Center
EngagementProject EngagementProject Engmnt Project ID
EngagementProjectType EngagementProjectType
EngagementProjectServiceOrg P_PURORDWBSVALHELP EngagementProjectServiceOrg Service Org.
EngagementProjectCategory EngagementProjectCategory
AuthorizationGroup P_PURORDWBSVALHELP AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted P_PURORDWBSVALHELP IsBusinessPurposeCompleted Purpose Completed
_Customer _Customer

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_PurOrdWBSValHelp.
-- 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: CPURORDWBS_VH

CREATE VIEW C_PurOrdWBSValHelp AS
SELECT
  I_WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  I_WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElementBasicData.WBSDescription AS WBSDescription,
  P_PURORDWBSVALHELP.ProjectName AS ProjectName,
  P_PURORDWBSVALHELP.WorkPackageName AS WorkPackageName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  I_WBSElementBasicData.CompanyCode AS CompanyCode,
  I_WBSElementBasicData.ControllingArea AS ControllingArea,
  I_WBSElementBasicData.ProfitCenter AS ProfitCenter,
  EngagementProject,
  EngagementProjectType,
  P_PURORDWBSVALHELP.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngagementProjectCategory,
  P_PURORDWBSVALHELP.AuthorizationGroup AS AuthorizationGroup,
  P_PURORDWBSVALHELP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_WBSElementBasicData
LEFT OUTER JOIN P_PURORDWBSVALHELP ON /* join condition not captured in parsed metadata */
;

Learn More