C_PurOrdWBSValHelp

DDL: C_PURORDWBSVALHELP SQL: CPURORDWBS_VH Type: view CONSUMPTION

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
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
}