I_WBSElementWithCodingMask
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)
| Source | Alias | Join Type |
|---|---|---|
| I_WBSElementData_2 | I_WBSElementData_2 | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ProjectResponsiblePerson | _ResponsiblePerson | $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson |
| [0..1] | I_ProjectApplicant | _ProjectApplicant | $projection.ApplicantCode = _ProjectApplicant.ApplicantCode |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA