MMIMWBSElementVH

DDL: MMIMWBSELEMENTVH SQL: MMIMWBSELEMVH Type: view Package: MBND_CLOUD_BL

Value Help for WBS Element

MMIMWBSElementVH is a CDS View that provides data about "Value Help for WBS Element" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectElement) and exposes 28 fields with key field WBSElement. It has 2 associations to related views. Part of development package MBND_CLOUD_BL.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectElement I_EnterpriseProjectElement from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PPM_ProcessingStatusText _StatusText $projection.ProcessingStatus = _StatusText.ProcessingStatus
[1..1] I_WBSElement _WBSELEMENT $projection.WBSElement = _WBSELEMENT.WBSElement

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName MMIMWBSELEMVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value Help for WBS Element view
Search.searchable true view
Consumption.ranked true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY WBSElement ProjectElement
WBSElementInternalID _WBSELEMENT WBSElementInternalID
WBSDescription ProjectElementDescription
Project _Project Project
ProjectDescription _Project ProjectDescription
ProcessingStatus ProcessingStatus
ProcessingStatusText
Plant Plant
_ResponsiblePerson _WBSELEMENT _ResponsiblePerson
_EntProjectResponsiblePerson _WBSELEMENT _EntProjectResponsiblePerson
_ProjectApplicant _WBSELEMENT _ProjectApplicant
ApplicantCode _WBSELEMENT ApplicantCode
ProjectUUID ProjectUUID
_Project _Project
ProjectInternalID ProjectInternalID
ProjectType _Project EnterpriseProjectType
ControllingArea ControllingArea
RespCostCenterControllingArea _WBSELEMENT RespCostCenterControllingArea
ResponsibleCostCenter ResponsibleCostCenter
ProfitCenter ProfitCenter
ResponsiblePerson _WBSELEMENT ResponsiblePerson
ResponsiblePersonName _WBSELEMENT ResponsiblePersonName
FreeDefinedAttribute01 _WBSELEMENT FreeDefinedAttribute01
FreeDefinedAttribute02 _WBSELEMENT FreeDefinedAttribute02
FreeDefinedAttribute04 _WBSELEMENT FreeDefinedAttribute04
FreeDefinedAttribute03 _WBSELEMENT FreeDefinedAttribute03
FreeDefinedIndicator1 _WBSELEMENT FreeDefinedIndicator1
FreeDefinedIndicator2 _WBSELEMENT FreeDefinedIndicator2 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'MMIMWBSELEMVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory:#VALUE_HELP
@EndUserText.label: 'Value Help for WBS Element'
@Search.searchable: true
@Consumption.ranked: true
define view MMIMWBSElementVH as select from I_EnterpriseProjectElement
association [0..*] to I_PPM_ProcessingStatusText  as _StatusText        on $projection.ProcessingStatus = _StatusText.ProcessingStatus
association [1..1] to I_WBSElement                as _WBSELEMENT        on $projection.WBSElement = _WBSELEMENT.WBSElement
{  
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8 
      @Search.ranking: #HIGH
   key ProjectElement as WBSElement, 
       @UI.hidden: true
//      @Consumption.hidden: true  

      _WBSELEMENT.WBSElementInternalID as WBSElementInternalID,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8  
      @Search.ranking: #HIGH
      ProjectElementDescription as 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,
       @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8   
      @Search.ranking: #MEDIUM     
      ProcessingStatus,
      @UI.hidden:false
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8   
      @Search.ranking: #MEDIUM          
     _StatusText[1:Language=$session.system_language].ProcessingStatusText as  ProcessingStatusText,
      Plant,    
      @UI.hidden: true
      @Consumption.hidden: true
      _WBSELEMENT._ResponsiblePerson, 
      @UI.hidden: true
      @Consumption.hidden: true 
      _WBSELEMENT._EntProjectResponsiblePerson,    
       @UI.hidden: true
      @Consumption.hidden: true
      _WBSELEMENT._ProjectApplicant,   
      @UI.hidden: true
      @Consumption.hidden: true
      _WBSELEMENT.ApplicantCode,
      @UI.hidden: true
      @Consumption.hidden: true
      ProjectUUID,
      @UI.hidden: true
      @Consumption.hidden: true
      _Project,
      @UI.hidden: true
      @Consumption.hidden: true
      ProjectInternalID,
      @UI.hidden: true
      _Project.EnterpriseProjectType as ProjectType,
      @UI.hidden: true
      ControllingArea,
      @UI.hidden: true
      _WBSELEMENT.RespCostCenterControllingArea,  
      @UI.hidden: true
      ResponsibleCostCenter,
      @UI.hidden: true
      ProfitCenter,
      @UI.hidden: true
      _WBSELEMENT.ResponsiblePerson,
      @UI.hidden: true
      _WBSELEMENT.ResponsiblePersonName,
      @UI.hidden: true
      _WBSELEMENT.FreeDefinedAttribute01, 
      @UI.hidden: true 
      _WBSELEMENT.FreeDefinedAttribute02  ,  
      @UI.hidden: true
      _WBSELEMENT.FreeDefinedAttribute04 , 
      @UI.hidden: true
      _WBSELEMENT.FreeDefinedAttribute03 , 
      @UI.hidden: true
      _WBSELEMENT.FreeDefinedIndicator1 , 
      @UI.hidden: true 
      _WBSELEMENT.FreeDefinedIndicator2      
      
}    
  where WBSElementInternalID <> '00000000'

Learn More