P_MMIM_WBSElementValueHelp

DDL: P_MMIM_WBSELEMENTVALUEHELP SQL: PMMIMWBSELEM_VH Type: view COMPOSITE

P_MMIM_WBSElementValueHelp is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_WBSElementBasicData) and exposes 12 fields with key fields WBSElement, WBSElementInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData I_WBSElementBasicData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProjectByInternalKey _ProjectKey $projection.ProjectInternalID = _ProjectKey.ProjectInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMMIMWBSELEM_VH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WBSElement WBSElementExternalID
KEY WBSElementInternalID WBSElementInternalID
WBSDescription WBSDescription
Project _Project Project
ProjectDescription _Project ProjectDescription
ResponsiblePerson _ProjectKey ResponsiblePerson
WBSElementIsBillingElement WBSElementIsBillingElement
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
ProjectHasOwnStock _ProjectKey ProjectHasOwnStock
ProjectInternalID ProjectInternalID
ControllingArea ControllingArea
ProfitCenter ProfitCenter
@AbapCatalog.sqlViewName: 'PMMIMWBSELEM_VH'
@AbapCatalog.compiler.compareFilter: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#CHECK
@Search.searchable: true

define view P_MMIM_WBSElementValueHelp as select from I_WBSElementBasicData

association [1..1] to I_ProjectByInternalKey as _ProjectKey on  $projection.ProjectInternalID = _ProjectKey.ProjectInternalID
  
{  
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8 
      @Search.ranking: #MEDIUM 
  key WBSElementExternalID as WBSElement, 
      @UI.hidden: true
      @Consumption.hidden: true 
  key WBSElementInternalID,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8  
      @Search.ranking: #HIGH  
      WBSDescription, 
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8   
      @Search.ranking: #MEDIUM       
      _Project.Project,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8   
      @Search.ranking: #MEDIUM     
      _Project.ProjectDescription    as ProjectDescription,
      
      _ProjectKey.ResponsiblePerson  as ResponsiblePerson,
      WBSElementIsBillingElement,
      WBSIsAccountAssignmentElement,
      _ProjectKey.ProjectHasOwnStock as ProjectHasOwnStock,
      
      @UI.hidden: true
      @Consumption.hidden: true
      ProjectInternalID,
            
      //Following fields used for authorization using DCL

      @UI.hidden: true
      @Consumption.hidden: true
      ControllingArea,
      @UI.hidden: true
      @Consumption.hidden: true
      ProfitCenter     

}