I_WBSElementDataStdVH
WBSElement Data
I_WBSElementDataStdVH is a Composite CDS View that provides data about "WBSElement Data" in SAP S/4HANA. It reads from 1 data source (I_WBSElementData_2) and exposes 25 fields with key field WBSElementInternalID. It has 2 associations to related views.
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 (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IWBSDATSTDVH | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.representativeKey | WBSElementInternalID | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| Search.searchable | true | view | |
| EndUserText.label | WBSElement Data | view |
Fields (25)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WBSElementInternalID | WBSElementInternalID | ||
| WBSElementExternalID | WBSElementExternalID | |||
| WBSDescription | WBSDescription | |||
| ProjectExternalID | _Project | ProjectExternalID | ||
| ProjectDescription | _Project | ProjectDescription | ||
| ResponsiblePerson | ResponsiblePerson | |||
| ResponsiblePersonName | ResponsiblePersonName | |||
| WBSElementIsBillingElement | WBSElementIsBillingElement | |||
| WBSIsAccountAssignmentElement | WBSIsAccountAssignmentElement | |||
| WBSElementIsPlanningElement | WBSElementIsPlanningElement | |||
| ProjectType | ProjectType | |||
| ControllingArea | ControllingArea | |||
| RespCostCenterControllingArea | RespCostCenterControllingArea | |||
| ResponsibleCostCenter | ResponsibleCostCenter | |||
| ProfitCenter | ProfitCenter | |||
| FreeDefinedAttribute01 | FreeDefinedAttribute01 | |||
| FreeDefinedAttribute02 | FreeDefinedAttribute02 | |||
| FreeDefinedAttribute03 | FreeDefinedAttribute03 | |||
| FreeDefinedAttribute04 | FreeDefinedAttribute04 | |||
| FreeDefinedIndicator1 | FreeDefinedIndicator1 | |||
| FreeDefinedIndicator2 | FreeDefinedIndicator2 | |||
| _ResponsiblePerson | _ResponsiblePerson | |||
| ApplicantCode | ApplicantCode | |||
| WBSElementObject | WBSElementObject | |||
| _ProjectApplicant | _ProjectApplicant |
@AbapCatalog.sqlViewName: 'IWBSDATSTDVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'WBSElementInternalID'
@ObjectModel.dataCategory: #VALUE_HELP
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Search.searchable: true
@EndUserText.label: 'WBSElement Data'
define view I_WBSElementDataStdVH
as select from I_WBSElementData_2
// 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
{
// @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
@UI.hidden: true
key WBSElementInternalID as WBSElementInternalID,
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
WBSElementExternalID as WBSElementExternalID,
@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
WBSDescription as WBSDescription,
_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,
//Following fields used for authorization using DCL
@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
_ResponsiblePerson,
@UI:{ hidden: true }
@Consumption.hidden: true
ApplicantCode as ApplicantCode,
@UI:{ hidden: true }
WBSElementObject as WBSElementObject,
@UI:{ hidden: true }
@Consumption.hidden: true
_ProjectApplicant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTDATA_2",
"I_WBSELEMENTDATA_2"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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