I_MPStructureElementVH
Master Project Structure Element
I_MPStructureElementVH is a Composite CDS View that provides data about "Master Project Structure Element" in SAP S/4HANA. It reads from 1 data source (I_MstrProjStrctrElmntWBC) and exposes 5 fields with key fields MasterProject, ControllingObjectExternalID. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MstrProjStrctrElmntWBC | StructureElement | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_MasterProjectVH | _MasterProjectVH | $projection.MasterProject = _MasterProjectVH .MasterProject |
| [0..1] | I_MasterProject | _MasterProject | $projection.MasterProject = _MasterProject.MasterProject |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMPSTRUCTELEMTVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| EndUserText.label | Master Project Structure Element | view | |
| VDM.viewType | #COMPOSITE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MasterProject | |||
| KEY | ControllingObjectExternalID | |||
| ControllingObjectDescription | ||||
| _MasterProjectVH | _MasterProjectVH | |||
| _MasterProject | _MasterProject |
@AbapCatalog.sqlViewName: 'IMPSTRUCTELEMTVH'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: ['MasterProject','ControllingObjectExternalID']
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Master Project Structure Element'
@VDM.viewType: #COMPOSITE
//@Search.searchable: true "ATC Error
//@ObjectModel.representativeKey: 'ControllingObjectExternalID'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Search.searchable: true
@Consumption.ranked: true
define view I_MPStructureElementVH
as select from I_MstrProjStrctrElmntWBC as StructureElement
association [0..1] to I_MasterProjectVH as _MasterProjectVH on $projection.MasterProject = _MasterProjectVH .MasterProject
association [0..1] to I_MasterProject as _MasterProject on $projection.MasterProject = _MasterProject.MasterProject
{
@ObjectModel: {foreignKey.association: '_MasterProject'}
@Search.defaultSearchElement: true
//@Search.defaultSearchElement: true "ATC Error
key cast(StructureElement.MasterProject as /cpd/cpm_comlprojid) as MasterProject,
//@Search.defaultSearchElement: true "ATC Error
@ObjectModel.text.element: 'ControllingObjectDescription'
@Search.defaultSearchElement: true
//key cast(StructureElement.ControllingObjectExternalID as /cpd/cpm_struct_elm) as ControllingObjectExternalID,
key cast(ltrim(StructureElement.WBSElementShortID,'0') as /cpd/cpm_struct_elm) as ControllingObjectExternalID,
@Semantics.text: true
//@Search.defaultSearchElement: true "ATC Error
cast(StructureElement.ControllingObjectDescription as /cpd/cpm_description) as ControllingObjectDescription,
_MasterProjectVH,
_MasterProject
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MSTRPROJSTRCTRELMNTWBC"
],
"ASSOCIATED":
[
"I_MASTERPROJECT",
"I_MASTERPROJECTVH"
],
"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