C_PurOrdWBSValHelp
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)
| Source | Alias | Join Type |
|---|---|---|
| I_WBSElementBasicData | I_WBSElementBasicData | from |
| P_PURORDWBSVALHELP | P_PURORDWBSVALHELP | left_outer |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WBSElementExternalID | I_WBSElementBasicData | WBSElementExternalID | |
| WBSElementInternalID | I_WBSElementBasicData | WBSElementInternalID | ||
| WBSDescription | I_WBSElementBasicData | WBSDescription | ||
| ProjectName | P_PURORDWBSVALHELP | ProjectName | Project Name | |
| WorkPackageName | P_PURORDWBSVALHELP | WorkPackageName | Work Package Name | |
| Customer | Customer | Customer Name | ||
| CustomerName | _Customer | CustomerName | ||
| CompanyCode | I_WBSElementBasicData | CompanyCode | Company Code | |
| ControllingArea | I_WBSElementBasicData | ControllingArea | ||
| ProfitCenter | I_WBSElementBasicData | ProfitCenter | ||
| EngagementProject | EngagementProject | |||
| EngagementProjectType | EngagementProjectType | |||
| EngagementProjectServiceOrg | P_PURORDWBSVALHELP | EngagementProjectServiceOrg | ||
| EngagementProjectCategory | EngagementProjectCategory | |||
| AuthorizationGroup | P_PURORDWBSVALHELP | AuthorizationGroup | ||
| IsBusinessPurposeCompleted | P_PURORDWBSVALHELP | IsBusinessPurposeCompleted | ||
| _Customer | _Customer |
@AbapCatalog.sqlViewName: 'CPURORDWBS_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: 'WBSElementExternalID'
@ObjectModel.representativeKey: 'WBSElementExternalID'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.dataCategory:#VALUE_HELP
@EndUserText.label: 'WBS Element Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_PurOrdWBSValHelp
as select from I_WBSElementBasicData
left outer join P_PURORDWBSVALHELP on I_WBSElementBasicData.WBSElementInternalID = P_PURORDWBSVALHELP.WBSElementInternalID
{
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.9 }
key I_WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
@UI.hidden: true
I_WBSElementBasicData.WBSElementInternalID as WBSElementInternalID,
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
I_WBSElementBasicData.WBSDescription as WBSDescription,
@EndUserText.label: 'Project Name'
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
P_PURORDWBSVALHELP.ProjectName as ProjectName,
// @EndUserText.label: 'Work Package'
// @Search: { defaultSearchElement: false, ranking: #HIGH, fuzzinessThreshold: 0.7 }
// WorkPackage.WorkPackage as WorkPackage,
@EndUserText.label: 'Work Package Name'
@Search: { defaultSearchElement: false, ranking: #HIGH, fuzzinessThreshold: 0.7 }
P_PURORDWBSVALHELP.WorkPackageName as WorkPackageName,
@EndUserText.label: 'Customer Name'
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
@Consumption.hidden: true
Customer,
_Customer.CustomerName as CustomerName,
@EndUserText.label: 'Company Code'
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
I_WBSElementBasicData.CompanyCode as CompanyCode,
@Consumption.hidden: true
I_WBSElementBasicData.ControllingArea,
@Consumption.hidden: true
I_WBSElementBasicData.ProfitCenter,
EngagementProject,
EngagementProjectType,
P_PURORDWBSVALHELP.EngagementProjectServiceOrg as EngagementProjectServiceOrg,
EngagementProjectCategory,
P_PURORDWBSVALHELP.AuthorizationGroup,
P_PURORDWBSVALHELP.IsBusinessPurposeCompleted,
@Consumption.hidden: true
_Customer
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA