I_WBSElementWithCodingMask

DDL: I_WBSELEMENTWITHCODINGMASK SQL: IWBSELECODEMSK Type: view COMPOSITE Package: VDM_PS_COST_PROJ_OVERVIEW

WBS Element Data

I_WBSElementWithCodingMask is a Composite CDS View (Dimension) that provides data about "WBS Element Data" in SAP S/4HANA. It reads from 1 data source (I_WBSElementData_2) and exposes 28 fields with key field WBSElementExternalID. It has 2 associations to related views. Part of development package VDM_PS_COST_PROJ_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementData_2 I_WBSElementData_2 from

Associations (2)

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

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IWBSELECODEMSK view
EndUserText.label WBS Element Data view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey WBSElementExternalID view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view
AbapCatalog.preserveKey true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY WBSElementExternalID WBSElementExternalID
WBSElementInternalID WBSElementInternalID
WBSDescription WBSDescription
WBSElementLangBsdDescription
ProjectExternalID _Project ProjectExternalID
ProjectDescription _Project ProjectDescription
ResponsiblePerson ResponsiblePerson
ResponsiblePersonName ResponsiblePersonName
WBSElementIsBillingElement WBSElementIsBillingElement
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
WBSElementIsPlanningElement WBSElementIsPlanningElement
WBSElementHierarchyLevel WBSElementHierarchyLevel
ProjectType ProjectType
ControllingArea ControllingArea
RespCostCenterControllingArea RespCostCenterControllingArea
ResponsibleCostCenter ResponsibleCostCenter
ProfitCenter ProfitCenter
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
ApplicantCode ApplicantCode
WBSElementObject WBSElementObject
ProjectObject _Project ProjectObject
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant
@AbapCatalog.sqlViewName: 'IWBSELECODEMSK'
@EndUserText.label: 'WBS Element Data'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
@ObjectModel.usageType.dataClass: #MASTER
@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions: true
@Analytics.internalName: #LOCAL
@ObjectModel.representativeKey: 'WBSElementExternalID'
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@Consumption.ranked: true
@AbapCatalog.preserveKey:true

define view I_WBSElementWithCodingMask
  as select from I_WBSElementData_2
  association [0..1] to I_ProjectResponsiblePerson as _ResponsiblePerson on $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
  association [0..1] to I_ProjectApplicant         as _ProjectApplicant  on $projection.ApplicantCode = _ProjectApplicant.ApplicantCode
{
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }        
  key WBSElementExternalID          as WBSElementExternalID,
      @UI:{ hidden: true }
      WBSElementInternalID          as WBSElementInternalID,
      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
      WBSDescription                as WBSDescription,
      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
      I_WBSElementData_2._WBSElementShortText.LanguageBasedShortText as WBSElementLangBsdDescription,
      _Project.ProjectExternalID    as ProjectExternalID,
      _Project.ProjectDescription   as ProjectDescription,
      ResponsiblePerson             as ResponsiblePerson,
      ResponsiblePersonName         as ResponsiblePersonName,
      @Consumption.filter: {selectionType: #SINGLE , multipleSelections: false }
      WBSElementIsBillingElement    as WBSElementIsBillingElement,
      @Consumption.filter: {selectionType: #SINGLE , multipleSelections: false }
      WBSIsAccountAssignmentElement as WBSIsAccountAssignmentElement,
      @Consumption.filter: {selectionType: #SINGLE , multipleSelections: false }
      WBSElementIsPlanningElement   as WBSElementIsPlanningElement,
      @UI:{ hidden: true }
      WBSElementHierarchyLevel      as WBSElementHierarchyLevel,

      @UI:{ hidden: true }
      ProjectType                   as ProjectType,
      @UI:{ hidden: true }
      ControllingArea               as ControllingArea,
      @UI:{ hidden: true }
      RespCostCenterControllingArea as RespCostCenterControllingArea,
      @UI:{ hidden: true }
      ResponsibleCostCenter         as ResponsibleCostCenter,
      @UI:{ hidden: true }
      ProfitCenter                  as ProfitCenter,
      @UI:{ hidden: true }
      FreeDefinedAttribute01        as FreeDefinedAttribute01,
      @UI:{ hidden: true }
      FreeDefinedAttribute02        as FreeDefinedAttribute02,
      @UI:{ hidden: true }
      FreeDefinedAttribute03        as FreeDefinedAttribute03,
      @UI:{ hidden: true }
      FreeDefinedAttribute04        as FreeDefinedAttribute04,
      @UI:{ hidden: true }
      FreeDefinedIndicator1         as FreeDefinedIndicator1,
      @UI:{ hidden: true }
      FreeDefinedIndicator2         as FreeDefinedIndicator2,
      @UI:{ hidden: true }
      @Consumption.hidden: true
      ApplicantCode                 as ApplicantCode,
      @UI:{ hidden: true }
      WBSElementObject              as WBSElementObject,
      @UI:{ hidden: true }
      _Project.ProjectObject        as ProjectObject,
      @UI:{ hidden: true }
      @Consumption.hidden: true
      _ResponsiblePerson,
      @UI:{ hidden: true }
      @Consumption.hidden: true
      _ProjectApplicant
}