I_EntProjSimilarProjBscData

DDL: I_ENTPROJSIMILARPROJBSCDATA SQL: IEPSRPROJDATA Type: view COMPOSITE

Interface view for the Similar Projects

I_EntProjSimilarProjBscData is a Composite CDS View that provides data about "Interface view for the Similar Projects" in SAP S/4HANA. It reads from 3 data sources (I_EnterpriseProject, I_SingleResponsibleForProj, P_EntSimilarProjBscDataUnion) and exposes 25 fields with key fields ProjectUUID, SimilarProjectUUID. It has 1 association to related views.

3 data source(s) 25 fields

Data Sources (3)

SourceAliasJoin Type
I_EnterpriseProject I_EnterpriseProject left_outer
I_SingleResponsibleForProj I_SingleResponsibleForProj left_outer
P_EntSimilarProjBscDataUnion P_EntSimilarProjBscDataUnion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContact I_SingleResponsibleForProj.BusinessPartnerUUID = _UserContact.BusinessPartnerUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEPSRPROJDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interface view for the Similar Projects view
UI.presentationVariant.sortOrder.by ObjectIndicator view
UI.presentationVariant.sortOrder.direction #ASC view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID P_EntSimilarProjBscDataUnion ProjectUUID
KEY SimilarProjectUUID SimilarProjectUUID
ProjectInternalID P_EntSimilarProjBscDataUnion ProjectInternalID
SimilarProjectInternalID SimilarProjectInternalID
Project P_EntSimilarProjBscDataUnion Project
SimilarProject SimilarProject
ProjPredictedSimilarityValue ProjPredictedSimilarityValue
ProjectPredictedFactor ProjectPredictedFactor
PlannedStartDate P_EntSimilarProjBscDataUnion PlannedStartDate
PlannedEndDate P_EntSimilarProjBscDataUnion PlannedEndDate
SimilarProjectDescription SimilarProjectDescription
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency
GlobalCurrency GlobalCurrency
ResponsibleCostCenter P_EntSimilarProjBscDataUnion ResponsibleCostCenter
CompanyCode P_EntSimilarProjBscDataUnion CompanyCode
ControllingArea P_EntSimilarProjBscDataUnion ControllingArea
ProfitCenter P_EntSimilarProjBscDataUnion ProfitCenter
FunctionalArea P_EntSimilarProjBscDataUnion FunctionalArea
PlannedDuration PlannedDuration
TeamMemberCount TeamMemberCount
ObjectIndicator ObjectIndicator
BusinessPartnerUUID I_SingleResponsibleForProj BusinessPartnerUUID
BusinessPartnerFullName I_SingleResponsibleForProj BusinessPartnerFullName
_UserContact _UserContact 
@AbapCatalog.sqlViewName: 'IEPSRPROJDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Interface view for the Similar Projects'
@UI.presentationVariant.sortOrder.by: 'ObjectIndicator'
@UI.presentationVariant.sortOrder.direction: #ASC
@UI.presentationVariant: [{requestAtLeast: 'SimilarProjectUUID'}]
@AccessControl.privilegedAssociations: [ '_UserContact' ]
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel: {
    usageType: {
       serviceQuality:  #D,
       dataClass:       #MIXED,
       sizeCategory:    #XL
   }
}
define view I_EntProjSimilarProjBscData
  as select from P_EntSimilarProjBscDataUnion 
  left outer join  I_EnterpriseProject  on  P_EntSimilarProjBscDataUnion.SimilarProjectUUID = I_EnterpriseProject.ProjectUUID
  left outer join  I_SingleResponsibleForProj   on  I_SingleResponsibleForProj.ReferencedObjectUUID = I_EnterpriseProject.ProjectSummaryTaskUUID  
  association [0..1] to I_UserContactCard as _UserContact on I_SingleResponsibleForProj.BusinessPartnerUUID = _UserContact.BusinessPartnerUUID
  
{
      //I_EntProjSimilarProjBscData

      @EndUserText.quickInfo: ''
  key P_EntSimilarProjBscDataUnion.ProjectUUID,
      @EndUserText.quickInfo: ''
  key SimilarProjectUUID,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.ProjectInternalID,
      @EndUserText.quickInfo: ''      
      SimilarProjectInternalID,
      @EndUserText.quickInfo: ''      
      P_EntSimilarProjBscDataUnion.Project,
      @EndUserText.quickInfo: ''
      SimilarProject,
      @EndUserText.quickInfo: ''
      ProjPredictedSimilarityValue,
      @EndUserText.quickInfo: ''
      ProjectPredictedFactor,
      
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.PlannedStartDate,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.PlannedEndDate,
      @EndUserText.quickInfo: ''
      SimilarProjectDescription,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @EndUserText.quickInfo: ''
      ActualAmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @EndUserText.quickInfo: ''
      PlanAmountInGlobalCurrency,
      @Semantics.currencyCode: true
      @EndUserText.quickInfo: ''
      GlobalCurrency,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.ResponsibleCostCenter,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.CompanyCode,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.ControllingArea,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.ProfitCenter,
      @EndUserText.quickInfo: ''
      P_EntSimilarProjBscDataUnion.FunctionalArea,
      @EndUserText.quickInfo: ''
      PlannedDuration,
      @EndUserText.quickInfo: ''
      TeamMemberCount,
      @EndUserText.quickInfo: ''
      ObjectIndicator,
      @EndUserText.quickInfo: ''
      I_SingleResponsibleForProj.BusinessPartnerUUID,
      @EndUserText.quickInfo: ''
      I_SingleResponsibleForProj.BusinessPartnerFullName,
      _UserContact
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECT",
"I_SINGLERESPONSIBLEFORPROJ",
"P_ENTSIMILARPROJBSCDATAUNION"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More