I_WBSElementValueHelp

DDL: I_WBSELEMENTVALUEHELP SQL: IWBSELEMENTVH Type: view COMPOSITE

WBS Element Value Help

I_WBSElementValueHelp is a Composite CDS View that provides data about "WBS Element Value Help" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 23 fields with key field WBSElement. It has 2 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_WBSElement WBSElement from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProjectResponsiblePerson _ResponsiblePerson $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
[0..1] I_ProjectApplicant _ProjectApplicant $projection.ApplicantCode = _ProjectApplicant.ApplicantCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWBSELEMENTVH view
EndUserText.label WBS Element Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElement WBSElement
WBSDescription I_WBSElement WBSDescription
Project
ProjectDescription
ResponsiblePerson I_WBSElement ResponsiblePerson
WBSElementIsBillingElement I_WBSElement WBSElementIsBillingElement
WBSIsAccountAssignmentElement I_WBSElement WBSIsAccountAssignmentElement
WBSElementIsPlanningElement I_WBSElement WBSElementIsPlanningElement
ProjectType I_WBSElement ProjectType
ControllingArea I_WBSElement ControllingArea
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter
ProfitCenter I_WBSElement ProfitCenter
ResponsiblePersonName I_WBSElement ResponsiblePersonName
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
ApplicantCode I_WBSElement ApplicantCode
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant 
@AbapCatalog.sqlViewName: 'IWBSELEMENTVH'
@EndUserText.label: 'WBS Element Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_WBSElementValueHelp
  as select from I_WBSElement as WBSElement
  // DPP Changes

  // Person in Responsible for Project

  association [0..1] to I_ProjectResponsiblePerson   as _ResponsiblePerson        on  $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
  // Project Applicant

  association [0..1] to I_ProjectApplicant           as _ProjectApplicant         on  $projection.ApplicantCode     = _ProjectApplicant.ApplicantCode
  
{
  key WBSElement.WBSElement                    as WBSElement,
      WBSElement.WBSDescription                as WBSDescription,
      WBSElement._Project.Project              as Project,
      WBSElement._Project.ProjectDescription   as ProjectDescription,
      WBSElement.ResponsiblePerson             as ResponsiblePerson,
      
      WBSElement.WBSElementIsBillingElement    as WBSElementIsBillingElement,
      WBSElement.WBSIsAccountAssignmentElement as WBSIsAccountAssignmentElement,
      WBSElement.WBSElementIsPlanningElement   as WBSElementIsPlanningElement,
      
      //Following fields used for authorization using DCL

      @UI:{ hidden: true }
      WBSElement.ProjectType                   as ProjectType,
      @UI:{ hidden: true }
      WBSElement.ControllingArea               as ControllingArea,
      @UI:{ hidden: true }
      WBSElement.RespCostCenterControllingArea as RespCostCenterControllingArea,
      @UI:{ hidden: true }
      WBSElement.ResponsibleCostCenter         as ResponsibleCostCenter,
      @UI:{ hidden: true }
      WBSElement.ProfitCenter                  as ProfitCenter,
      @UI:{ hidden: true }
      WBSElement.ResponsiblePersonName         as ResponsiblePersonName,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedAttribute01        as FreeDefinedAttribute01,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedAttribute02        as FreeDefinedAttribute02,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedAttribute03        as FreeDefinedAttribute03,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedAttribute04        as FreeDefinedAttribute04,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedIndicator1         as FreeDefinedIndicator1,
      @UI:{ hidden: true }
      WBSElement.FreeDefinedIndicator2         as FreeDefinedIndicator2,
      @UI:{ hidden: true }
      WBSElement.ApplicantCode as ApplicantCode,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _ResponsiblePerson,
      @UI.hidden: true
      @Consumption.hidden: true
      _ProjectApplicant
} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBYINTERNALKEY",
"I_WBSELEMENT"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More