I_MasterProjectVH

DDL: I_MASTERPROJECTVH SQL: IMSTRPROJVH Type: view COMPOSITE

Master Project Value Help

I_MasterProjectVH is a Composite CDS View (Dimension) that provides data about "Master Project Value Help" in SAP S/4HANA. It reads from 1 data source (I_MstrProjUsrAuthList) and exposes 7 fields with key field MasterProject. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_MstrProjUsrAuthList MasterProject from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MPStructureElementVH _Master $projection.MasterProject = _Master.MasterProject
[1..1] I_MasterProject _MasterProject $projection.MasterProject = _MasterProject.MasterProject

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMSTRPROJVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Value Help view
Analytics.dataCategory #DIMENSION view
VDM.viewType #COMPOSITE view
Search.searchable true view
ObjectModel.representativeKey MasterProject view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MasterProject
MasterProjectName
MasterProjectType I_MstrProjUsrAuthList MasterProjectType
UserIsInvolved I_MstrProjUsrAuthList UserIsInvolved
MstrProjAccessPrflIsChecked I_MstrProjUsrAuthList MstrProjAccessPrflIsChecked
_Master _Master
_MasterProject _MasterProject 
@AbapCatalog.sqlViewName: 'IMSTRPROJVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.dataCategory: #VALUE_HELP
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Value Help'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@ObjectModel.representativeKey: 'MasterProject'
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.personalData.blockingIndicator: [false]
@Consumption.ranked: true
define view I_MasterProjectVH
  as select from I_MstrProjUsrAuthList   as MasterProject
    //inner join   /cpd/d_mp_hdr_s as MasterProjectText on MasterProject.MasterProjectUUID = MasterProjectText.parent_key    "ATC Error

    association [1..*] to I_MPStructureElementVH      as _Master     on $projection.MasterProject = _Master.MasterProject
    association [1..1] to I_MasterProject     as _MasterProject   on $projection.MasterProject = _MasterProject.MasterProject
{
      @Search.fuzzinessThreshold: 0.8
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @ObjectModel.text.element: 'MasterProjectName'
  key cast(MasterProject.MasterProject as /cpd/cpm_comlprojid)    as  MasterProject,
      @Semantics.text: true
      @Search.fuzzinessThreshold: 0.8
      @Search.defaultSearchElement: true
      @Search.ranking: #LOW
      cast(MasterProject.MasterProjectName as /cpd/cpm_comlprojname)         as  MasterProjectName,         //ATC Error change

      MasterProject.MasterProjectType                               as  MasterProjectType,
      MasterProject.UserIsInvolved                                  as  UserIsInvolved,
      MasterProject.MstrProjAccessPrflIsChecked                     as  MstrProjAccessPrflIsChecked,


      _Master,
      _MasterProject

}








/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MSTRPROJUSRAUTHLIST"
],
"ASSOCIATED":
[
"I_MASTERPROJECT",
"I_MPSTRUCTUREELEMENTVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More