I_WbsElementVersionValueHelp

DDL: I_WBSELEMENTVERSIONVALUEHELP SQL: IWBSELMNTVERSVH Type: view COMPOSITE

Value help view for WBS Element with version

I_WbsElementVersionValueHelp is a Composite CDS View that provides data about "Value help view for WBS Element with version" in SAP S/4HANA. It reads from 1 data source (I_WBSElementVersion) and exposes 13 fields with key fields WBSElement, Version. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_WBSElementVersion I_WBSElementVersion from

Associations (2)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWBSELMNTVERSVH view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Value help view for WBS Element with version view
ObjectModel.usageType.serviceQuality #D view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElementVersion WBSElement
KEY Version I_WBSElementVersion Version
WBSDescription I_WBSElementVersion WBSDescription
Project
ProjectDescription
ResponsiblePerson I_WBSElementVersion ResponsiblePerson
ResponsiblePersonName I_WBSElementVersion ResponsiblePersonName
WBSElementIsBillingElement I_WBSElementVersion WBSElementIsBillingElement
WBSIsAccountAssignmentElement I_WBSElementVersion WBSIsAccountAssignmentElement
WBSElementIsPlanningElement I_WBSElementVersion WBSElementIsPlanningElement
ApplicantCode I_WBSElementVersion ApplicantCode
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant 
@AbapCatalog.sqlViewName: 'IWBSELMNTVERSVH'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Value help view for WBS Element with version'
@ObjectModel.usageType.serviceQuality: #D
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_WbsElementVersionValueHelp
  as select from I_WBSElementVersion
   // 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 I_WBSElementVersion.WBSElement                    as WBSElement,
  key I_WBSElementVersion.Version                       as Version,
      I_WBSElementVersion.WBSDescription                as WBSDescription,
      I_WBSElementVersion._Project.Project              as Project,
      I_WBSElementVersion._Project.ProjectDescription   as ProjectDescription,
      I_WBSElementVersion.ResponsiblePerson             as ResponsiblePerson,
      I_WBSElementVersion.ResponsiblePersonName         as ResponsiblePersonName,
      I_WBSElementVersion.WBSElementIsBillingElement    as WBSElementIsBillingElement,
      I_WBSElementVersion.WBSIsAccountAssignmentElement as WBSIsAccountAssignmentElement,
      I_WBSElementVersion.WBSElementIsPlanningElement   as WBSElementIsPlanningElement,
       @UI:{ hidden: true }
      I_WBSElementVersion.ApplicantCode as ApplicantCode,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _ResponsiblePerson,
      @UI.hidden: true
      @Consumption.hidden: true
      _ProjectApplicant

}

Learn More